Any help with this is much appreciated.
I have a spreadsheet with 5000+ rows that currently contains two columns. Column "A" is for case numbers, and Column "B" is transaction amounts for those case numbers. There are duplicate case numbers with different transaction amounts ranging from .01 to 10000+, so I can have one case number containing multiple transaction amounts.
Here is my question.
If a case number has an amount <25, is there a way to filter every transaction for that case including the amounts >25?
If that is possible? Is there a way to filter all the 5000+ rows at once? The end result will show every case that has a transaction <25 including >=25.
Thanks in advance!
Bookmarks