Count, Cell Address or Numbers Directly (Data Analysis)

[s.paulhuff1]

I have a workbook with species data, such as: **** sapiens, and the sites where data were taken (13). There are multiple rows of species just as there multiple columns of sites. How can I write a function to properly list the number of species at each site, by name? If there is no way to do that... can I properly write a function to give me the cell address of EACH cell with a number >0?

I have tried the function providing the max number or last number greater than zero, but some rows contain up to 30 unique numbers and I would like the cell address of them all OR which species are at each site.

If the data should be transposed, I have no problem doing so...

Thank you

 

[s.paulhuff1]

I have a workbook with species data, such as: **** sapiens, and the sites where data were taken (13). There are multiple rows of species just as there multiple columns of sites. How can I write a function to properly list the number of species at each site, by name? If there is no way to do that... can I properly write a function to give me the cell address of EACH cell with a number >0?

I have tried the function providing the max number or last number greater than zero, but some rows contain up to 30 unique numbers and I would like the cell address of them all OR which species are at each site.


-- removed inline image ---


If the data should be transposed, I have no problem doing so...

Thank you