| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Hi Domenic,
Thank you for all your helpful advice. Cheers, Sam Sam wrote: I just changed the MOD divisor to 1 instead of 8. Domenic wrote: In that case, you can eliminate the MOD argument... =MODE(IF(SUBTOTAL(3,OFFSET(Results2,ROW(Results2 )-MIN(ROW(Results2)),0,1) ),IF(ISNUMBER(Results2),Results2))) ...confirmed with CONTROL+SHIFT+ENTER. Hope this helps! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200509/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
| Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
Threaded Mode
