Formula to check for text in column
Closed
cristinev
Posts
1
Registration date
Monday January 7, 2013
Status
Member
Last seen
January 7, 2013
-
Jan 7, 2013 at 11:24 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Jan 7, 2013 at 10:06 PM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Jan 7, 2013 at 10:06 PM
Related:
- Formula to check for text in column
- Check soft - Download - Finance
- Number to words in excel formula - Guide
- How to check pc power consumption in windows 11 - Guide
- Insert check mark in word - Guide
- T-mobile check balance text - Guide
1 response
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Jan 7, 2013 at 10:06 PM
Jan 7, 2013 at 10:06 PM
Hi cristinev,
You can try using COUNTIF() Worksheet Function in Microsoft Excel to accomplish this task. Put the below mentioned formulas in the desired cells at the bottom of the sheet:
=COUNTIF($E$1:$E$1048575,"HM") & " HM"
=COUNTIF($E$1:$E$1048575,"BVL") & " BVL"
=COUNTIF($E$1:$E$1048575,"OP") & " OP"
You can change $E$1:$E$1048575 with any range of values in column E.
Please reply if you have any further questions.
You can try using COUNTIF() Worksheet Function in Microsoft Excel to accomplish this task. Put the below mentioned formulas in the desired cells at the bottom of the sheet:
=COUNTIF($E$1:$E$1048575,"HM") & " HM"
=COUNTIF($E$1:$E$1048575,"BVL") & " BVL"
=COUNTIF($E$1:$E$1048575,"OP") & " OP"
You can change $E$1:$E$1048575 with any range of values in column E.
Please reply if you have any further questions.