| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Search for data in a column bring all related items in other colum
I have data in the excel sheet with .A column for OrderNo and B Column for
items for that Order. A B ORD001 ITEM1 ITEM2 ITEM3 ORD002 ITEM4 ITEM1 ITEM5 There are more than thousand orders.I want search for an Order so that it brings all items with it. I cannot use filter in A column as it doesn't recognise blank cell.So Option to repeat order nos in A for every item involves a lot of data entry. Any Solution ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search for a value in one column and find another value from anoth | Excel Discussion (Misc queries) | |||
| Search /Filter vertical Numeric pattern (down single column) | Excel Worksheet Functions | |||
| Problem with search and replace data,thanks for you help in advance. | Excel Discussion (Misc queries) | |||
| Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
Threaded Mode
