• ## p45cal

There is no available content written by p45cal
• ### Recent Forum Posts

#### Number of consecutive cells in a row

Optional response to your true meaning : =(MAX(IF(B1:F1>0,COLUMN(B1:F1),"")))- COUNTIF(B1:F1,0)...

Roger Haney Yesterday, 08:55 PM

#### Number of consecutive cells in a row

If I understand you correctly, then this formula will work : =(MAX(IF(B1:F1>0,COLUMN(B1:F1),"")))-1. The " -1 " at the end of the...

Roger Haney Yesterday, 08:30 PM

#### Tracking numbers in a row & counting them in columns

Try this one in I5 copied across and down:

=SUMPRODUCT(COUNTIF(\$H5:\$K5,S\$5:S\$13))

=MAX(range) simply finds the...

AliGW Yesterday, 05:32 PM

#### Tracking numbers in a row & counting them in columns

Ali what you did was perfect and brilliant and I have a use for those numbers in that order.

How would the formula be different if my numbers...

ExcelHelpNeeded Yesterday, 04:51 PM

#### Tracking numbers in a row & counting them in columns

That is brilliant! I was making this soooo much more complicated. I have never used or even seen the &MIN and &MAX though. Can you explain how...

ExcelHelpNeeded Yesterday, 03:34 PM