View Single Post
      01-03-2008, 03:39 PM   #7
Hawkeye
Brigadier General
Hawkeye's Avatar
No_Country
2070
Rep
4,365
Posts

Drives: '07 Z4 Coupe, '21 X3, '16 GMC
Join Date: Aug 2007
Location: Iowa

iTrader: (0)

Garage List
Quote:
Originally Posted by MCS View Post
use a sumif or a vlookup on the cusomer name to get the orders.

An Excel for dummies book (MS help sucks) can explain the vlookup funciton.
sumif and vlookup will not help adding new companies. sumif would be good if you were just looking for stuff you had to match. (customer on the side and brand along the top) and only if you didn't have a starting quantity you had to worry about. Otherwise you would have to make a presentation tab and a prior month tab or something similar.
__________________
2007 Z4 3.0si Coupe • 6 MT • Black Saphire Metallic • PP • SP
2016 GMC Sierra SLT Z71 Premium Plus 4x4
2017 Harley StreetGlide • Denim Black • V&H Tune
2021 BMW x30i • Phytonic Blue Metallic • Fully loaded
Appreciate 0