|Subject:||Sorting information into lists|
|Date:||Mon, 29 May 2006|
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...
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