| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get only unique values?
I have a range -one single single column. I'd like to print only the
unique values in this range. What's the best method to use to get the unique values? Ed |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get only unique values?
select the column (make sure it has a header in row 1)
then do Data=filterAdvanced filter Select Filter in place and click the Unique checkbox in the lower left. You don't need to specify a criteria. to restore your list, do Data=filter=Showall -- Regards, Tom Ogilvy "Ed" wrote: I have a range -one single single column. I'd like to print only the unique values in this range. What's the best method to use to get the unique values? Ed |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get only unique values?
Tom: I'm sorry I wasn't clearer. I'm copying new info into an
exisiting workbook. When I'm done, I need to print out the unique values from one column over the range of rows I just copied into. Say, Col J, Rows 135 - 210. Can I set Range("J135:J210") and get just the unique values from there to print out? Ed On Mar 15, 10:31 am, Tom Ogilvy wrote: select the column (make sure it has a header in row 1) then do Data=filterAdvanced filter Select Filter in place and click the Unique checkbox in the lower left. You don't need to specify a criteria. to restore your list, do Data=filter=Showall -- Regards, Tom Ogilvy "Ed" wrote: I have a range -one single single column. I'd like to print only the unique values in this range. What's the best method to use to get the unique values? Ed- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get only unique values?
You haven't told me anything that would change the basic advice.
If you want to print out, then after applying the filter just select J135:J210 and print selection. only the visible rows will be printed. You can apply the autofilter with code if that is your consternation. Assume you header row is in J134 Dim rng as Range set rng = Range(Range("J134),Range("J134").end(xldown)) rng.AdvancedFilter Action:=xlFilterInPlace, Unique:=True rng.Printout Activesheet.ShowAllData -- Regards, Tom Ogilvy -- Regards, Tom Ogilvy "Ed" wrote: Tom: I'm sorry I wasn't clearer. I'm copying new info into an exisiting workbook. When I'm done, I need to print out the unique values from one column over the range of rows I just copied into. Say, Col J, Rows 135 - 210. Can I set Range("J135:J210") and get just the unique values from there to print out? Ed On Mar 15, 10:31 am, Tom Ogilvy wrote: select the column (make sure it has a header in row 1) then do Data=filterAdvanced filter Select Filter in place and click the Unique checkbox in the lower left. You don't need to specify a criteria. to restore your list, do Data=filter=Showall -- Regards, Tom Ogilvy "Ed" wrote: I have a range -one single single column. I'd like to print only the unique values in this range. What's the best method to use to get the unique values? Ed- Hide quoted text - - Show quoted text - |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get only unique values?
Okay - I think I see. I get an idea of what I think I need to do, and
I get tunnel-visioned on that. So if my header is in Row 1, I apply the filter, then just select the range of rows I've just been working with in my code and print. Thanks, Tom. I appreciate the boost. Ed On Mar 15, 11:39 am, Tom Ogilvy wrote: You haven't told me anything that would change the basic advice. If you want to print out, then after applying the filter just select J135:J210 and print selection. only the visible rows will be printed. You can apply the autofilter with code if that is your consternation. Assume you header row is in J134 Dim rng as Range set rng = Range(Range("J134),Range("J134").end(xldown)) rng.AdvancedFilter Action:=xlFilterInPlace, Unique:=True rng.Printout Activesheet.ShowAllData -- Regards, Tom Ogilvy -- Regards, Tom Ogilvy "Ed" wrote: Tom: I'm sorry I wasn't clearer. I'm copying new info into an exisiting workbook. When I'm done, I need to print out the unique values from one column over the range of rows I just copied into. Say, Col J, Rows 135 - 210. Can I set Range("J135:J210") and get just the unique values from there to print out? Ed On Mar 15, 10:31 am, Tom Ogilvy wrote: select the column (make sure it has a header in row 1) then do Data=filterAdvanced filter Select Filter in place and click the Unique checkbox in the lower left. You don't need to specify a criteria. to restore your list, do Data=filter=Showall -- Regards, Tom Ogilvy "Ed" wrote: I have a range -one single single column. I'd like to print only the unique values in this range. What's the best method to use to get the unique values? Ed- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get only unique values?
Yes.
-- Regards, Tom Ogilvy "Ed" wrote: Okay - I think I see. I get an idea of what I think I need to do, and I get tunnel-visioned on that. So if my header is in Row 1, I apply the filter, then just select the range of rows I've just been working with in my code and print. Thanks, Tom. I appreciate the boost. Ed On Mar 15, 11:39 am, Tom Ogilvy wrote: You haven't told me anything that would change the basic advice. If you want to print out, then after applying the filter just select J135:J210 and print selection. only the visible rows will be printed. You can apply the autofilter with code if that is your consternation. Assume you header row is in J134 Dim rng as Range set rng = Range(Range("J134),Range("J134").end(xldown)) rng.AdvancedFilter Action:=xlFilterInPlace, Unique:=True rng.Printout Activesheet.ShowAllData -- Regards, Tom Ogilvy -- Regards, Tom Ogilvy "Ed" wrote: Tom: I'm sorry I wasn't clearer. I'm copying new info into an exisiting workbook. When I'm done, I need to print out the unique values from one column over the range of rows I just copied into. Say, Col J, Rows 135 - 210. Can I set Range("J135:J210") and get just the unique values from there to print out? Ed On Mar 15, 10:31 am, Tom Ogilvy wrote: select the column (make sure it has a header in row 1) then do Data=filterAdvanced filter Select Filter in place and click the Unique checkbox in the lower left. You don't need to specify a criteria. to restore your list, do Data=filter=Showall -- Regards, Tom Ogilvy "Ed" wrote: I have a range -one single single column. I'd like to print only the unique values in this range. What's the best method to use to get the unique values? Ed- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get only unique values?
But just to add,
then unique would be relative to the whole column. If that is problematic it is trivial in code to insert a row at 135, put in a "Header", apply the advanced filter to J135:J211 (one cell down), print, remove the filter, delete the row. -- Regards, Tom Ogilvy "Ed" wrote: Okay - I think I see. I get an idea of what I think I need to do, and I get tunnel-visioned on that. So if my header is in Row 1, I apply the filter, then just select the range of rows I've just been working with in my code and print. Thanks, Tom. I appreciate the boost. Ed On Mar 15, 11:39 am, Tom Ogilvy wrote: You haven't told me anything that would change the basic advice. If you want to print out, then after applying the filter just select J135:J210 and print selection. only the visible rows will be printed. You can apply the autofilter with code if that is your consternation. Assume you header row is in J134 Dim rng as Range set rng = Range(Range("J134),Range("J134").end(xldown)) rng.AdvancedFilter Action:=xlFilterInPlace, Unique:=True rng.Printout Activesheet.ShowAllData -- Regards, Tom Ogilvy -- Regards, Tom Ogilvy "Ed" wrote: Tom: I'm sorry I wasn't clearer. I'm copying new info into an exisiting workbook. When I'm done, I need to print out the unique values from one column over the range of rows I just copied into. Say, Col J, Rows 135 - 210. Can I set Range("J135:J210") and get just the unique values from there to print out? Ed On Mar 15, 10:31 am, Tom Ogilvy wrote: select the column (make sure it has a header in row 1) then do Data=filterAdvanced filter Select Filter in place and click the Unique checkbox in the lower left. You don't need to specify a criteria. to restore your list, do Data=filter=Showall -- Regards, Tom Ogilvy "Ed" wrote: I have a range -one single single column. I'd like to print only the unique values in this range. What's the best method to use to get the unique values? Ed- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unique Values, not Unique Records | Excel Discussion (Misc queries) | |||
| Why does this code remove Duplicate Values, by showing only 1, but it does NOT show Unique values for some reason ? | Excel Programming | |||
| 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 | |||
Hybrid Mode
