How to organize Data?

K

kikilein

Hi All,

I am trying to create a spreadsheet in Excel (I am using 2003) that contains
Blackberry information for about 2000 users, such as pin, password, phone
number, service provider and which office they are in (Albany, Ohio, etc.).

I attempted to use the pivot table function in Excel which looked like a
great solution, however, instead of displaying the data I want to see it only
calculates something, which I don't need (I do not need anything calculated).
Althought, the basic idea seems to be great. I can sort by office and then by
last name and all the other data is in the data part of the pivot table.

I probably have gotten the point of a pivot table completely wrong, but
based on the above information, is there anything you can direct me too to
accomplish what I want?

Many thanks.
__________________
 
D

davesexcel

Maybe you could try
Vlookup, search the forum and you will find allsorts of info on
VLOOKUP, even excel's help explains it
 
D

Dave Peterson

It sounds like you're just using excel to store a bunch of data that fits nicely
in columns.

If you wanted some sort of summary report (count of service providers or count
of states), then a pivottable may be useful.

But it sounds more like selecting your data and doing Data|filter|autofilter to
see different aspects of your lists may be more useful.

Maybe even selecting the range and doing Data|Sort would be sufficient.
 
K

kikilein

Thanks to both of you. I have looked into the VLOOKUP (HLOOKUP and
INDEX/MATCH) but neither gave me more than one value back. I would like to
get the entire Row (all the values: pin#, phone #, FName and LName, etc.)

Dave,

I tried the Pivot table and it seems like a great thing, however, the
results are all 1 and not the pin #, phone #, etc. It just fills in the
number 1.

Basically I would like to search a spread sheet for a value (pin#, phone #,
FName and LName, etc.) and than get the user's record as the result (the
entire row).

Thanks again for your input. If you have another idea, I would be more than
happy to try it.
 
Top