I am trying to figure out how get the percentage of times a specific text occurs in a spreadsheet.
K kruggie2000 Oct 6, 2008 #1 I am trying to figure out how get the percentage of times a specific text occurs in a spreadsheet.
S Sheeloo Oct 6, 2008 #2 You can get the number of times it occurs by using COUNTIF function For example to count how many times Test occurs in Col C use =COUNTIF(C:C,"Test") You can then calculate the percentage as you want.
You can get the number of times it occurs by using COUNTIF function For example to count how many times Test occurs in Col C use =COUNTIF(C:C,"Test") You can then calculate the percentage as you want.
