Re: RES: [ExcelVBA] formula question

 

Deliminator sounds a little like the unknown key sequence you hit that makes your work disappear and you don't know what you did and can't figure out how to get it back.
"It's not a tuma!" It's a Deliminator. Do you men *that* Arnie?

Steve

--- "Ralph Gregory" <ralph.gregory@...> wrote:
>
> "delimininerater".George Bush? :-)
>
> Ralph> ----- Original Message -----
> >
> I kinda like "Deliminator".
>
> Seems more 'active' :o)
>
>
>
> Paul
>
>
> From: David Grugeon <yahoo@...>
> > 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
> > -----Original Message-----
>
> From: David Grugeon
> > 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: noskosteve
> >
> 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: Torstein Johnsen Enviada em: segunda-feira, 3 de setembro de 2012
> >
> > 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
>

__._,_.___

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

Messages in this topic (2)

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

.

__,_._,___