Filter to get a list of all contained values

Hello,
i need to evaluate a paleo diversity database in RStudio but to be able to do the i need to "clean up" the database first. I do not have much excel experience yet so please excuse my probably mundane questions/requests.

I need to filter a column to get a list of all contained values and how often they occur.
The lithology in which those fossils were found is given for most of the fossils. To evaluate i need to get a list that contains all entered values for a certain column (e.g. 5000*carbonate, 2500*shale etc.)
This is about the N and O column of provided excel file


Please help me solve this by giving step by step instructions since all ive done so far using excel was plotting graphs and doing some simple automated calculations.


Thanks in advance
afridelle

Hi

Or try this approach

Use a new sheet Tabelle2
Copy your column N to Tabelle2!A2 and to Tabelle2!B2
Select the data Tabelle2!B$2:B$50000 and in menu data use remove duplicates
In Tabelle2!C2 use the following formula to count the matchs

Formula:

Please Login or Register  to view this content.

Use in R8 the following formula

Formula:

Please Login or Register  to view this content.

See the file for clarification