| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countif function: how to distinguish case/make case sensitive
Is there a way to make the countif function case sensitive? If cell A1 has a
'c' in it and cell a2 has a 'C' in it, how can I make =countif(A1:A2,'C') give the value 1? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
countif function: how to distinguish case/make case sensitive
try this array formula, confirm by Ctrl,Shift and Enter
=SUM(IF(EXACT(A2:A5,"C"),1)) -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked An ordinary user helping another ordinary user and learn together Thank You cheers, francis "mvwoolner" wrote: Is there a way to make the countif function case sensitive? If cell A1 has a 'c' in it and cell a2 has a 'C' in it, how can I make =countif(A1:A2,'C') give the value 1? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
countif function: how to distinguish case/make case sensitive
Hi,
=SUMPRODUCT(--EXACT(A1:A4,"C")) or =SUMPRODUCT(--EXACT(A1:A4,B1)) where B1 contains C or c or whatever. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "mvwoolner" wrote: Is there a way to make the countif function case sensitive? If cell A1 has a 'c' in it and cell a2 has a 'C' in it, how can I make =countif(A1:A2,'C') give the value 1? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
countif function: how to distinguish case/make case sensitive
Hi,
=SUMPRODUCT(--EXACT(A1:A4,"C")) or =SUMPRODUCT(--EXACT(A1:A4,B1)) where B1 contains C or c or whatever. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "mvwoolner" wrote: Is there a way to make the countif function case sensitive? If cell A1 has a 'c' in it and cell a2 has a 'C' in it, how can I make =countif(A1:A2,'C') give the value 1? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make sumproduct lookup case sensitive | Excel Worksheet Functions | |||
| Can I Make AutoFilter to be Case-Sensitive? | Excel Discussion (Misc queries) | |||
| Case Sensitive w/ IF | Excel Worksheet Functions | |||
| can vlookup be forced to make a case sensitive match? | Excel Discussion (Misc queries) | |||
| any way to make vlookup case sensitive? | Excel Worksheet Functions | |||
Linear Mode
