Hello everyone, I'm working on a formula, need help. Attached file Sample001, Column (A) are 13 values in 500 Rows. Desired results are in cells C2:C31~O2:O31.
The current row cell in Column (A2) represents; 13th of the 13 values, exclude duplicates, then 12, 11, 10 so on. Example in Column (R2)(S2). Note: In Column (A3) the value 132 is 13th of the 13 values as indicated in Column (H3). Sincerely, CMLET.
The current row cell in Column (A2) represents; 13th of the 13 values, exclude duplicates, then 12, 11, 10 so on. Example in Column (R2)(S2). Note: In Column (A3) the value 132 is 13th of the 13 values as indicated in Column (H3). Sincerely, CMLET.