Jul 22 2021 09:10 AM
Hi! So I am fairly new to excel and I am working on a project in which the only data we really use are single alphabetical letters such as "R" and "W". I need to know the amount of times that these letters occur in each row in order to calculate averages.
Basically, I am inquiring if there is a way to view the number of times these certain letters occur per row in order to easier calculate these averages without having to manually go through and count the number of times a letter occurs in a row. Any and all help will be appreciated as this project would require me to manually go through around 200 rows! Thanks in advance!
Jul 22 2021 09:14 AM
Jul 22 2021 09:25 AM
Jul 22 2021 09:48 AM
SolutionHi again @JennaThornton
See an example in the attached workbook. If you have challenge adapting it to your actual scenario please attach a representative workbook with a couple of rows to your next reply
Thanks
Jul 22 2021 11:10 AM
@L z. This is perfect!! Thank you so so much!
Jul 22 2021 11:14 AM
Jul 22 2021 09:48 AM
SolutionHi again @JennaThornton
See an example in the attached workbook. If you have challenge adapting it to your actual scenario please attach a representative workbook with a couple of rows to your next reply
Thanks