I have a spreadsheet that has two tabs, one is a Summary while the other is a WORK LOAD tab.
The WORK LOAD tab has an Item #, Item Type, Location, and Notes columns. The Item # column has various two to four digit item numbers, they Item Type has up to ten types, and the Location tab is either Shop or Vendor.
On the Summary tab, I am trying to summarize by Location, by Item Type (cell A) and then just list the Item #s separated by a comma (cell B).
Example would be:
Shop Items
Truck | 31, 46
Car | 2415, 2788
Trailer | 4183, 4188
Vendor Items:
Truck | 18, 24, 88
Car | 2111, 2218, 2844
Trailer | 4000
It is basically if Location=Shop and Item=Truck then put Item #'s in a cell separated by a comma...repeat for other combinations.
Hope that makes sense. I have a small sample spreadsheet available if that would help.
Thanks in advance for any assistance.
Ray
The WORK LOAD tab has an Item #, Item Type, Location, and Notes columns. The Item # column has various two to four digit item numbers, they Item Type has up to ten types, and the Location tab is either Shop or Vendor.
On the Summary tab, I am trying to summarize by Location, by Item Type (cell A) and then just list the Item #s separated by a comma (cell B).
Example would be:
Shop Items
Truck | 31, 46
Car | 2415, 2788
Trailer | 4183, 4188
Vendor Items:
Truck | 18, 24, 88
Car | 2111, 2218, 2844
Trailer | 4000
It is basically if Location=Shop and Item=Truck then put Item #'s in a cell separated by a comma...repeat for other combinations.
Hope that makes sense. I have a small sample spreadsheet available if that would help.
Thanks in advance for any assistance.
Ray