Forum Discussion
Selecting the most recent 100 rows according to criteria
I have data with a date and time column. I would like to choose the most recent 100 rows that meet a specific criteria. Have asked an expert and posted in another site, but no answers. Thanks...
Can this not be done with filters?
It would be useful to see an example of your data and what criteria you are trying to match.
Further, I download these files from my Forex trading software files and do not have much expertise in Excel. Until I hear from you, I will attempt to learn how to use the filters.
Thanks for your reply and sorry I'm late in acknowledging it.
Ted