Dcount question..

  • Thread starter Thread starter ldiaz
  • Start date Start date
L

ldiaz

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
 
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 said:
Hi,

Try this

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

Mike

ldiaz said:
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
Click to expand...
Click to expand...
 
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 said:
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 said:
Hi,

Try this

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

Mike

ldiaz said:
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
Click to expand...
Click to expand...
Click to expand...
 
You got it,

Thanks, Right now it works fine...


--
Lorenzo Díaz
Cad Technician


Mike H said:
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 said:
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 said:
Hi,

Try this

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

Mike

:


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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top