Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duplicates formula
Result Example Result in col B A B 100 100 100 3 200 300 300 2 Hi I'd like to find the number duplicates in Column A, and place a result in column B as shown on above in Col B. How do you create formulas? Thanks Soth |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duplicates formula
Soth wrote:
Result Example Result in col B A B 100 100 100 3 200 300 300 2 Hi I'd like to find the number duplicates in Column A, and place a result in column B as shown on above in Col B. How do you create formulas? Thanks Soth Assuming your data is in A1:A6, this array formula (commit with CTRL+SHIFT+ENTER) will give you exactly those results: =IF(ROW()=MAX(IF($A$1:$A$6=A1,ROW($A$1:$A$6),"")), IF(COUNTIF($A$1:$A$6,A1)1,COUNTIF($A$1:$A$6,A1)," "),"") |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duplicates formula
=IF(OR(COUNTIF($A$1:A1,A1)=1,A1=A2),"",COUNTIF($A$ 1:A1,A1))
"Soth" wrote: Result Example Result in col B A B 100 100 100 3 200 300 300 2 Hi I'd like to find the number duplicates in Column A, and place a result in column B as shown on above in Col B. How do you create formulas? Thanks Soth |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duplicates formula
In B1:
=REPT(COUNTIF($A$1:A1,A1),A1<A2) Copy down ... Regards, Bernd |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duplicates formula
You're the best Bernd !! Many thanks. "Bernd P" wrote: In B1: =REPT(COUNTIF($A$1:A1,A1),A1<A2) Copy down ... Regards, Bernd . |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duplicates formula
Hi,
=if(or(A1=A2,countif(A$1:A1,A1)=1),"",countif(A$1: A1,A1)) -- Regards, Ashish Mathur Microsoft Excel MVP "Soth" wrote in message ... Result Example Result in col B A B 100 100 100 3 200 300 300 2 Hi I'd like to find the number duplicates in Column A, and place a result in column B as shown on above in Col B. How do you create formulas? Thanks Soth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with formula to weed out duplicates | Excel Worksheet Functions | |||
Formula to look up duplicates | Excel Worksheet Functions | |||
Duplicates Formula | Excel Worksheet Functions | |||
array formula with duplicates | Excel Discussion (Misc queries) | |||
Formula that recognizes duplicates | Excel Worksheet Functions |