Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array, Match, Ignore and List
rA column has many many rows and most of them are empty. Those having
figures look like (100) (99) (98) (4) (3) (2) (1) 0 10 98 99 100 As you can see, some of them offset each other and the result of offseting is zero. And the 10 = absolute(sum(-1,-2,-3,-4). What I need from this procedure is a list showing 10 and its counterparties. My thought is that first step is a fill an array with these non-blank figures. Next step is to offset those "offsetable" to get rid of them. Third step is to list those "un-offsetable". Any comments or code to share? Thanks a lot! H. Zhu |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need array formula to ignore hidden values | Excel Worksheet Functions | |||
MATCH to ignore blank cells in array | Excel Worksheet Functions | |||
Ignore #N/A error using Index and Match Functions | Excel Discussion (Misc queries) | |||
Array, Match, ignore, List | Excel Programming | |||
Help with SUMIF or array function to ignore #VALUE! | Excel Worksheet Functions |