> I kinda like "Deliminator".
Sounds like something "Big Arnie" would use. :-)
Regards, Dave S
----- Original Message -----
From: "Paul Schreiner" <schreiner_paul@att.net>
To: <ExcelVBA@yahoogroups.com>
Sent: Monday, September 10, 2012 9:11 PM
Subject: Re: RES: [ExcelVBA] formula question
I kinda like "Deliminator".
Seems more 'active' :o)
Paul
-----------------------------------------
"Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-----------------------------------------
________________________________
From: David Grugeon <yahoo@grugeon.com.au>
To: ExcelVBA@yahoogroups.com
Sent: Sun, September 9, 2012 10:03:41 PM
Subject: RE: RES: [ExcelVBA] formula question
My spell check was right - there is no such word as deliminator. I was
thinking delimiter, but what I really needed was list separator.
Best Regards
David Grugeon
Excel VBA Group Moderator
-----Original Message-----
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
Of David Grugeon
Sent: Monday, 10 September 2012 11:57 AM
To: ExcelVBA@yahoogroups.com
Subject: 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
------------------------------------
----------------------------------
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
[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
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1424 / Virus Database: 2437/5259 - Release Date: 09/09/12
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