Hello - I'm looking for some input on how to solve a particular issue I'm having. I have a need to identify header values for any occurence of an order change. For example; Row 1 contains the header values, and the subsequent rows contain values ranked accoring to their relative values.
A B C D E
1 2 3 4 5
1 2 3 4 5
1 2 3 5 4
In the example above I need to be able to identify the corresponding header values for when the order changes (example, row 4). Without writing VBA, is there a combinations of formulas that can be used to identify those header values (D & E)?
Any insight would be much appreciated.
A B C D E
1 2 3 4 5
1 2 3 4 5
1 2 3 5 4
In the example above I need to be able to identify the corresponding header values for when the order changes (example, row 4). Without writing VBA, is there a combinations of formulas that can be used to identify those header values (D & E)?
Any insight would be much appreciated.
