excell search function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

joshuabrown97 - 03 Nov 2006 22:35 GMT

I have a set of values and want to create a list of unique values from that
list for a summary.
Ex. List = 1,2,3,2,3
I need column A to return the 1,2,3 because they are unique values. Then i
use column B for CountIF using Column A as a reference. I can get the
CountIF function correct, but i do not know how to search my list and return
the references to Column A.

Reply to this Message

Ron Coderre - 03 Nov 2006 22:57 GMT

Is there a reason you wouldn't just use a Pivot Table to automatically
identify the unique values and calculate the counts for you?

***********
Regards,
Ron

XL2002, WinXP

> I have a set of values and want to create a list of unique values from that
> list for a summary.
[quoted text clipped - 3 lines]
> CountIF function correct, but i do not know how to search my list and return
> the references to Column A.

Reply to this Message

joshuabrown97 - 06 Nov 2006 16:09 GMT

Pivot Tables are good to work with, however, I have to admit I have little
experience with them. Also, the individuals who will be adding to these
tables are not experienced with Pivot Tables ,therefore i need to allow for
continuous updating without my supervision.

> Is there a reason you wouldn't just use a Pivot Table to automatically
> identify the unique values and calculate the counts for you?
[quoted text clipped - 12 lines]
> > CountIF function correct, but i do not know how to search my list and return
> > the references to Column A.

Reply to this Message

Ron Coderre - 06 Nov 2006 16:39 GMT

Here's an approach that might be worth pursuing:

If the source data range for the Pivot Table could automatically expand and
contract to accommodate changes in the data, that would resolve most of your
concerns, right?

See Debra Dalgleish's website for instructions on creating a Dynamic Data
Source (no programming):
http://www.contextures.com/xlPivot01.html

Then all your users have to do is refresh the Pivot Tables.
Alternatively, you could even have the PT refresh automatically whenever the
file is opened.

Does that help?
***********
Regards,
Ron

XL2002, WinXP

> Pivot Tables are good to work with, however, I have to admit I have little
> experience with them. Also, the individuals who will be adding to these
[quoted text clipped - 17 lines]
> > > CountIF function correct, but i do not know how to search my list and return
> > > the references to Column A.

Reply to this Message

joshuabrown97 - 24 Nov 2006 15:33 GMT

I think this will work, I appreciate the help.

> Here's an approach that might be worth pursuing:
>
[quoted text clipped - 38 lines]
> > > > CountIF function correct, but i do not know how to search my list and return
> > > > the references to Column A.

Reply to this Message