Can I extract data from excel filtering a specific search word and its associated value on the next column?

Hello. I have an excel sheet and there is a column with different names of data, for example my column can have O2, oxygen or iron. the next column has actual number values. I know on excel you can filter your column to only show "O2" for example. Is there a way to do this with Matlab? I want to extract all the values on the column next to the names but only the values that match "O2"

Answer 1

[Emmanouil Tzorakoleftherakis]

Hi Karla,

You can do this by proper indexing of the columns. Please see code sample below:

data = {'O2', 5;'oxygen', 3;'iron', 2};
filtered = data(strcmp(data(:,1),'O2'), 2)

Note that in order to keep the data in the same array, you have to use cell arrays.

[Srikanth Reddy Pyata]

Can you add input and output format so that it is more readable