Re: Vedr: Vedr: [ExcelVBA] Find position of first non-zero in range

 

Thanks for getting back Torstein... Good formula...

I was experimenting with changing the values so a contiguous text string and then using FIND.

This is way far better.

Lisa (Group Moderator)

Sent: Sun, Dec 16, 2012 8:28 pm

Subject: Vedr: Vedr: [ExcelVBA] Find position of first non-zero in range

Hi again, nested IF-functions is a mess. After some googling and trying/failing
I'm up with

= match(true;INDEX(A1:A10<>0;0);0)

It's translated from my norwegian Excel, hope its readbale in an english excel.

Torstein

[Non-text portions of this message have been removed]

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (12)

Recent Activity:

• New Members 3

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___