| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Question on DCOUNT | Excel Discussion (Misc queries) | |||
| DCOUNT Help! | Excel Discussion (Misc queries) | |||
| DCOUNT Question | Excel Worksheet Functions | |||
| dcount question | Excel Discussion (Misc queries) | |||
| DCount help | Excel Worksheet Functions | |||
Hybrid Mode
