| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unique values
I have a table of data in Sheet1 A1:Z100. In Coumn A of
Sheet 2 I need to list all the unique entries in the table in Sheet1 whose values are between 1 and 10 (it can ignor all other values). Please help! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unique values
Hi
use 'Data - Filter - Advanced Filter' for this. Also try Ron's Filter addin for this: http://www.rondebruin.nl/easyfilter.htm -- Regards Frank Kabel Frankfurt, Germany "shawn" schrieb im Newsbeitrag ... I have a table of data in Sheet1 A1:Z100. In Coumn A of Sheet 2 I need to list all the unique entries in the table in Sheet1 whose values are between 1 and 10 (it can ignor all other values). Please help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unique Values, not Unique Records | Excel Discussion (Misc queries) | |||
| Count Unique Values but not Filtered or Hidden Values | Excel Worksheet Functions | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
| How do I search thr'o column and put unique values in differnt sheet and sum corresponding values in | Excel Programming | |||
Linear Mode
