Function/Formula in Excel to count Unique values matching criteria

M

mando415

New Member
Joined
Jun 4, 2013
Messages
8
Hi - I have a worksheet. I would like to count unique number of "Trans" in column A only if value of cells in column B "Type" equals "Return". In example below, I would want to see the value "3" as total.

I am banging my head over this and would appreciate any advise. :confused:

Trans Type
1 Return
2 Return
2 Return
3 Exch
4 Exch
5 Return
5 Return

Thank you
 
Sort by date Sort by votes
richh said:
...
Here's the table:

Sheet 1

Dealer | Num. People | Num. Apps. | Funded?
Ford |3|2||
Chevy |3|3||
Buick |3|2||


Sheet 2

Dealer | App. Num. | Funded?
Ford |1 |Funded
Ford |1 |Funded
Ford |2 |Pending
Chevy |3 |Pending
Chevy |4 |Pending
Chevy |5 |Funded
Buick |6 |Funded
Buick |6 |Funded
Buick |7 |Pending
Click to expand...

It's unclear what you want to count. Would you indicate that along with the actual result you want to see?
 
Upvote 0

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
What I want to count is the number of people (applicants) that went to the Ford dealership(Num. People column). Of those people, how many applications were made (Num. Apps.). There are times when there are co-applicants, meaning two people per application. the forumula provided earlier in this thread seems to have worked for it. In the "Funded?" column, I want to count the applications that were marked funded but exclude dupliate entries in the App Num column.

In the "Funded?" column on sheet 1, I want to count the numbers of applications marked "Funded" on sheet 2 for the specific dealer that excludes duplicate app. numbers.

IE - App number 1 had two entries on sheet 2, meaning there were two people on this applcation. The single application was funded, but both cells are marked funded just because I'm keeping track of both number of applicants and the number of applications.
 
Upvote 0
Sure. I'm going to expand Sheet 2 a bit so it can be a little clearer. It'd look like this:

Sheet 1

Dealer | Num. People | Num. Apps. | Funded?
Ford |3|2|1|
Chevy |3|3|1|
Buick |3|2|1|


Sheet 2

Dealer | Name | App. Num. | Funded?
Ford | Billy J. | 1 |Funded
Ford | Bobby J. 1 |Funded
Ford | Jack H. | 2 |Pending
Chevy |Roger C. | 3 |Pending
Chevy | Kathy B. | 4 |Pending
Chevy |Arnold S. | 5 |Funded
Buick |Terry L. | 6 |Funded
Buick |Barry L. | 6 |Funded
Buick | Mona U. | 7 |Pending

The difference is in the "Funded?" column on sheet 1. They're all at 1 because that's how many unique applications were marked as such in column b in sheet 2. The three entries for "Ford" on sheet 2 represent three people. Two of the people are co-applicants on the same application, so that's why there are two "number 1" application numbers in column B. The same goes for App number 6; two people went to the Buick dealership and applied for a car. They have the same application number and it was funded. I want to count the number of unique applications for the specified dealer that were funded. If it counts "Ford | Billy J. | 1 | Funded" and "Ford | Bobby J. | 1 | Funded", it's not an accurate figure.
 
Upvote 0
Try...

Sheet1!D2, confirmed with CONTROL+SHIFT+ENTER, and copied down:

=SUM(IF(FREQUENCY(IF(Sheet2!$A$2:$A$10=Sheet1!A2,IF(Sheet2!$D$2:$D$10="Funded",MATCH("~"&Sheet2!$C$2:$C$10,Sheet2!$C$2:$C$10&"",0))),ROW(Sheet2!$C$2:$C$10)-ROW(Sheet2!$C$2)+1)>0,1))

Hope this helps!
 
Upvote 0
Ok I've been stumped with this all day.

Row A contains a random assortment of part numbers
Row B contains a random assortment of part numbers

Our Part Your Part
31 1
15 2
25 2
68 3
45 3
45 3
98 4
31 5
25 5
95 5
45 5
31 7
31 8


I want to count how many times b2 has a unique value in column A

So c2=1
so c3=2
so c4=3

and so on downing down using your part as criteria


I have over 8000 rows... When I use the

=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B2,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B2,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1)) (ctrl-shift-enter) it takes forever
I have both text and numbers in both cells
 
Upvote 0
Superstar31 said:
Ok I've been stumped with this all day.

Row A contains a random assortment of part numbers
Row B contains a random assortment of part numbers

Our Part Your Part
31 1
15 2
25 2
68 3
45 3
45 3
98 4
31 5
25 5
95 5
45 5
31 7
31 8


I want to count how many times b2 has a unique value in column A

So c2=1
so c3=2
so c4=3

and so on downing down using your part as criteria


I have over 8000 rows... When I use the

=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B2,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B2,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1)) (ctrl-shift-enter) it takes forever
I have both text and numbers in both cells
Click to expand...

You are creating too many array formulas...

Does the following set up fare better?

Let Sheet1 house the data and define accordingly Ivec as referring to:

