Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I show duplicate Data only?
I am trying to find a way to show duplicate data with multiple variations of
data. I would like to know if there is a fuction i can set up for this or a macro that would accomplish this task. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I show duplicate Data only?
You may be able to use condifitonal formatting
Look at http://www.cpearson.com/excel/Duplicates.aspx "jchambers" wrote: I am trying to find a way to show duplicate data with multiple variations of data. I would like to know if there is a fuction i can set up for this or a macro that would accomplish this task. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I show duplicate Data only?
I am dealing with multiple columns and data. The conditional formating works
well with one column. One column I am using has multiples of data. I am trying to run this off of four to five columns at once. I have not been able to get it to work with more than one column. I may not have the formula correct. Any help would be "Duke Carey" wrote: You may be able to use condifitonal formatting Look at http://www.cpearson.com/excel/Duplicates.aspx "jchambers" wrote: I am trying to find a way to show duplicate data with multiple variations of data. I would like to know if there is a fuction i can set up for this or a macro that would accomplish this task. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I show duplicate Data only?
Post a copy of your formula, then we'll be able to comment on it. It
might be that you set it up with relative cell references, so that it doesn't copy across to other columns well. Pete On Oct 9, 9:54 pm, jchambers wrote: I am dealing with multiple columns and data. The conditional formating works well with one column. One column I am using has multiples of data. I am trying to run this off of four to five columns at once. I have not been able to get it to work with more than one column. I may not have the formula correct. Any help would be "Duke Carey" wrote: You may be able to use condifitonal formatting Look at http://www.cpearson.com/excel/Duplicates.aspx "jchambers" wrote: I am trying to find a way to show duplicate data with multiple variations of data. I would like to know if there is a fuction i can set up for this or a macro that would accomplish this task.- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I show duplicate Data only?
Is it possible to create a formula using conditional formating that will
compare multiple columns for duplicates? (Ex. column A has the date, B has a product, C has an account number, D has emplyee info.) I am trying to be able to reference all at once to find duplicate products on accounts for the same date and employee. "Pete_UK" wrote: Post a copy of your formula, then we'll be able to comment on it. It might be that you set it up with relative cell references, so that it doesn't copy across to other columns well. Pete On Oct 9, 9:54 pm, jchambers wrote: I am dealing with multiple columns and data. The conditional formating works well with one column. One column I am using has multiples of data. I am trying to run this off of four to five columns at once. I have not been able to get it to work with more than one column. I may not have the formula correct. Any help would be "Duke Carey" wrote: You may be able to use condifitonal formatting Look at http://www.cpearson.com/excel/Duplicates.aspx "jchambers" wrote: I am trying to find a way to show duplicate data with multiple variations of data. I would like to know if there is a fuction i can set up for this or a macro that would accomplish this task.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
identify duplicate data upon entry of that data | Excel Discussion (Misc queries) | |||
How do i show duplicate data points on a scatter plot? | Charts and Charting in Excel | |||
comparing lists of data to remove duplicate data | Excel Discussion (Misc queries) | |||
How to hide duplicate records but show them once | Excel Discussion (Misc queries) | |||
how can i locate duplicate data in an excel data table? | Excel Worksheet Functions |