If this is your first visit, then welcome! Be sure to check out the FAQ by clicking the link above.Register here so that you can post in the forums or comment on the articles.
Try this one in I5 copied across and down: =SUMPRODUCT(COUNTIF($H5:$K5,S$5:S$13)) =MAX(range) simply finds the...
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...
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...
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...
One way! In I5 copied across and down: =COUNTIFS($C5:$F5,">="&MIN(N$5:N$13),$C5:$F5,"...
Knowledge Base Articles By Category
Recent Forum Posts
Tracking numbers in a row & counting them in columns
Try this one in I5 copied across and down:
AliGW Today, 05:32 PM=SUMPRODUCT(COUNTIF($H5:$K5,S$5:S$13))
=MAX(range) simply finds the...