Excel Discrepancy-URGENT

[mitul_choudhary]

Hi @Nithinkrishna

just for reference u can try this activity:-

@Nithinkrishna is it done…?
Thank You

[mitul_choudhary]

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

[Nithinkrishna]

Yes yes it’s in progress

[Nithinkrishna]

@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 ?

[mitul_choudhary]

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

[Nithinkrishna]

Logic is almost done.

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

Thanks
#nK

[mitul_choudhary]

@Nithinkrishna is it done…?

[Nithinkrishna]

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 ?

[Nithinkrishna]

Could you please clarify this ? @mitul_choudhary

[mitul_choudhary]

both like this:-

[vinithareddyk123 (Vinitha)]

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.

[mitul_choudhary]

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

[vinithareddyk123 (Vinitha)]

Okay, I will update

[Nithinkrishna]

@mitul_choudhary

e same part number but differe

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

[mitul_choudhary]

Hi @Nithinkrishna
Thank You so much
can u pls add one more logic in this code that should give Find out same part number having different RITC that should be also highlighted like same but using different color.

[mitul_choudhary]

@ermanoj3101 can pls help over here.
Hope it takes less time.

Thanks

[ermanoj3101 (MANOJ)]

Hi @mitul_choudhary ,

Can you test this please, it is done from my end.
Coloring.xaml (31.0 KB)

Output
New_Custom_Copy_Output-071421041554 - Copy.xlsx (353.7 KB)

[Nithinkrishna]

Hey @ermanoj3101

Great help.

@mitul_choudhary I was little away from forum, so not seen your post to help.

Sorry for it
#nK

[mitul_choudhary]

@Nithinkrishna No problem mate.
Thank you so much for all your help & support