I have a problem, and would greatly appreciate any help. I work for an auto dealership with lots of cars and I am in charge of inventory. When I order vehicles I must look at current inventory and what is incoming in order to determine what needs to be ordered. In other words I must compare the models and options that we have and determine what must be ordered. Okay, here is the problem, I import data into a spreadsheet. The data looks like this (I am going to include the dollar sign ($) to represent each column.

Model $ Options $

cc1550 $ ag1,ae7,1sm $

cc1560 $ ag1,an3,1sb $

ck1563 $ ad3,an3,1sm $

cc1550 $ ad3,ae7,1sl $

I have hundreds of combinations like this and need to determine for example how many cc1550's we have with the ag1 and 1sm option and so on. This above is the most important. I currently use find and replace, but it will only let me find all ag1's, not multiple data criteria. What can I do? If possible I would like to be able to automatically put the findings in table, but if you could help me find the exact info. I need accurately it would help me greatly with my job which I really need to keep. Thank You very much.

This message was edited by jswaim on 2002-09-28 08:56