Hello so I have multiple subjects in a column with information following in rows along the spreadsheet and have filtered the column so I can select a certain subject with all its information in the rows.
What I would like to be able to do is in another cell make an IF function so that when a certain subject is filtered, it shows the information from the row I need in it but then when there is no filter applied, the information disappears.
Hopefully this makes sense,
Thanks!
Bookmarks