Hi Everyone. Need help with a formula. In the Sample01, Column A:A, contains 13 values in 1000 Rows. Column B "expected result" is a single Ranked occurrence value.
Column E are the 13 values sorted. Refer to Columns (H1:H13), (I1:I13). (A:1, 121) occurred 26 rows down, "Its the largest number of the 13 values, according to its occurrence, and it is Ranked (1st) and will be listed in column B:1,= 1. (A:2, 112) occurred 19 Rows down. Counting down from A:2, 112 was the 2nd largest number of the 13 values, according to its occurrence, and Column B:2,= 2. Thanks for any help or advice in furthering this request.
Column E are the 13 values sorted. Refer to Columns (H1:H13), (I1:I13). (A:1, 121) occurred 26 rows down, "Its the largest number of the 13 values, according to its occurrence, and it is Ranked (1st) and will be listed in column B:1,= 1. (A:2, 112) occurred 19 Rows down. Counting down from A:2, 112 was the 2nd largest number of the 13 values, according to its occurrence, and Column B:2,= 2. Thanks for any help or advice in furthering this request.
Attachments

19.3 KB Views: 9