Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Help - Urgent
I have info that looks like this:
AD0# Cost C D E F A B A 6567 6568 6567 $2,200.00 B $2,200.00 $400.00 $400.00 $400.00 6568 $400.00 $2,200.00 $140.00 6988 $400.00 7999 $400.00 AD0# Cost 6567 $2,200.00 7999 $140.00 I would like to auto fill C,D,E,F with the info from column "A" only if it is a unique # and have all the costs (column B) for that unique # line up under it. If a number from column "A" already exists in C-F, then I want just the costs to autofill under the correct #. I want to end having one column for each number with all costs for that # under it. Make sense? Any help with this one is appreciated. DL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IME MODE FOR EXCEL 2007 (URGENT URGENT) | Excel Discussion (Misc queries) | |||
Need Help with Formula-urgent | Excel Worksheet Functions | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Urgent Formula Help | Excel Discussion (Misc queries) | |||
Urgent Formula! | Excel Discussion (Misc queries) |