I'm trying to use Match function to match an item number column A along with it's maintenance date column B to another two columns which have item number F and latest maintenance date G. Columns F and G are the unique rows extracted from columns A and B which have many item duplicates with different dates. I've used =Match(A:A,F:F,0) to find which rows the unique item list match Column A and can do the same for Column B with =Match(B:B,G:G,0) ie matching dates but the problem is obviously it will have dates that match other items dates -- I need to Match both A and B's values with the unique F and G values in order to apply conditional formatting to highlight in place rows in the A B columns. I know it's possible just having trouble making the combination of AB match up to FG Anyone help ?
Stanley Mc KeownOP
@Reply 15 months ago
I found a way to make it work -- I hope it's correct. I joined column A with B simply using =A2&B2 and =F2&G2 ... A is an item code and B is a Date ( same with F and G ) but the simple formulas returned a number unique to each combination then it was just a matter of using =Match(M:M,O:O,0) where M and O are the columns with the results of the joined columns as mentioned above.
There's probably a way to do all that finding unique values with latest dates and finding the matching rows in one formula but at least I understand what's going on with the way I achieved it.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
