Forum Discussion
HELP! Need help filtering or finding xlookup or anyother method of finding specific data ranges
If I have a big dataset and I used conditional formatting to highlight any values from E33:E22354 <10 (including blanks) in yellow, is there a way I could use xlookup or a filter function to find the...
Hello jazzyelsie,
Try something like this:
=LOOKUP(2,1/(I:I=$N1),F:F)
In Column I you have what you want to look for values
In N1 you have what you want to count < 5
In Column F you have what you want to return, the dates.
It would always be a good thing to include the Column letters and row numbers so that we can see the layout of your worksheet and get you a formula that works for your example!
HTH
You're right. I should've included the column letters. The left side are the row numbers, but it is shown in the attached Excel file. I will definitely make that clear next time I post, thank you 🙂
For the lookup formula, if I need the stop time of the row right after the conditional format highlights, would I add a 1? I'm not sure if that makes sense.
For the lookup formula, if I need the stop time of the row right after the conditional format highlights, would I add a 1? I'm not sure if that makes sense.