Hello,
I'm trying to use the following formula to filter data based on "Service Type" and it seems to work on one of the service types but not the other...
here is the formula
Notice the highlighted red text, this is where I'm trying based it on "Service Type"=IF(LEFT(A5,1)="0","Both",IF(OR(A5="SERVICE",A5="REVENUE",A5="REVENUE",A5="CIC",A5="RAO",A5="CARRIER NAME",A5="TYPE",A5="RECORDS",A5="INCLUDING TAX",A5="BEFORE TAX",A5="FEDERAL TAX",A5="PROVINCIAL TAX"),"Both",IF(LEFT(D5,3)="REG","Table1",IF(OR(D5="900"),"Table2",IF(A6="",IF(B6="","XXX","TRUE"),"XXX")))))
I have also attached on example workbook, the items highlighted in green should marked as "Table1" and items highlighted redish orange should be marked as "Table"
Wierd thing is that I use a similar formula in another workbbok and it seems to work fine....
Any suggestions ??? please and thank you in advance,
Arv
Bookmarks