| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to count the maximum number flanked by zeros
On Sunday, November 16, 2014 8:05:00 PM UTC+8, Tez wrote:
Hi all! I have some numbers zeros and non-zeros in Column A and would like to see the maximum number flanked by zeros in Column A's non-zero range in Column B. What formula should be written in cells in Column B? A B 0 0 0 0 3 7 2 7 6 7 7 7 0 0 0 0 0 0 8 8 2 8 3 8 0 0 Danke sehr! Sie sind super!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count the maximum number of consecutives? | Excel Worksheet Functions | |||
| Need 7 digit number with differnt number of leading zeros | Excel Discussion (Misc queries) | |||
| Essbase: Text zeros to number zeros | Excel Discussion (Misc queries) | |||
| how to count maximum number of lines repeated for a site | Excel Worksheet Functions | |||
| Maximum Count | Excel Programming | |||
Hybrid Mode
