Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Condense data for stock ordering
Hi all,
Can anybody help with this problem, I have column A and B in another worksheet and I want to condense the list to only the information in columns D and E. I have the formula for column E (thanks to Luke), I now just need the formula for column D. Incidently, the formula in column E is =IF(D2="","",(SUMIF($A$2:$A$12,D2,$B$2:$B$12))) A B D E Fabric Quantity Fabric Quantity Chenille 10 Chenille 230 Chenille 20 Pampas 200 Chenille 30 Aster 230 Pampas 40 Pampas 50 Aster 60 Aster 70 Chenille 80 Chenille 90 Aster 100 Pampas 110 -- Kind regards, Stevet -- Kind regards, Stevet |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
set up a stock ordering system in excel working backwards | Setting up and Configuration of Excel | |||
Re-Ordering Data Sets in Charts | Charts and Charting in Excel | |||
using VLOOKUP to condense data on separate spreadsheet | Excel Worksheet Functions | |||
a data ordering question | Excel Discussion (Misc queries) | |||
free templates for stock ordering, etc. | Excel Discussion (Misc queries) |