My Account
Sign up, and you'll be able to customize your font size and more!
Sign up
Report problem with this ad
Start a related thread
Start a related poll
Reply via Boardmail
Mar 4, 2021
10:42
:27
am
David Lo Pan
Playmaker
This might work. There are some prefixes that are different lengths but I
could create a column for each length and combine the results for the flags
Start a related thread
Start a related poll
Reply via Boardmail
Report problem with this ad
David Lo Pan
Previous username
patentattycoug
Bio page
David Lo Pan
Joined
Jul 14, 2011
Last login
May 5, 2024
Total posts
1,918 (6 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
Rhino84
3/4/21 10:38am
Report problem with this ad
Posting on CougarBoard
In order to post, you will need to either
sign up
or
log in
.
Report problem with this ad