Excel Data Validation

Question

Hi All,

I have a scenario for an assignment.

Consider the following sample data,

Roll NumberSubjectAmountError1011Fee Installment23122 1011Fee Installment12312 1012Fee Installment 223215 1012Fee Installment 223215 1012Fee Installment 223512

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 Answer

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 😀👍