I need to identify that all the diags listed to the left are captured in the New Diags
IdentifyDuplicateswithcdeandhghlght (1).xlsx
I had an issue previously however this is a little different. I need to identify out of 24 diags that are in a in row (starting at A2:X2) that they are also captured in the New Diag listing(starting at z2:aw). There are multiple duplicates and blank spaces. I would like to identify the ones where there are unique ones per row and highlight just those and have those values identified in a rows to the left. ie... i10, e039
Last edited by rzcb; 01-29-2024 at 08:10 AM.
You could use the following formula.
Formula:
Please Login or Register to view this content.
You may need to user [Ctrl]+[Shift]+[Enter]
Last edited by DJunqueira; 01-29-2024 at 09:16 AM.
I tried your formula and it seems to work well with the exception of handling the latter part of my query request... I would like to identify the ones where there are unique ones per row and highlight just those and have those values identified in a rows to the left. ie... i10, e039
Can you show the expected result in the sheet? In my mind I delivered the expected result that was in the sheet.
Formula to point the unique values as = to 1.
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks