LinkBack URL
About LinkBacks
Good Afternoon everyone,
I have a list of data and I need to pull from that a list of those that are over the Max limit and the corresponding date.
TestBook1.xlsx
Any help is greatly appreciated.
Good Afternoon everyone,
I have a list of data and I need to pull from that a list of those that are over the Max limit and the corresponding date.
TestBook1.xlsx
Any help is greatly appreciated.
Try this...
Enter this formula in E3 and copy across to F3:
=IFERROR(INDEX(A:A,AGGREGATE(15,6,1/($B$3:$B$20>$B$2)*ROW($B$3:$B$20),ROWS(E$3:E3))),"")
Format E3 as Date and F3 as General
Select E3:F3 and copy down until you get blanks.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thanks for the help. That worked for the sheet I posted but I can't get it to work in my actual sheet so I am including a portion of it instead. Work your magic please.
Test Book 2.xlsx
OK, try these...
Entered in I9:
=IFERROR(INDEX(A:A,AGGREGATE(15,6,1/(E$9:E$38>E$4)*ROW(E$9:E$38),ROWS(I$9:I9))),"")
Format as m/d/yyyy h:mm
Entered in J9:
=IF(I9="","",VLOOKUP(I9,A$9:E$38,5,0))
Select I9:J9 and copy down until you get blanks.
Works great. I sure appreciate your help Valko.
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks