Filter to get a list of all contained values

[afridelle]

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