Dcount question..
 

I have a column [PO#], I want to count how many different values are on that
column to get as result =3, can you please help me on that?

example
PO#
10210
10210
10211
10211
10211
10212

Thanks
LD

--
Lorenzo DÃ*az
Cad Technician

Dcount question..
 

Hi,

Try this

=SUM(IF(FREQUENCY(A1:A100,A1:A100)0,1))

Mike

"ldiaz" wrote:


I have a column [PO#], I want to count how many different values are on that
column to get as result =3, can you please help me on that?

example
PO#
10210
10210
10211
10211
10211
10212

Thanks
LD

--
Lorenzo DÃ*az
Cad Technician

Dcount question..
 

it works, but some times i have texts like;
PO-10125
PO-10123
PO-10124

do you know how to get that on these values?

Thanks
LD

--
Lorenzo DÃ*az
Cad Technician


"Mike H" wrote:

Hi,

Try this

=SUM(IF(FREQUENCY(A1:A100,A1:A100)0,1))

Mike

"ldiaz" wrote:


I have a column [PO#], I want to count how many different values are on that
column to get as result =3, can you please help me on that?

example
PO#
10210
10210
10211
10211
10211
10212

Thanks
LD

--
Lorenzo DÃ*az
Cad Technician

Dcount question..
 

Hi,

For text you need a different formula but there must be no empty cells in
the range

=SUM(IF(FREQUENCY(MATCH(A1:A10,A1:A10,0),MATCH(A1: A10,A1:A10,0))0,1))

Mike



"ldiaz" wrote:

it works, but some times i have texts like;
PO-10125
PO-10123
PO-10124

do you know how to get that on these values?

Thanks
LD

--
Lorenzo DÃ*az
Cad Technician


"Mike H" wrote:

Hi,

Try this

=SUM(IF(FREQUENCY(A1:A100,A1:A100)0,1))

Mike

"ldiaz" wrote:


I have a column [PO#], I want to count how many different values are on that
column to get as result =3, can you please help me on that?

example
PO#
10210
10210
10211
10211
10211
10212

Thanks
LD

--
Lorenzo DÃ*az
Cad Technician

Dcount question..
 

You got it,

Thanks, Right now it works fine...


--
Lorenzo DÃ*az
Cad Technician


"Mike H" wrote:

Hi,

For text you need a different formula but there must be no empty cells in
the range

=SUM(IF(FREQUENCY(MATCH(A1:A10,A1:A10,0),MATCH(A1: A10,A1:A10,0))0,1))

Mike



"ldiaz" wrote:

it works, but some times i have texts like;
PO-10125
PO-10123
PO-10124

do you know how to get that on these values?

Thanks
LD

--
Lorenzo DÃ*az
Cad Technician


"Mike H" wrote:

Hi,

Try this

=SUM(IF(FREQUENCY(A1:A100,A1:A100)0,1))

Mike

"ldiaz" wrote:


I have a column [PO#], I want to count how many different values are on that
column to get as result =3, can you please help me on that?

example
PO#
10210
10210
10211
10211
10211
10212

Thanks
LD

--
Lorenzo DÃ*az
Cad Technician