Search results

Thank you everyone!

Nevermind, I caught the error on my side. Works great!

Hi Luke, worked like a charm on the small scale, but once I put it to my bigger data it returned zeros. Here is my formula: =LARGE((FREQUENCY(($BC$2:$BC$3462=BC2)*$BD$2:$BD$3462,($BC$2:$BC$3462=BC2)*$BD$2:$BD$3462)>0)*($BC$2:$BC$3463=$A2)*($BD$2:$BD$3463),3) BC2:BC3462 has the catagory...

It seems to have something to do with the instances where there is no repeating value. So, if my chart looked like this: category Number Largest 3rd Number Cat 1441868 11475 Apple 879 11475 Cat 239822 11475 Cat 239822 11475 Apple...

No extra spaces and I am confirming the formula with ctrl+shift+enter. It looks like it has to do with the numbers. So when I change one of the number values it returns a #N/A for the MATCH and ROW function. That is what it is showing the new number as when I evaluate the formula.

Great beginning, but in the actual situation I would need cat replaced with "A2" so that when I filled the forumla down it would change depending on what is in column A: =LARGE(IF(MATCH(A2&$B$2:$B$13,$A$2:$A$13&$B$2:$B$13,0)=(ROW($B$2:$B$13)-1),$B$2:$B$13),3) This gives me "#n/a", any...

Hi Everyone, I have two rows of data, a catagory and numbers. I am trying to create a conditional formula that displays the Nth largest number. Right now I am using the formula: Category Number Cat 662100 Cat 11287 Cat 11287 Apple 9439 Apple 3090 Cat...

Hi Hui and SirJB7, Worked like a charm! Thank you guys so much. Chip

Hi SirJB7, Great solution, but the data will constantly be changing and it would be nice to have a formula to keep the cells dynamically updating. I am also sharing with other who will not have the expertise to walk through the steps above :-/ Chip

Hi Hui, They are always in repeating order. Chip

Hi Hui, It is in one cell. Chip

Hi Everyone, I have a list of hard key, carriage spaced data in a cell that contains repeated lines of information. The data in the cell looks like this: Type 1 Type 2 Type 3 Type 3 Type 4 Type 5 Type 5 Any tips on a formula I can use in an adjacent cell to eliminate the doubles...

Hi Everyone, Thank you for your help. I will post in Ashish's forum. Chip

Hi Everyone, I use MConcat a good bit to easily list reoccurring information based on a value. My Go to formula has been: =IFERROR((MCONCAT(UNIQUEVALUES(OFFSET($B$1,MATCH(A2,$A$2:$A$2000,0),,COUNTIF($A$2:$A$2000,A2)))," ")),B2) This will concatenate all the values in Column B for each time...