Vedr: RES: [ExcelVBA] formula question

 

 
Thank you Reinaldo for your solution that works great.
 
Even better for my purpose is the column number, so I changed the formula a bit and ended up with:
 
=match("x";A1:E1).
 
Excellent and a lot better than my nested IF-formula.
 
Regards Torstein


________________________________
Fra: Reinaldo <reinaldomarco@yahoo.com.br>
Til: ExcelVBA@yahoogroups.com
Sendt: Mandag, 3. september 2012 21.45
Emne: RES: [ExcelVBA] formula question


 

if you intent to use on line by line; Try this:

=ADDRESS(ROW();MATCH("x";A1:E1))

De: mailto:ExcelVBA%40yahoogroups.com [mailto:mailto:ExcelVBA%40yahoogroups.com] Em nome de
Torstein Johnsen
Enviada em: segunda-feira, 3 de setembro de 2012 16:33
Para: mailto:ExcelVBA%40yahoogroups.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]

[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 (25)

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

.

__,_._,___