Assigning category to downloaded data building FSs

Excel Help for Assigning Category To Downloaded Data Building Fss in Automating Data Analysis Tasks

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 05 Mar 2007

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. Post Reply