| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting information into lists
I am doing a simple cost comparison. I basically have a list of 200
different products with different prices from 4 different sources. I have set up this worksheet so it shows the cheapest source for each product as you plug in the prices. My question is, can I set this up so it sends the source and product to a seperate list, so it is all corresponding? Ex. What I have now... A1- Apples B1- United A2- Oranges B2- United A3- Banana B3- Mart A4- Kiwi B4- Mart What I want... A5- United A6- Apples A7- Oranges A8- Mart A9- Banana A10- Kiwi So, essentially it will be just organizing this information into seperate categories. I don't know if there is a function that can take care of this or not. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combining and sorting 2 lists | Excel Worksheet Functions | |||
| formula help, sorting information | Excel Worksheet Functions | |||
| Excel - need a function to compare lists | Excel Worksheet Functions | |||
| Sorting LISTs | Excel Discussion (Misc queries) | |||
| Excel as a database and sorting information | Excel Discussion (Misc queries) | |||
Threaded Mode
