• ### Knowledge Base Articles By Category

There is no available content written by Kev@Radstock
• ### Recent Forum Posts

#### 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 Today, 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 Today, 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 Today, 03:34 PM

#### differences between Excel.workbook... and ~.CurrentWorkbook function

I have now adapted the workaround "Calculation of duration" so that it can be used directly for the import from a workbook as well as for the...

pinarello Today, 02:51 PM

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

One way!

In I5 copied across and down:

=COUNTIFS(\$C5:\$F5,">="&MIN(N\$5:N\$13),\$C5:\$F5,"...

AliGW Today, 08:36 AM