Excel Discrepancy-URGENT

Help Studio
, , ,
1

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:-

image
image893×299 10.7 KB

If possible please append this logic on the attached code.

Thank you :slight_smile:

1 Like
2

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

1 Like
3

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

4

just it’s need to be highlighted
Colouring is prefered

1 Like
5

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
6

Alright.Thanks :slight_smile:

1 Like
7

Hi @Nithinkrishna

just for reference u can try this activity:-
image

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

1 Like
8

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

1 Like
9

Yes yes it’s in progress :slight_smile:

1 Like
10

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

11

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.

image
image1346×551 60.8 KB

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

image
image707×566 18.4 KB

1 Like
12

Logic is almost done.

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

Thanks
#nK

14

@Nithinkrishna is it done…?

1 Like
15

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
16

Could you please clarify this ? @mitul_choudhary

1 Like
17

both like this:-

image
image707×566 18.4 KB

1 Like
18

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
19

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

20

Okay, I will update

1 Like
21

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