Here is my problem,
I am trying to calculate the most common string, the 2nd most common string, up to the 10th most common. Here is some of the data:
FVHA
FVHA
FVFA
FVMV
FVBU
FVHA
FVHA
FVFA
FVBU
and many more. Here is an example of the formula for finding the most common:
{=IFERROR(INDEX(Feb!$H$3:$H$30,MODE(MATCH(Feb!$H$3:$H$30,Feb!$H$3:$H$30,0))), "")}
This formula works great, except I want it to ignore blank cells.
Here is an example of the formula for finding the 2nd most common:
{=IFERROR(INDEX(Feb!$H$3:$H$198,MODE(IF(COUNTIF(I$5:I6,Feb!$H$3:$H$198)=0,MATCH(Feb!$H$3:$H$198,Feb!$H$3:$H$198,0)))),"")}
Again this works great but I would like to ignore blank cells.
If anyone could help me modify these formulas so I can ignore any blank cells in the column, I would be so thankful.
Regards!
I am trying to calculate the most common string, the 2nd most common string, up to the 10th most common. Here is some of the data:
FVHA
FVHA
FVFA
FVMV
FVBU
FVHA
FVHA
FVFA
FVBU
and many more. Here is an example of the formula for finding the most common:
{=IFERROR(INDEX(Feb!$H$3:$H$30,MODE(MATCH(Feb!$H$3:$H$30,Feb!$H$3:$H$30,0))), "")}
This formula works great, except I want it to ignore blank cells.
Here is an example of the formula for finding the 2nd most common:
{=IFERROR(INDEX(Feb!$H$3:$H$198,MODE(IF(COUNTIF(I$5:I6,Feb!$H$3:$H$198)=0,MATCH(Feb!$H$3:$H$198,Feb!$H$3:$H$198,0)))),"")}
Again this works great but I would like to ignore blank cells.
If anyone could help me modify these formulas so I can ignore any blank cells in the column, I would be so thankful.
Regards!