Hello !
I need help with a problem.
I attached a excel fille.
The A Column consists of either ''1'' cells , or blank cells.
At the bottom there is a yellow cell.
I need a formula in the yellow cell that would tell me the maximum number of instances of solitary 1 cells before the number 1 appears either in a group of 2 , or 3 , or 4 or more cells.
For instance , in the example i provided , the result in the yellow cell should be 5.
Thank you.
Here is a solution using a helper column. (There might be a single-formula solution without a helper column.)
I would really suggest that you consider upgrading to a newer version of Excel. There have been so many changes in the last 22 years that it will be difficult to get solutions from people that will still work in that version.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
If the first and last cells are empty, you can use an array formula:
=MAX(FREQUENCY(IF((A1:A44="")*(A2:A45=1)*(A3:A46=""),ROW(A2:$A45)),IF((A2:A45=1)*(A3:A46=1),ROW(A2:A45))))
.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks