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

__._,_.___

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

Messages in this topic (26)

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

.

__,_._,___