Solved Excel 2007 IF ISERROR

Microsoft Office excel 2007
June 1, 2012 at 01:32:54
Specs: Windows 7
I have a column of text that can contain the following, CD; GS; SF; SF; FA; FG; FG; GF; GG; NG; NG; SG; FC; FC; GC; GE; MP; SS;
Where the two letter code relates to a Service. The record may have one or more of the services, so I need to split them out matrix style into columns labelled GS, SF etc., and was hoping to use something like this formula:


but am not sure how to add all the possible options - take FA and FG which are basically the same service, and the non matches get a - or even just a blank and the matches get a Y for yes.
Any ideas?

See More: Excel 2007 IF ISERROR

Report •

June 1, 2012 at 10:37:33
✔ Best Answer
Any ideas?

Not sure what it is your doing.

I need to split them out matrix style into columns

Post a small example of your spreadsheet, with a before & after example
BUT first read this How-to on how to post data or code in this forum:


Report •

June 3, 2012 at 10:31:41
I'm not sure I understand your question, but perhaps you could use an OR function.



Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question