Hi,
I need help in Excel. Hope someone help me to get answer on this.
I have huge data in excel where I need to search SAME entries.
e.g. For your example upload one sample data excel sheet.
In two workspace in single excel in that each workspace 2 columns and 20 rows there.
Both workspace B Column data added. Base on the first 3 digits search in full sheet and whichever is not common data in both workspace highlight with color.
For more information attached excel sheet.
Regards,
Avinashplace
I'm not sure if I follow your description. But... use this as the Conditional Formatting formula in WS1:
=ISNUMBER(MATCH(LEFT(B2,3),LEFT('Workspace 2'!$B$2:$B$22,3),0))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Re: Need help for data verification
HI,
Nu luck with provided formula.
Anything else can you suggest.
Regards,
Avinashplace
Try this formula in Conditional Formatting.Formula:
Please Login or Register to view this content.
Is this the result you are looking for in 'Workspace 1'?
Row\Col Name Number A B c D E F G H I J K L M N O P Q R S T U
Dave
I may be looking at this wrong... but would you want C,D,G,M,N,Q in workspace 1 to be the "Highlighted" records as they all have unique leading 3 CHAR?
Last edited by ELeGault; 05-26-2017 at 09:20 AM.
-If you think you are done, Start over - ELeGault
Here is my formula (again) in a sheet, showing that it does do what I intended it to do. If that is NOT what you want, please save us all a lot of time and provide some manually calculated answers.
@ Glenn
Yup. That's what I got with your previous.
So I tried "interpreting" another way which I am sure can't be right.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks