| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find, count and extract duplicate cells
Hi,
I have a number of columns and I want to be able to count the number of duplicates in column A IF the value in column B="X" AND column C="Y". Ideally I'd also like to be able to extract each of those duplicates and put them into another column or spreadshhet.(I'm not sure if this is do-able!) I'm guessing that the first bit can be done with some kind of SUMPRODUCT formula, but I'm not sure how to include the IF/AND in with the formulas I've found in this forum to identify duplicates. Any help would be greatly received! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Find, count and extract duplicate cells
Can you provide some sample data and the result you expect?
-- Biff Microsoft Excel MVP "Igby" wrote in message ... Hi, I have a number of columns and I want to be able to count the number of duplicates in column A IF the value in column B="X" AND column C="Y". Ideally I'd also like to be able to extract each of those duplicates and put them into another column or spreadshhet.(I'm not sure if this is do-able!) I'm guessing that the first bit can be done with some kind of SUMPRODUCT formula, but I'm not sure how to include the IF/AND in with the formulas I've found in this forum to identify duplicates. Any help would be greatly received! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I find duplicate occurances of three cells in rows? | Excel Worksheet Functions | |||
| extract duplicate name | Excel Discussion (Misc queries) | |||
| Extract duplicate rows to another worksheet | Excel Worksheet Functions | |||
| how to find duplicate cells in large array of numbers | Excel Worksheet Functions | |||
| find duplicate cells in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
