LinkBack URL
About LinkBacks
Hi All
I have this formula that works, but it's sooo looooong, there has to be a better way of doing it, can some-one with better knowledge shorten it. PFA. If a Macro is the better way to go then that will be fine.
Thanks in advance
Hi All
I have this formula that works, but it's sooo looooong, there has to be a better way of doing it, can some-one with better knowledge shorten it. PFA. If a Macro is the better way to go then that will be fine.
Thanks in advance
Last edited by Floydlevedale; 04-15-2013 at 08:45 AM.
perhaps
=IFERROR(CHOOSE(MIN(LEN(SUBSTITUTE(K4,{"W","Y","P","O","B","G","R"},"")))+1,"ALL","TRI",IF(SUMPRODUCT(--(FREQUENCY(IFERROR(MATCH("*"&{"W","Y","P","O","B","G","R"}&"*",K4,0),""),IFERROR(MATCH("*"&{"W","Y","P","O","B","G","R"}&"*",K4,0),""))))=2,"2PR","1PR")),"NR")
Josie
if at first you don't succeed try doing it the way your wife told you to
@ JP,
Maybe I should just do that. Very impressive formula you provided here, to say the least!on error goto bed
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
@ JP, Thank alot, I am speechless, wish I had your skills, anyway at least there's guys like you around.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks