Example:
Blue Male US Ford
Blue Female US GM
Green Male US Toyota
Green Female US Buick
Red Male CN Ford
Red Female US GM
Is there an excel formula that will create new worksheets that will only include:
worksheet 2:blue data files
worksheet 3:green data files
worksheet 4:red data files
All help would be greatly appreciated
2007-12-15 06:29:54 · 2 answers · asked by Anonymous in Computers & Internet ➔ Software
HLOOKUP and VLOOKUP, easy to use.
2007-12-15 06:39:45 · answer #1 · answered by Ken 7 · 0⤊ 0⤋
purely purely set each and every cellular interior the 2nd artwork sheet to equivalent the fee of the 1st artwork sheet - then make specific all values that are replaced are replaced interior the 1st sheet purely i.e. click interior the cellular of artwork sheet 2, press "=" interior the formula bar then tab to sheet a million and choose the corresponding cellular
2016-11-27 02:59:06 · answer #2 · answered by snelling 4 · 0⤊ 0⤋