Home |
Search |
Today's Posts |
#30
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Peter:
"Peter T" <peter_t@discussions wrote in message ... Appears to produce a 1 in each row that should be counted. This is along the lines of what I mentioned in my previous to Bob, namely if 6 + 1 true's in a row then count. But I can't figure how to "count" this into a single formula. Exactly. And therein lies the problem. As I said, *perhaps* this can be done with matrix multiplication (MMULT) but I don't have a large enough supply of aspirin to try and explore that option! I think I'll leave it as an exercise for Harlan <g. Regards, Vasant |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional format on first & last digit on 3 digit cell data | New Users to Excel | |||
Convert 2 digit month to 4 digit years and months | Excel Worksheet Functions | |||
Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) | |||
Tell users how to sort 5 digit and 9 digit zipcodes correctly aft. | New Users to Excel | |||
When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) |