Excel Discrepancy-URGENT

Hi @Nithinkrishna @ermanoj3101
Excel.xlsx (11.6 KB)
Testing Analysis.zip (10.7 KB)

PFA excel sheet as u can see in “Part Number”(Column V) values are same in v2 & v3
But in “Description”(Column W) value are different.

I just want that whenever “Part Number” are same but having different " Description"
then it should be highlighted like this:-

If possible please append this logic on the attached code.

Thank you :slight_smile:

1 Like

@Nithinkrishna pls help on this case…!!! :slight_smile:

1 Like

Hey @mitul_choudhary

Understood your issue. Coloring the cells in a direct way looks unfamiliar.

We may need to check the possibilities with macro.

But do you really want it to color or any other output format you prefer.

Thanks
#nK

just it’s need to be highlighted
Colouring is prefered

1 Like

Okay let me see what can be done.

This will take a bit time to build just bear with me please.

Thanks
#nK

1 Like

Alright.Thanks :slight_smile:

1 Like

Hi @Nithinkrishna

just for reference u can try this activity:-
image

@Nithinkrishna is it done…?
Thank You :slight_smile:

1 Like

@Nithinkrishna bro are we close…?:slight_smile:
@Nithinkrishna pls HELP…!!

1 Like

Yes yes it’s in progress :slight_smile:

1 Like

@mitul_choudhary will there be multiple matching rows as well ?

I mean different part numbers in the sheet or every sheet will have only one unique part number ?

It has only one sheet in excel in which there will be same part number but different desciption

Like this bot has to identify & highlight those.

Hope it helps

@Nithinkrishna remember same part number & different description can be in different
row too like this, therefore bot has to identify where it is

1 Like

Logic is almost done.

But can i get another sheet like the above with multiple po numbers

Thanks
#nK

@Nithinkrishna is it done…?

1 Like

Not yet @mitul_choudhary Just give me some time pls

If let’s say we have two records with different descriptions then both should be highlighted ? or only the wrong one ?

1 Like

Could you please clarify this ? @mitul_choudhary

1 Like

both like this:-

1 Like

Hi @mitul_choudhary

Please try below code and let me know

The code will highlight the same partnumbers with same description and different description, and you can highlight to the color of your choice
Let me know if you need any changes
Coloring.xaml (26.0 KB)

Thanks and Regards.

1 Like

@vinithareddyk123 it should only highlight same part number with different description.
@vinithareddyk123 pls look

Okay, I will update

1 Like

Hey @mitul_choudhary

Report is ready, Could you please review and confirm…

New_Custom_Copy_Output-071421041554.xlsx (626.4 KB)

Attaching the code as well -
ExcelColoringForDataMismatch.zip (501.9 KB)

Thanks for bearing the time.

#nK

2 Likes