Rows of comma-delineated numbers, possible to rank in order of appearance?

[Jennifre]

Dear friendly Excel-experts,

I have mostly manually compiled a column of comma-delineated numbers, in column R. So my data looks like this:

P----------Q----------R----------
-|----------y|----------3, 5, 8
+|---------y|----------3, 8,
- |---------y|----------5, 8, 11
- |---------y|----------5, 8,


GOAL DATA, to happen in the cells under rows in R, WILL LOOK LIKE THIS IF POSSIBLE. ("Total" not req'd):

TOTAL-----------------8 (4)
------------------------5 (3)
------------------------3 (2)
------------------------11 (1)


Thank you so, so much in advance!!

 

[AlanY]

have you tried the text-to column function with "," as delimiter, and use countif() to get the results?

 

[Jennifre]

AlanY -- thank you!! No, I am an Excel Dunce, so do not know the "text-to column function," but will look it up and see if I can make sense of it now.

 

[AlanY]

quite simple really

select the whole column or just the Cells with data, from the menu > data > text to column > check delimiter

<img src="https://www.pixelsbin.com/images/2019/07/12/2e793758e54c910b0.jpg" alt="2e793758e54c910b0.jpg" border="0">

select comma and finish

<img src="https://www.pixelsbin.com/images/2019/07/12/33d26f404725ca5c9.jpg" alt="33d26f404725ca5c9.jpg" border="0">

you should ended up with this

<img src="https://www.pixelsbin.com/images/2019/07/12/405881f5862afbed2.jpg" alt="405881f5862afbed2.jpg" border="0">

then with a countif()

Book1
	R	S	T	U	V	W	X
1	3	5	8			3	2
2	3	8				5	3
3	5	8	11			8	4
4	5	8				11	1
Sheet1

Cell Formulas
Range	Formula
X1	=COUNTIF($R$1:$T$4,W1)

 

[Jennifre]

@AlanY -- Gosh, I loved that crafty idea. ... Unless there is a manner of setting COUNTIF() as a delimiter in the Text-to-Column Data treatment option that is outside of the Text-to-Column data ... interface, it doesn't seem to be possible to try.

Choosing "Other" with the open input field (it appears) only allows 1 (one) character. Thank you for the idea, though!!

 

[Jennifre]

Oh thank you again!

I think you are indicating that this NEEDS to be done in two steps?

Is it not possible to get your result reference just one column of comma-delineated number strings? (Which is what I have)