Help filtering out all rows below identifier

[agodwin1250]

Hello,

I am wondering if there is a way to have a filter/formula or other tool which you could write an expression for an identifier and have it also filter out and exclude all rows below?

Essentially, my excel data source has multiple tabs, with each tab representing a different equity option grant. Within each tab is 2 tables which are exactly the same format but one is in USD$ and one is in CAD$, and I only need to extract the USD$

There is a header row which simply says "U.S. DOLLARS" above the USD$, and a row which says "CANADIAN DOLLARS" above the CAD$ (2nd table below USD$) - and so I am wondering if I could have a filter or other tool which could identify and exclude the entire 2nd table in CAD$?

Thanks in advance!

[agodwin1250]

Oh of course, I should have thought about this method with a grouping column, this is perfect.

Thank you!

[atcodedog05 · Accepted solution]

I had it figured when i asked data and didnt make my own that i was gonna be late in answering 😂😂

Mine will also be pretty much same😅

Happy to help 🙂

Cheers and happy analyzing 😀

[atcodedog05]

Thank you 🙂 @agodwin1250 

Happy to help 🙂

Cheers and happy analyzing 😀

[hanykowska]

You're welcome 🙂

Glad it works for you @agodwin1250 !