Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to pick up data from multiple columns ?
Hi,
I have the following table at my worksheet: Each row contains only a text or a number. A B C D 1 Hp Hp <- only one entry per row 2 Qt Qt 3 Kx Kx 4 Qt Qt 5 Hp Hp 6 Kx Kx 2500 May I know what formula to input at cell D1 and copy down to pick up the data from each cell in column A to C as illustrated ? Thanks Low -- A36B58K641 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2002 question for pick from list with autocomplete function | Excel Worksheet Functions | |||
Excel 2002 : How to extract data from columns ? | Excel Discussion (Misc queries) | |||
adding up columns in excel 2002 | Excel Worksheet Functions | |||
Excel 2002 : Formula to pick up codes | Excel Discussion (Misc queries) | |||
Finding common data in multiple columns and rows in Excel | Excel Worksheet Functions |