Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array, Match, ignore, List
A column has many many rows and most of the rows are empty. Those with
figures show a pattern like (100) (99) (98) (4) (3) (2) (1) 0 10 98 99 100 As you can see that some of the cells offset each other and the result of the offsetting is zero. The rest will be offsetted by group, that is, 10 = absolute (sum(-1,-2,-3,-4). What I need is to generate a list with 10 and all its components. My thought is that first step to fill an array with those figures. Next step is to get rid of (or not counting) the duplicates (those with absolute same numbers). Third step is to list 10 and 1,2,3, 4. Any comments or code to help me start? Thanks a lot! H.Zhu |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array, Match, ignore, List
Take a look at this link.
I have a strong feeling that it will solve your challenge: http://www.tushar-mehta.com/excel/te...olver_Template EagleOne Curious wrote: A column has many many rows and most of the rows are empty. Those with figures show a pattern like (100) (99) (98) (4) (3) (2) (1) 0 10 98 99 100 As you can see that some of the cells offset each other and the result of the offsetting is zero. The rest will be offsetted by group, that is, 10 = absolute (sum(-1,-2,-3,-4). What I need is to generate a list with 10 and all its components. My thought is that first step to fill an array with those figures. Next step is to get rid of (or not counting) the duplicates (those with absolute same numbers). Third step is to list 10 and 1,2,3, 4. Any comments or code to help me start? 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) | |||
Help with SUMIF or array function to ignore #VALUE! | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions |