Count Multiple Instances of Text in a Cell
Now that's cool JE, really COOL..............a keeper.
Vaya con Dios, Chuck, CABGx3 "JE McGimpsey" wrote: One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN): =SUM(LEN(I2:I44)-LEN(SUBSTITUTE(I2:I44,"blue","")))/LEN("blue") In article , dave roth wrote: Good Afternoon: I need to be able to count multiple instances of the same piece of text in a given cell, i.e. "blue, blue, red, green." How I currently have this setup is: =countif(I2:I44,"*blue*") =countif(I2:I44,"*green*") =countif(I2:I44,"*red*") on separate rows. In the above example these will return 1 blue, 1 green, and 1 red; I need it to return 2 blues. Thanks very much, and a good weekend to all. Dave Roth |
All times are GMT +1. The time now is 05:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com