Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Unique Values
I have a list in Column H whose MAX size is H2:H10,000. There are currently
only 1,000 cells filled in with data in column H. I want to create a new list in column K that will pull out ONLY unique entries from column H. Is there a formula to use that would calculate for the entire range of column H (H2:H10000) so that when a new record is entered, it will automatically pull out the unique value if the value added to the new row is unique? Thanks in advance for any help! John |
#2
|
|||
|
|||
To create the unique column manually, pulldown Data FIlter Advanced Filter
and check unique only. Do get this to happend automatically whenever a new entry is made would require an Event Macro . -- Gary's Student "JohnGuts" wrote: I have a list in Column H whose MAX size is H2:H10,000. There are currently only 1,000 cells filled in with data in column H. I want to create a new list in column K that will pull out ONLY unique entries from column H. Is there a formula to use that would calculate for the entire range of column H (H2:H10000) so that when a new record is entered, it will automatically pull out the unique value if the value added to the new row is unique? Thanks in advance for any help! John |
#3
|
|||
|
|||
Thanks for the quick reply. I tried what you suggested, and for some reason,
it always produced a list where 2 identical values were reported. It did filter out all the other duplicates, but for some reason, one value was displayed twice. Any ideas? Thanks. "Gary's Student" wrote: To create the unique column manually, pulldown Data FIlter Advanced Filter and check unique only. Do get this to happend automatically whenever a new entry is made would require an Event Macro . -- Gary's Student "JohnGuts" wrote: I have a list in Column H whose MAX size is H2:H10,000. There are currently only 1,000 cells filled in with data in column H. I want to create a new list in column K that will pull out ONLY unique entries from column H. Is there a formula to use that would calculate for the entire range of column H (H2:H10000) so that when a new record is entered, it will automatically pull out the unique value if the value added to the new row is unique? Thanks in advance for any help! John |
#4
|
|||
|
|||
In my experience two identical entries usually means the differences are
invisible, like trailing blanks. If it is trailing blanks, then use the TRIM() function before filtering. Good Luck -- Gary's Student "JohnGuts" wrote: Thanks for the quick reply. I tried what you suggested, and for some reason, it always produced a list where 2 identical values were reported. It did filter out all the other duplicates, but for some reason, one value was displayed twice. Any ideas? Thanks. "Gary's Student" wrote: To create the unique column manually, pulldown Data FIlter Advanced Filter and check unique only. Do get this to happend automatically whenever a new entry is made would require an Event Macro . -- Gary's Student "JohnGuts" wrote: I have a list in Column H whose MAX size is H2:H10,000. There are currently only 1,000 cells filled in with data in column H. I want to create a new list in column K that will pull out ONLY unique entries from column H. Is there a formula to use that would calculate for the entire range of column H (H2:H10000) so that when a new record is entered, it will automatically pull out the unique value if the value added to the new row is unique? Thanks in advance for any help! John |
#5
|
|||
|
|||
http://tinyurl.com/dhtnw
Only a couple of days ago... Biff "JohnGuts" wrote in message ... I have a list in Column H whose MAX size is H2:H10,000. There are currently only 1,000 cells filled in with data in column H. I want to create a new list in column K that will pull out ONLY unique entries from column H. Is there a formula to use that would calculate for the entire range of column H (H2:H10000) so that when a new record is entered, it will automatically pull out the unique value if the value added to the new row is unique? Thanks in advance for any help! John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count unique values and create list based on these values | Excel Worksheet Functions | |||
Extract Unique Values, Then Extract Again to Remove Suffixes | Excel Discussion (Misc queries) | |||
Count Unique Values | Excel Worksheet Functions | |||
Count number of Unique values | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions |