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.
Optional response to your true meaning : =(MAX(IF(B1:F1>0,COLUMN(B1:F1),"")))- COUNTIF(B1:F1,0)...
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...
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...
Knowledge Base Articles By Category
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