RES: [ExcelVBA] formula question

 

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 (24)

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

.

__,_._,___