Sorry, I take it back. I think you'd need a VBA solution where you loop each cell through the table of prefixes

Report problem with this ad

Mar 4, 2021
10:50:32am

Indy Coug Loquacious Lummox

Report problem with this ad

Indy Coug

Bio page: Indy Coug
Joined: Dec 20, 2001
Last login: Jun 16, 2024
Total posts: 185,536 (9,879 FO)

Report problem with this ad

Messages

Author

Time

Excel question: I've got a series of prefixes and I want to highlight

David Lo Pan

3/4/21 10:28am

Do you need to highlight it? or just flag it somehow?

LeonMarek

3/4/21 10:30am

Would be open to flagging it in an alternative manner

David Lo Pan

3/4/21 10:33am

if all the prefixes are the same length, you can use the Left function to

Cougarclaw

3/4/21 10:31am

This might work. There are some prefixes that are different lengths but I

David Lo Pan

3/4/21 10:42am

Any similar items after the prefixes? Such as a dash or space?

Bin01015

3/4/21 10:46am

Sometimes a dash, sometimes one letter, sometimes another letter, etc.

David Lo Pan

3/4/21 10:50am

How many prefixes in total?

Bin01015

3/4/21 11:04am

120 ish (and growing over time)

David Lo Pan

3/4/21 11:20am

RE: 120 ish (and growing over time)

Bin01015

3/4/21 11:37am

BTW the — is two dashes without a space.

Bin01015

3/4/21 3:04pm

This put me on the right track. I ended up using the following conditional

David Lo Pan

3/4/21 10:03pm

If you have a table of all your prefixes, you can do a vlookup in a separate column for your "column to highlight"

Indy Coug

3/4/21 10:31am

What result would I be putting in the "vlookup in a separate column"?

David Lo Pan

3/4/21 10:45am

Sorry, I take it back. I think you'd need a VBA solution where you loop each cell through the table of prefixes

Indy Coug

3/4/21 10:50am

No worries. I'm so slow at VBA, but should probably take the time to get better

David Lo Pan

3/4/21 10:53am

There is a newer xlookup function that gives you additional capabilities on ranges to return and matching etc. Worth a

Posting on CougarBoard