amit_gupta123
Member
Hii
Please help me out to define the formula to compare the values in three columns with eachother. Sample data looks like as under
Sno A B C Result
1 1000 1000 1000 All values are equal
2 1000 1500 2000 No Values are matching with eachother
3 1000 1000 1500 Value A & B are matching but both are not equal to C
4 1000 1500 1000 Value A & C are matching but both are not equal to B
5 1000 1500 1500 Value B & C are matching but both are not equal to A
I find above combinations.
Regards
Please help me out to define the formula to compare the values in three columns with eachother. Sample data looks like as under
Sno A B C Result
1 1000 1000 1000 All values are equal
2 1000 1500 2000 No Values are matching with eachother
3 1000 1000 1500 Value A & B are matching but both are not equal to C
4 1000 1500 1000 Value A & C are matching but both are not equal to B
5 1000 1500 1500 Value B & C are matching but both are not equal to A
I find above combinations.
Regards