=if(isnumber(e11),"sent to bdd",if(or(and(isnumber(e11),isnumber(f11))),"medfocus letter sent",if(and(isnumber(e11),isnumber(f11),isnumber(g11)),"mds lancet letter sent","")))
=if(isnumber(e11),"sent to bdd",if(or(and(isnumber(e11),isnumber(f11))),"medfocus letter sent",if(and(isnumber(e11),isnumber(f11),isnumber(g11)),"mds lancet letter sent","")))
Hello Frederick AB,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi,
I've been anlaysing exported ticket data in excel and need to show a simplified version of our 6 On Hold & 3 Work In Progress statuses, the other statuses dont need to be simplified they can remain 'as is'.
I've come across a few articles about ISNUMBER & SEARCH as an alternative to 'contains partial text string' as excel doesn't offer this functionality, in the below screenshot I've listed some example data (column A-C), all the status variables in column E and a formula I've been toying with as another alternative - I'm aware the formula in the screenshot wont work its just to show what i'm trying to achieve - which is to: Show any On hold - TBC status as On Hold, any WIP - TBC status as WIP and return all others with original status.
Screenshot 2020-06-09 at 18.47.46.png
I've not found a formula that works yet and would prefer to not have to add all 12 statuses to get a result, plus I need to return more than 2 options.
Welcome any feedback!
Thanks, Karen
Last edited by lady_kay; 06-09-2020 at 01:48 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks