IDENTIFY LARGEST 3 VALUES TO CREATE INDICATOR COLUMNS
Hi,I'm a trying to compare across column values (Utility A to Utility E) to identify the largest 3 values and put the results into indicator columns ("Top 3 - A" to "Top 3 - E"). So, if "Utility A" is one of the largest 3 values in the row, "Top 3 - A" would receive a "1". If the value is NOT one of the 3 largest in the row, "Top 3 - A" would receive a "0". I tried using "Match", but wasn't abl...