Excel Data Validation

[vijaylnyadav]

Hi All,

I have a scenario for an assignment.

Consider the following sample data,

Roll Number	Subject	Amount	Error
1011	Fee Installment	23122
1011	Fee Installment	12312
1012	Fee Installment 2	23215
1012	Fee Installment 2	23215
1012	Fee Installment 2	23512

Condition:-

For a particular Roll number(column1) for same subject(column2) amount should not be same.

If same amount is encountered for same subject type then error is thrown in an another column name error otherwise success.

[atcodedog05 · Accepted solution]

Hi @vijaylnyadav 

Here is a workflow for the task. 

Output:

only entries from 2 occurrence are error.

all duplicate entries are error.

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[messi007]

@vijaylnyadav,

Please see the attached workflow:

Hope that helps!

Regards,