Assigning Category To Downloaded Data Building Fss
Rate this:
(3/5 from 1 vote)
REPORT STRING (E1)
ASSIGNED CATEGORY (F1)
KEYWORD (H1)
NAME CAT (I1)
POS PURCHASE - ARCO PAYPOINT ARCO PAYPOENCINITAS CA
car gas
ARCO
car gas
CHECK CRD PURCHASE 01/25 STARBUCKS USA ENCINITAS CA XXXXXXXXXXXX 324518247
Office expense
Shell
car gas
CHECK CRD PURCHASE 01/25 STARBUCKS USA ENCINITAS CA XXXXXXXXXXXX 98327548374
Office expense
Starbucks
Office expense
Cell F3 formula is: =IF(ISNUMBER(SEARCH($H$2;E3));$I$2;"")&IF(ISNUMBER(SEARCH($H$3;E3));$I$3;"")&IF(ISNUMBER(SEARCH($H$4;E3));$I$4;"")&IF(ISNUMBER(SEARCH($H$5;E3));$I$5;"")&... (up to 100 concatenated formulas!!!)
I have written the above formula to assign a category to the line items in column E according to keywords and their category specified in columns H and I. Is there a more efficient way to solve the problem?
I appreciate if you can give me any help. Thank you. Ric
Riccardo Caruso
Posted by Ric on
There are currently no replies to the "Assigning category to downloaded data building FSs" topic of the Excel Help Forum for Automating Data Analysis Tasks.