AMATCH

[Brett]

Does anyone know where to find information about the AMATCH function? There
is no help available in my excel help files on how to use this function. I
tried running a search for "AMATCH" in Microsoft Office Onlene, Microsoft
Knowledge Base, and even All of Microsoft.com but all I get is "Sorry, no
results were found".

[Dave Peterson]

Maybe you mean =match()?

You can refer to Excel's help and Debra Dalgleish's site:
http://www.contextures.com/xlFunctions03.html

Brett wrote:
>
> Does anyone know where to find information about the AMATCH function? There
> is no help available in my excel help files on how to use this function. I
> tried running a search for "AMATCH" in Microsoft Office Onlene, Microsoft
> Knowledge Base, and even All of Microsoft.com but all I get is "Sorry, no
> results were found".

--

Dave Peterson

[Ron Rosenfeld]

On Thu, 3 Mar 2005 18:41:01 -0800, "Brett" <[email protected]>
wrote:

>Does anyone know where to find information about the AMATCH function? There
>is no help available in my excel help files on how to use this function. I
>tried running a search for "AMATCH" in Microsoft Office Onlene, Microsoft
>Knowledge Base, and even All of Microsoft.com but all I get is "Sorry, no
>results were found".

AMATCH is not a built-in Excel function. Most likely it is a UDF (user-defined
function) and you would have to speak to whoever wrote the code for it.


--ron

[Debra Dalgleish]

Charles Williams' FastExcel has an AMATCH function. Maybe that's it:

http://www.decisionmodels.com/FxlV2WhatsNew.htm

Dave Peterson wrote:
> Maybe you mean =match()?
>
> You can refer to Excel's help and Debra Dalgleish's site:
> http://www.contextures.com/xlFunctions03.html
>
> Brett wrote:
>
>>Does anyone know where to find information about the AMATCH function? There
>>is no help available in my excel help files on how to use this function. I
>>tried running a search for "AMATCH" in Microsoft Office Onlene, Microsoft
>>Knowledge Base, and even All of Microsoft.com but all I get is "Sorry, no
>>results were found".
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[Gord Dibben]

Brett

Search the 'net.

You will find references to AMATCH in PERL for fuzzy matching.

Definitely not an Excel Function.


Gord Dibben Excel MVP

On Thu, 3 Mar 2005 18:41:01 -0800, "Brett" <[email protected]>
wrote:

>Does anyone know where to find information about the AMATCH function? There
>is no help available in my excel help files on how to use this function. I
>tried running a search for "AMATCH" in Microsoft Office Onlene, Microsoft
>Knowledge Base, and even All of Microsoft.com but all I get is "Sorry, no
>results were found".