Search results

Hi GraH, Great Advice, and I agree. ..and...(( your help is Exemplary!!))+10

Hi Eloise T. I included an update in Sample001. 13 Values in Column (A) are numbered according to Occurrence. (Most recent) would be 13th. The previous cell 12th. This process repeats from the beginning in each cell going downward. Thank You, CMLET

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...

Hi John J.V. You are Mr.Excel(lent)!!! Truely amazing!! Thank You!

Hi p45cal! You're amazing! I've been at it an gave up like GraH. Now I back in business! How did you come up with Transpose?? Many Thanks and appreciations.

H GraH. All or nothing...take a quick look at Sample05. Row1 columns (d~p) are 13 rank'd i.d.'s for the 13 values. Column B are expected Ranks. The values in cell Columns (d~p) are chronological order (no duplicate) across. Yellow highlights show in Row 1 (d~p) the corresponding Ranks...

=SUMPRODUCT((A2:INDEX(A2:A$1002,MATCH(A1,A2:A$1002,0))<>"")/COUNTIF(A2:INDEX(A2:A$1002,MATCH(A1,A2:A$1002,0)),A2:INDEX(A2:A$1002,MATCH(A1,A2:A$1002,0))&"")) Hi GraH. You are terrific! However, this needs to be used as the "next offset" column which I am not sure how to incorporate. Many...

=RANK(B1,OFFSET($B$1,MATCH(A1,$A$1:$A$100,0)-1,,COUNTIF($A$1:$A$100,A1),)) this partially works. Needs some adjustments.

Hi GraH. the last Sample04...(A:18 cell) 123, the rank in (B:18)= 11 because at that starting point the 123 occurred 3 rows down. (A:21 cell) 123 occurred 26 rows from that starting point and the (B:21 cell) rank is 1. All 13 values are counted down from each starting point and ranked...

Hi GraH. In Sample04, (A:1) 211. Please refer to Column; (E:12). Occurrence in Column (F:12) is "3" and in Column (G:12), the rank is "11". Column (A:2), 121 highlighted in blue... occurrence is "26" and the rank is "2". =MATCH(A1,A2:$A$1000,0) only lists the last occurrence per the...

Thank You for your assistance. In Sample03 I put the "expected" values in (B:1 ~ B:62) manually. GraH, your helper taables are awesome, but I was still getting a different result??

Hi, In Sample02, I've inserted a new cells A:1, B:1 highlighted. 122 is Ranked 1 in (B:1) because it occurred 19 rows down. Example; (H:2, I:2). If I had written 121 in (A:1), (B:1) would then be Ranked 13. I suppose this calculating process is independently from its previous cell?? Thank...

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...

Hi Bosco. Awesome! Thank You very much.

Hi everyone, need some help with a formula. The Sample1 Column A contains 125 values in 6500 rows. Column D contains only the 125 values sorted, and Column E are corresponding values. The expected results (manually entered in B1:B4) .

Hi Bosco. Simply put...it works awesome! Thank You.

Hi Hui. I like the 5 scores in categories suggestion! This is a work in progress project, and I'm trying out a variety of scenarios.

Hi All. I've search through the posted threads for a RANK formula. I'm trying to Rank the values in Column D, 1 through 5. The desired results examples are listed in Column E. I've sorted Column B lowest to highest. Would it help to combine =B&C first? Thanks for any help.

Hi Bosco. You are correct. I had manually entered the values incorrectly (6). The formula you have provided works beautifully. Thank You!

Hi Gentleman and Ladies. Im trying a formula in D. (not too good) My desired results are in Column C. of the Sample01: I'm looking to count backwards from each value in B. Example: Column A1 221, B1 96, C1 96. Scroll to A188. Column B188 96, Column C188 95. The Sample01 is a shortened...

Hi Hui, the occurrences are in C and the number of occurrences in D. Rows 60:71 in D (6) 3's and (4) 4's. Column L listed by rank numbers.

Hi Ron. Works terrific! You're Awesome. Thank You.

Hello. I need a formula/or correction, or both? The sample file in Column D =COUNTIFS(B:B,B1,C:C,C1). Column E =SUMPRODUCT(--(B1=$B$1:$B$76),--(D1<$D$1:$D$76))+1. I need a formula/or a correction to get the values in Column E to look like the values in Column"L".

Thank you.

The sample sheet shows some data in columns A and B. Column C is Blank. The expected results are illustrated and listed in columns E,F,G. Notice the number 444 in column A. In column B the number 1 totals (8) occurrences, within that group of number, and the number 3 (5) occurrences, etc...