Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need array formula to ignore hidden values NickH Excel Worksheet Functions 1 March 4th 11 01:12 PM
MATCH to ignore blank cells in array Tony Gardner Excel Worksheet Functions 3 September 10th 09 02:00 PM
Ignore #N/A error using Index and Match Functions winnie123 Excel Discussion (Misc queries) 1 August 10th 09 03:22 PM
Array, Match, ignore, List Curious[_6_] Excel Programming 1 May 1st 09 01:39 AM
Help with SUMIF or array function to ignore #VALUE! Nelly[_2_] Excel Worksheet Functions 2 January 20th 09 02:51 AM


All times are GMT +1. The time now is 06:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"