Selecting Corresponding Data Entries from 2 Columns

[emmceevee]

Hi,

I have a large spreadsheet of species activity data and want to separate information from two columns to create a bar chart of when a certain species is active over a 24-hour period. There are duplicates of each species in one column and a unique corresponding time of activity for that species in another, something like the following:

Species A 23:01
Species B 07:09
Species C 13:45
Species D 08:30
Species A 01:55
Species A 22:07
Species C 15:29


What formula can I enter that only selects Species A and their corresponding times that I can copy into a new spreadsheet?

[hoyasaxa215]

I would just sort by the species column and then add a filter. This will allow you to select the species and copy over all relevant data.

[emmceevee]

Thank you! Just figured out how to actually sort things according to criteria!