ExcelBanter - å¦‚ä½•åˆ†è¾¨å¤§å°å¯«?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - å¦‚ä½•åˆ†è¾¨å¤§å°å¯«? (https://www.excelbanter.com/excel-discussion-misc-queries/35260-%E5%A6%82%E4%BD%95%E5%88%86%E8%BE%A8%E5%A4%A7%E5%B0%8F%E5%AF%AB.html)

å¦‚ä½•åˆ†è¾¨å¤§å°å¯«?

excel å¯ä»¥åˆ©ç”¨ countif è¨ˆç®—å·²çŸ¥å€åŸŸçš„ç›®æ¨™æ•¸ç›®,ä½†æ˜¯countifç„¡ æ³•åˆ†è¾¨å¤§å°å¯«,å¦‚ "1b" or "1B".
è«‹å•æœ‰ä»€éº¼å‡½æ•¸å¯åšåˆ°æ*¤åŠŸèƒ½å‘¢?

As COUNTIF is not case sensitive,
one way to get counts which need to be case sensitive ..

Assuming data is within A1:A100

To count no. of cells with "1b" :
=SUMPRODUCT(--(ISNUMBER(FIND("1b",A1:A100))))

To count no. of cells with "1B" :
=SUMPRODUCT(--(ISNUMBER(FIND("1B",A1:A100))))

Adapt the ranges to suit ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"tree" wrote in message
...
excel ???? countif ???????????,??countif???????,? "1b" or "1B".
???????????????

How distinguishes the big small letter?
Excel may calculate the known region using countif the goal number, but
countif is unable to distinguish the big small letter, like "1b" or "1B"
Asked what function has to be possible to achieve this function?