software

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.
kikilein wrote:
gt;
gt; Hi All,
gt;
gt; I am trying to create a spreadsheet in Excel (I am using 2003) that contains
gt; Blackberry information for about 2000 users, such as pin, password, phone
gt; number, service provider and which office they are in (Albany, Ohio, etc.).
gt;
gt; I attempted to use the pivot table function in Excel which looked like a
gt; great solution, however, instead of displaying the data I want to see it only
gt; calculates something, which I don't need (I do not need anything calculated).
gt; Althought, the basic idea seems to be great. I can sort by office and then by
gt; last name and all the other data is in the data part of the pivot table.
gt;
gt; I probably have gotten the point of a pivot table completely wrong, but
gt; based on the above information, is there anything you can direct me too to
gt; accomplish what I want?
gt;
gt; Many thanks.
gt; __________________

--

Dave Peterson

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.
quot;Dave Petersonquot; wrote:

gt; It sounds like you're just using excel to store a bunch of data that fits nicely
gt; in columns.
gt;
gt; If you wanted some sort of summary report (count of service providers or count
gt; of states), then a pivottable may be useful.
gt;
gt; But it sounds more like selecting your data and doing Data|filter|autofilter to
gt; see different aspects of your lists may be more useful.
gt;
gt; Maybe even selecting the range and doing Data|Sort would be sufficient.
gt;
gt;
gt;
gt; kikilein wrote:
gt; gt;
gt; gt; Hi All,
gt; gt;
gt; gt; I am trying to create a spreadsheet in Excel (I am using 2003) that contains
gt; gt; Blackberry information for about 2000 users, such as pin, password, phone
gt; gt; number, service provider and which office they are in (Albany, Ohio, etc.).
gt; gt;
gt; gt; I attempted to use the pivot table function in Excel which looked like a
gt; gt; great solution, however, instead of displaying the data I want to see it only
gt; gt; calculates something, which I don't need (I do not need anything calculated).
gt; gt; Althought, the basic idea seems to be great. I can sort by office and then by
gt; gt; last name and all the other data is in the data part of the pivot table.
gt; gt;
gt; gt; I probably have gotten the point of a pivot table completely wrong, but
gt; gt; based on the above information, is there anything you can direct me too to
gt; gt; accomplish what I want?
gt; gt;
gt; gt; Many thanks.
gt; gt; __________________
gt;
gt; --
gt;
gt; Dave Peterson
gt;