LogFAQs > #949523586

LurkerFAQs, Active DB, DB1, DB2, DB3, DB4, DB5, DB6, Database 7 ( 07.18.2020-02.18.2021 ), DB8, DB9, DB10, DB11, DB12, Clear
Topic List
Page List: 1
TopicHelp separating and organizing survey responses in Sheets/Excel
Woodger
01/15/21 7:48:42 AM
#2:


Can you do a Countif function for cells that contain each of the ways they're worded?
Like
=COUNTIF(A1:B10,"*"&"kg"&"*")
=COUNTIF(A1:B10,"*"&"KG"&"*")
etc
... Copied to Clipboard!
Topic List
Page List: 1