Posted to microsoft.public.excel.programming

filo666

external usenet poster

Posts: 265

Working with arrays

Hi, I have some operations that i think VB has some easier way to accomplish
or may be a function:

1)The sum of all the array elements
2)Get just the array elements different of "" or 0
3)Get juste the array elements that they are not repeated (i mean
arr1(1,1,2,z,z,3,3,4,4,4,1,1,4,5) to arr1(1,2,3,4,5,z)

TIA

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Working with arrays as arguments	HB	Excel Worksheet Functions	6	September 30th 09 02:48 PM
SUMPRODUCT with 3 arrays not working	Kierano	Excel Worksheet Functions	1	October 16th 06 03:37 PM
Working with Arrays	Judy	Excel Worksheet Functions	1	January 11th 06 12:22 AM
Excel2000: Need help on UDF (working with arrays)	Arvi Laanemets	Excel Programming	2	April 22nd 05 05:51 PM
working on 2 different worksheets....arrays?	monika	Excel Programming	6	February 10th 04 11:40 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us