UNIQUE list of cells ending with...

Hi all,

I'm after a formula which extracts a UNIQUE list of cells that end in a given character (actually, a list of cells that don't end in A,B,C, or D).
I was expecting something broadly along the lines of

Please Login or Register  to view this content.

Thanks

Try this:

=UNIQUE(FILTER($A:$A,(RIGHT($A:$A,1)<>"A")*(RIGHT($A:$A,1)<>"B")*(RIGHT($A:$A,1)<>"C")*(RIGHT($A:$A,1)<>"D")))

No - not unless they are all in the same position!

Time for you to provide a sample workbook with several rows of truly respresentative data with EXPECTED RESULTS mocked up. Then I'll have a look. Not going to guess, though.

Is this what you wanted? If not, upload a file WITH expected answers.

=LET(A,A3:B100,UNIQUE(TOCOL(IF(ISERROR(MATCH(MID(INDEX(A,,2),SEARCH("-",INDEX(A,,2))-1,1),{"A","B","C","D"},0)),INDEX(A,,1),z),3)))

I've realised the letters would actually be embedded in cells (in column B) rather than at the end (like in Column A) , would you mind helping me with an appropriate MID()

Here is my effort:

=LET(
r,B3:B86,
c,CODE(RIGHT(TEXTBEFORE(r,"-"),1)),
--UNIQUE(TEXTBEFORE(FILTER(r,(c<65)+(c>68)),"-"))
)

Or try:

Formula:

Please Login or Register  to view this content.