Lotto numbers to have L H or P C

[_Richard]

G'day people,
Need a formula to display L and H.
Example 6 lotto numbers - 10 13 20 23 29 45 next to the drawn numbers L L L H H H
Low numbers 1 to 22
High numbers 23 to 45
The other idea is to display primes / composites example - P P C P C C.
Thank you.

[Sam Capricci]

are each of these numbers in their own cells? Like 10 in A2 and 13 in B2 and 20 in C2 etc.? and where do you want the L L L H H H to appear?
If that is what you want put this in G2 and drag right... =IF(A2="","",IF(A2<23,"L","H"))

[CK76]

If all lotto numbers are in same cell... (say in A2).

In B2:
=IF(FILTERXML("<a><b>"&SUBSTITUTE($A2," ","</b><b>")&"</b></a>","//b["&COLUMN(A1)&"]")<23,"L","H")
Copy across to G2 and down.

Or if result is desired in single cell. Provided that you have Office 365 subscription.
=TEXTJOIN(" ",TRUE,IF(FILTERXML("<a><b>"&SUBSTITUTE($A2," ","</b><b>")&"</b></a>","//b")<23,"L","H"))

Confirmed as array (CTRL + SHIFT + ENTER)

[shg]

	a	b	c	d
1		l/h	p/c
2	2	l	p	b2: =if(a2 <= 22, "l", "h")
3	13	l	p	c2: =if(a2 = 2, "p", if(or(mod(a2, {2,3,5,7,9}) = 0), "c", "p"))
4	20	l	c
5	23	h	p
6	29	h	p
7	45	h	c

[Sam Capricci]

Richard, I take it from the private message you sent me that I might have given you what you wanted. If so, glad I could help. Don't forget to mark the post as solved using the thread tools dropdown at the top of the post AND you can thank any and all who've spent time trying to help by clicking on *Add Reputation below their post as that is how we advance on this forum.

[shg]

Richard,

Please post your questions in the forum, not in PMs.

Gracias.