RE: RES: [ExcelVBA] formula question

 

Hi Steve

I think the list deliminator in Reinaldo's country must be a semicolon
rather than a comma.

For most users the comma is probably required.

Best Regards
David Grugeon
Excel VBA Group Moderator

-----Original Message-----
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
Of noskosteve
Sent: Monday, 10 September 2012 11:44 AM
To: ExcelVBA@yahoogroups.com
Subject: Re: RES: [ExcelVBA] formula question

Is that formula correct? 2007 errors and this works:
=ADDRESS(ROW(),MATCH("x",A4:E4,1))

Steve

--- In ExcelVBA@yahoogroups.com, "Reinaldo" <reinaldomarco@...> wrote:
>
> if you intent to use on line by line; Try this:
>
>
>
> =ADDRESS(ROW();MATCH("x";A1:E1))
>
>
>
> De: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] Em nome
> de Torstein Johnsen Enviada em: segunda-feira, 3 de setembro de 2012
> 16:33
> Para: ExcelVBA@yahoogroups.com
> Assunto: [ExcelVBA] formula question
>
>
>
>
>
> I have 5 columns (A-E) in a sheet. In one of them there are an "x".
>
> In the same row in column F I want a formula that tells me in which
> column the "x" is.
>
> I am able to write a nested IF-formula, but I think there may be a
> better solution.
>
> Thanks for any suggestions!
>
> regards Torstein
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

----------------------------------
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

----------------------------------Yahoo! Groups Links

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (27)

Recent Activity:

• New Members 4

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

.

__,_._,___