Hi
I have master data on one tab (1000 rows, 74 columns). I'd like to create subsets of the data in various tabs based on criteria (Col G - see attachment).
I tried using IF formula to return the data which works fine until I get a FALSE.
=IF(Data!$G3="Sport",Data!A3)
Could you please help with a formula that instead of getting the false the formula looks to the next cell?
Here is sample of the data attached. The attached example has the main data one the first tab, the second tab gives my formula result in the first 11 rows and shows what ideally I am looking for in rows 14 - 20.
Thanks in advance for your help .
Betty
Bookmarks