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.
I appreciate your reply and will attach an xlsx file. I am sorting by the Close Date column (N) and would like to pick the 100 most recent rows that are >0 in the Profit column