=ROW($A$2:$A$8639)-ROW($A$2)+1

Control+shift+enter, not just enter:

=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B2,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))

If still unsatisfactory, try a SQL set up (there are some posts on this board using SQL for unique counting).
 
Upvote 0
Aladin Akyurek said:
You are creating too many array formulas...

Does the following set up fare better?

Let Sheet1 house the data and define accordingly Ivec as referring to:

=ROW($A$2:$A$8639)-ROW($A$2)+1

Control+shift+enter, not just enter:

=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B2,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))

If still unsatisfactory, try a SQL set up (there are some posts on this board using SQL for unique counting).
Click to expand...

am i doing this wrong


Excel 2010
ABCD
1My PartYour PartCountCount 2
3591part127521
3592part127521
3593part127521
3594part127521
3595part127521
3604part227421
3605part227421
3606part227421
3607part227421
4758part327421
4759part327421
4760part327421
4761part327421
4762part327421
4763part327421
4764part327421
4765part327421
4766part327421
4767part327421
4768part327421
4769part327521
4770part327521
4771part327521
4772part327521
4773part327521
4774part327521
4775part327521
4776part327521
4777part327521
4778part327521
4779part327521
4780part327521
4781part327521
4782part327611
4783part327611
Sheet1
Cell Formulas
RangeFormula
D3591=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3591,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D3592=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3592,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D3593=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3593,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D3594=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3594,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D3595=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3595,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D3604=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3604,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D3605=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3605,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D3606=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3606,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D3607=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3607,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4758=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4758,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4759=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4759,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4760=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4760,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4761=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4761,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4762=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4762,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4763=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4763,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4764=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4764,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4765=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4765,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4766=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4766,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4767=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4767,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4768=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4768,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4769=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4769,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4770=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4770,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4771=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4771,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4772=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4772,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4773=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4773,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4774=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4774,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4775=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4775,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4776=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4776,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4777=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4777,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4778=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4778,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4779=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4779,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4780=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4780,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4781=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4781,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4782=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4782,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
D4783=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4783,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))
C3591{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3591,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B3591,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C3592{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3592,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B3592,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C3593{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3593,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B3593,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C3594{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3594,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B3594,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C3595{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3595,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B3595,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C3604{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3604,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B3604,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C3605{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3605,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B3605,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C3606{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3606,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B3606,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C3607{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B3607,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B3607,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4758{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4758,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4758,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4759{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4759,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4759,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4760{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4760,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4760,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4761{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4761,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4761,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4762{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4762,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4762,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4763{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4763,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4763,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4764{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4764,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4764,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4765{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4765,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4765,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4766{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4766,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4766,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4767{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4767,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4767,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4768{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4768,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4768,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4769{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4769,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4769,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4770{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4770,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4770,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4771{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4771,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4771,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4772{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4772,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4772,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4773{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4773,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4773,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4774{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4774,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4774,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4775{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4775,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4775,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4776{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4776,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4776,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4777{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4777,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4777,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4778{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4778,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4778,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4779{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4779,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4779,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4780{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4780,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4780,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4781{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4781,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4781,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4782{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4782,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4782,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
C4783{=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B4783,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),IF($B$2:$B$8639=B4783,MATCH($A$2:$A$8639,$A$2:$A$8639)))>0,1))}
Press CTRL+SHIFT+ENTER to enter array formulas.
Named Ranges
NameRefers ToCells
Ivec=Sheet1!$A$2:$B$8639
 
Upvote 0
You can avoid posting so many formulas in the posting application you use.

By the way:

=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B2,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))

too must be confirmed with control+shift+enter.

Ivec must be defined as referring to, this time the sheet prefix not omitted:

=ROW(Sheet1!$A$2:$A$8639)-ROW(Sheet1!$A$2)+1
 
Upvote 0
Aladin Akyurek said:
You can avoid posting so many formulas in the posting application you use.

By the way:

=SUM(IF(FREQUENCY(IF($B$2:$B$8639=B2,MATCH($A$2:$A$8639,$A$2:$A$8639,0)),Ivec),1))

too must be confirmed with control+shift+enter.

Ivec must be defined as referring to, this time the sheet prefix not omitted:

=ROW(Sheet1!$A$2:$A$8639)-ROW(Sheet1!$A$2)+1
Click to expand...

Worked perfect! Thanks... wish their was a simplier was to get unique counts thought.
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question Question
Multiple Criteria Lookup Return Value
Replies
1
Views
234
Vogateer
V
A
  • Solved
Index Match With Multiple Criteria
Replies
3
Views
188
acool
A
PhBarreto
  • Solved
Help WITH SUMPRODUCT
2
Replies
10
Views
71
Fluff
Fluff
A
  • Question Question
Index match match not using second set of match criteria
Replies
3
Views
63
Fluff
Fluff
A
  • Question Question
Excel Function to Extract Text String, Remove Duplicate & Count
Replies
5
Views
247
arijitirf
A

Forum statistics

Threads
1,223,246
Messages
6,170,988
Members
452,373
Latest member
TimReeks

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top