Hi,
I'm not even sure the correct terminology to use to explain, but here goes.
I have 10 species recorded across 8 grids - some as historic records (H) and some as recent records (R). I'm trying to simply summarise whether they were recorded "H", "R" or "H, R" at the whole site (of 8 grids).
I've used countif to get just "H" (see example in spreadsheet), but tried to multiplex countif to do "R" and "H, R" and failed dismally. For my brain, I guess I could do three columns - one for H, one for R and then concatenate. However, this example is just one site and I have many many sites (of multiple grids) to deal with and adding 3 columns everywhere will get messy very quickly. I also have some 1500 species.
I'm sure it is straight forward and the brains trust here will be all over it. Thanks for your anticipated help.
fishy
Bookmarks