Senin, 03 September 2012

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

__._,_.___
Recent Activity:
----------------------------------
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

----------------------------------
.

__,_._,___

Tidak ada komentar:

Posting Komentar