Table below showing Column A, Column B, Column C and Column D.
Calculation has to be:
If Field1 has ColumnA value, then ignore (Don't Count) Field2 & Field3.
If Field2 has ColumnA value then ignore (Don't Count) Field3 value.
Also total calculated rows should not be more than 3 as there are only 3 Applications.
Column A Column B Column C
xyz Field1 Application1
xyz Field2 Application1
xyz Field2 Application2
abc Field3 Application2
efg Field3 Application3
I want number of times Field 1, Field2 and Field3 is appearing. So the expected result should be
Column A Column B
Field1 1
Field2 1
Field3 1
I find the calculation logic to be very confusing. Could you provide more details on the same, possibly with some example values?
I am trying to get value of different column on the same row.