Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto copy single values to another cell
Hi to all,
I will thanks if some help can be provided. I have a list of items that contains repeated items in column A (each week i start a new file with the empty list). I would like in column C to appear automaticaly only one time each item I put in the column A. thanks for the help you can give. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto copy single values to another cell
Data Filter AdvancedFilter, follow menu and select "Unique Records only"
Vaya con Dios, Chuck, CABGx3 "DDavid" wrote: Hi to all, I will thanks if some help can be provided. I have a list of items that contains repeated items in column A (each week i start a new file with the empty list). I would like in column C to appear automaticaly only one time each item I put in the column A. thanks for the help you can give. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto copy single values to another cell
Via formula? If so:
http://www.exceltip.com/st/Retrievin..._List/805.html DDavid wrote: Hi to all, I will thanks if some help can be provided. I have a list of items that contains repeated items in column A (each week i start a new file with the empty list). I would like in column C to appear automaticaly only one time each item I put in the column A. thanks for the help you can give. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto copy single values to another cell
=IF(COUNTIF(A$1:A1,A1)=1,A1,""), copied as far as you like down column C,
will copy a value from A to C only if it is the first occurrence of that value in column A. -- David Biddulph "DDavid" wrote in message ups.com... Hi to all, I will thanks if some help can be provided. I have a list of items that contains repeated items in column A (each week i start a new file with the empty list). I would like in column C to appear automaticaly only one time each item I put in the column A. thanks for the help you can give. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto copy single values to another cell
That's cool............then a little Copy PasteSpecial Values, and a sort
of the column will get the list all up in one neat group. This can of course then be set to a macro if desired. Vaya con Dios, Chuck, CABGx3 "David Biddulph" wrote: =IF(COUNTIF(A$1:A1,A1)=1,A1,""), copied as far as you like down column C, will copy a value from A to C only if it is the first occurrence of that value in column A. -- David Biddulph "DDavid" wrote in message ups.com... Hi to all, I will thanks if some help can be provided. I have a list of items that contains repeated items in column A (each week i start a new file with the empty list). I would like in column C to appear automaticaly only one time each item I put in the column A. thanks for the help you can give. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto copy single values to another cell
Hey, thank you all, I learned a few new things today and solve my
issue. thanks! On Sep 27, 8:40 am, CLR wrote: That's cool............then a little Copy PasteSpecial Values, and a sort of the column will get the list all up in one neat group. This can of course then be set to a macro if desired. Vaya con Dios, Chuck, CABGx3 "David Biddulph" wrote: =IF(COUNTIF(A$1:A1,A1)=1,A1,""), copied as far as you like down column C, will copy a value from A to C only if it is the first occurrence of that value in column A. -- David Biddulph "DDavid" wrote in message oups.com... Hi to all, I will thanks if some help can be provided. I have a list of items that contains repeated items in column A (each week i start a new file with the empty list). I would like in column C to appear automaticaly only one time each item I put in the column A. thanks for the help you can give. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I return different values in single cell? | Excel Discussion (Misc queries) | |||
auto population based on single cell entry | Excel Discussion (Misc queries) | |||
How to copy single cell into cell that is merged from two cells? | Excel Discussion (Misc queries) | |||
Auto fill multiple cells depending on single cell value | Excel Worksheet Functions | |||
How do I copy Tab into a single cell in Excel? | Excel Discussion (Misc queries) |