Excel Validation_ same Ref number should have same currency

Help Studio
1

Hi all

Input
image

As the input in the excel there is Currency cord and Ref number. For the same Ref number should have same currency. If there is a multiple currency for same ref number have to highlight currency cord.
really appreciate if cane give the work flow

Output
image

2

Hi @Lochana_Bandusena ,

Could you let us know more details of the process ? We did understand Multiple Currencies found for Same Ref No, we need to highlight but why are we highlighting the USD Currency and not the LKR or why not both ? Or are we leaving out the First Currency match ?

Let us know what are your thoughts on this.

3

Hello @Lochana_Bandusena

Are you trying to find the duplicate records in the table if the Ref no is having multiple currency?

Also will this currency be different or always same.

Can you share a sample input file and the output required.

Thanks

4

If there is Multiple Currencies for the same ref number should highlight both

5

@Lochana_Bandusena ,

In that case, The Output would appear as follows :
image

Is this the Expected Output for your case ?

6

Yes that would be the outcome

7

@Lochana_Bandusena ,

Check the below workflow :
Excel_Highlight_DuplicateData.zip (10.5 KB)

For the explanation, Minor comments are provided for the methods used.

There may be a better approach that we could use but we could try with this version and let us know your feedback on this.

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.