Forum Discussion
MichalK55
Sep 06, 2023Copper Contributor
how to count cells with one number between two different numbers
Hello, In column D, I need to count the occurrence of the value 5 that appears between the values 18 and 19. I don't want to count any other value 5 in this column. Can anyone advise how to do this ...
HansVogelaar
Sep 06, 2023MVP
The OP can decide which version they like best.
PeterBartholomew1
Sep 07, 2023Silver Contributor
I don't think I am in contention.
I found a reference to an after dinner speech on spreadsheets from 20 years ago.
eusprig-2004-after-dinner-speech.pdf
It lays out very clearly why nothing I write could appeal to more than 10% of forum members. There are so many things about spreadsheets that, as an abstract thinker, I find detestable. They are precisely the reason that the spreadsheet, Excel in particular, is so successful!