Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help! I can't figure this riddle out
I created a spreadsheet inside of which exists a field of 56 data
cells (8x7). These cells track other events that occur throughout the spreadsheet. Each of the 56 cells will usually equal zero, but at any given time, up to 8 of the 56 cells at random will hold a value representing an event that occurred. I need to able to generate a list of those values in the order they occurred. The seven columns of the field represent the days of the week, so the proper order would be a1..a7,b1..b7,etc. The 8 values could be in any of the cells (they may all occur on the same day.) The resulting list would be an 8 cell array that holds the values, if any, in order in the uppermost cells, with the unneeded lower cells blank. Thanks to anyone who can help me solve this riddle. It sounds so simple, but I can't grasp it. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XIRR and IRR riddle - Please Help! | Excel Discussion (Misc queries) | |||
Can't figure this out... | Excel Discussion (Misc queries) | |||
HOW TO 'BLINK' A FIGURE INSTEAD OFF BOLDING THE FIGURE | Excel Worksheet Functions | |||
Can't figure out | Excel Worksheet Functions | |||
Still trying to figure it out | Excel Worksheet Functions |