wrt1mea
asked on
I need an excel formula
Good morning...
I need an excel formula....please see the attached example
I need it to look at Golumn G and if the areas are the same, return the earliest date in Column B for all areas that are the same, in Column D.
7-23-15.xlsx
I need an excel formula....please see the attached example
I need it to look at Golumn G and if the areas are the same, return the earliest date in Column B for all areas that are the same, in Column D.
7-23-15.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Subodh Tiwari (Neeraj)
Since your dates are already sorted, a simple Vlookup will work in this case. But if your dates are not sorted, you will need the formula I suggested to you to get the earliest data that belongs to a specific area.
ASKER
OK, thanks for the comment about sorting dates. I was providing a small sample to illustrate what I needed and should have mentioned that in the production data, the dates will not be sorted.
Formula sktneer provided works perfectly.
Formula sktneer provided works perfectly.
ASKER
Works great!
You're welcome. Glad it worked for you.
One question though, how did the formula suggested by ProfessorJimJam helped you as you also selected that as an acceptable solution specially in the real life when your dates are not sorted?
Was it a courtesy call?
Was it a courtesy call?
ASKER
Yes it was....technically he provided a correct solution, I just failed to mention the specifics of the sort. I awarded him points based on his input and feedback....
Is there an issue with this?
Is there an issue with this?
No. Not at all. I just wanted to check that with you. Nothing else. :)