Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excell search function
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excell search function
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 "joshuabrown97" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excell search function
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. "Ron Coderre" wrote: 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 "joshuabrown97" wrote: 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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excell search function
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 "joshuabrown97" wrote: 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. "Ron Coderre" wrote: 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 "joshuabrown97" wrote: 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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
excell search function
I think this will work, I appreciate the help.
"Ron Coderre" wrote: 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 "joshuabrown97" wrote: 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. "Ron Coderre" wrote: 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 "joshuabrown97" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Looking for a function to search and coincide | Excel Worksheet Functions | |||
SEARCH function | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) |