Hi,
I'm looking for a formula that returns a value based on ID (second occurrence on wards) and date provided
In the attached file, I want to return a value 'D' in Column C if the data shows duplicate ID in Column B against its respective date in Column A.
Put this formula in C3 and copy down. You don't need it in C2 because it's the first value so there can't be a duplicate above it.
Formula:
Please Login or Register to view this content.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
@6StringJazzer
I think A3 and B3 should be A2 and B2
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
@AlKey, A3 and B3 are correct because the first row where the formula appears is row 3. I tested it in the OP's file before I posted the formula.
Both solutions worked great. Thanks guys.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks