Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Issues
I have 2 excel lists, one exported from a database, the other I created.
The first sheet is of Equipment Records with the following columns: Itemname(Column A), Itemdescription(Column B). The second sheet is a list of parts for the various equipment records: Partname(Column A), Partdescription(Column B), Itemname it belongs to(Column C). How do I make a sheet 3 that shows all Items from sheet 1 with any parts from sheet 2 that they might have sorted under them? Output Example: Item001 Chainsaw Part015 Bar Part023 Chain Item002 Pole Item003 Mower Part006 Blade Part007 Belt |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Issues
It looks like sorting sheet 2 gets you most of the information. It is not
clear if you need sheet 2 formated so the data is more visible. The only thing you don't have are the items in sheet one that don't appear in sheet 2. Maybe the simpliest way is to add to sheet 1 a column that contains if the item appear or doesn't appear in sheet 2. "Blissfully Ignorant" wrote: I have 2 excel lists, one exported from a database, the other I created. The first sheet is of Equipment Records with the following columns: Itemname(Column A), Itemdescription(Column B). The second sheet is a list of parts for the various equipment records: Partname(Column A), Partdescription(Column B), Itemname it belongs to(Column C). How do I make a sheet 3 that shows all Items from sheet 1 with any parts from sheet 2 that they might have sorted under them? Output Example: Item001 Chainsaw Part015 Bar Part023 Chain Item002 Pole Item003 Mower Part006 Blade Part007 Belt |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Issues
What do I do to make the new column?
"Joel" wrote: It looks like sorting sheet 2 gets you most of the information. It is not clear if you need sheet 2 formated so the data is more visible. The only thing you don't have are the items in sheet one that don't appear in sheet 2. Maybe the simpliest way is to add to sheet 1 a column that contains if the item appear or doesn't appear in sheet 2. "Blissfully Ignorant" wrote: I have 2 excel lists, one exported from a database, the other I created. The first sheet is of Equipment Records with the following columns: Itemname(Column A), Itemdescription(Column B). The second sheet is a list of parts for the various equipment records: Partname(Column A), Partdescription(Column B), Itemname it belongs to(Column C). How do I make a sheet 3 that shows all Items from sheet 1 with any parts from sheet 2 that they might have sorted under them? Output Example: Item001 Chainsaw Part015 Bar Part023 Chain Item002 Pole Item003 Mower Part006 Blade Part007 Belt |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Issues
In sheet 1 in cell c1 (assume no header in sheet 1)
=if(Countif(Sheet2!$C:$C,A1)0,"Found","Not Found") "Blissfully Ignorant" wrote: What do I do to make the new column? "Joel" wrote: It looks like sorting sheet 2 gets you most of the information. It is not clear if you need sheet 2 formated so the data is more visible. The only thing you don't have are the items in sheet one that don't appear in sheet 2. Maybe the simpliest way is to add to sheet 1 a column that contains if the item appear or doesn't appear in sheet 2. "Blissfully Ignorant" wrote: I have 2 excel lists, one exported from a database, the other I created. The first sheet is of Equipment Records with the following columns: Itemname(Column A), Itemdescription(Column B). The second sheet is a list of parts for the various equipment records: Partname(Column A), Partdescription(Column B), Itemname it belongs to(Column C). How do I make a sheet 3 that shows all Items from sheet 1 with any parts from sheet 2 that they might have sorted under them? Output Example: Item001 Chainsaw Part015 Bar Part023 Chain Item002 Pole Item003 Mower Part006 Blade Part007 Belt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting issues | Excel Discussion (Misc queries) | |||
Sorting issues | Excel Worksheet Functions | |||
V-Lookup issues | Excel Worksheet Functions | |||
sorting issues for movie titles | Excel Discussion (Misc queries) | |||
Issues with sorting | Excel Discussion (Misc queries) |