Hi,
The adjustment worked for everything but the last 3 cells (D11:D13). These last 3 cells say "25" for number of occurrences, when they are actually 117, 78, and 111 respectively.
This is happening because the formula is encountering some error, causing it to give the content (25) of cell C1 as the output. But I am not sure what the error is.
I've attached the spreadsheet to show you what is happening.
How do you fix this?
Thank you!
Montana
Bookmarks