I need so quick assistance. I downloaded the functions in the freely
downloadable file at http://home.pacbell.net. But I don't know how to make
them available to use. Any help?

I need some quick assistance. I downloaded the functions in the freely
downloadable file at http://home.pacbell.net/beban referred to in another
post, but I don't know how to make them available to use. Any help? I
believe they could be macros, but I don't know. Alan had made reference to
making them available in Personal.xls. Again I am not familar with this
aspect of excel

http://www.mvps.org/dmcritchie/excel/install.htm


--

Regards,

Peo Sjoblom



"Josh O." wrote in message
...




I need some quick assistance. I downloaded the functions in the freely
downloadable file at http://home.pacbell.net/beban referred to in another
post, but I don't know how to make them available to use. Any help? I
believe they could be macros, but I don't know. Alan had made reference
to
making them available in Personal.xls. Again I am not familar with this
aspect of excel

I appreciate the link. Unfortunately, I don't know enough about macros to
know what I am looking at. The file I download is a spreadsheet with
explanation of functions that are included in the download, but I don't know
how to access them or make them available.

"Peo Sjoblom" wrote:

http://www.mvps.org/dmcritchie/excel/install.htm


--

Regards,

Peo Sjoblom



"Josh O." wrote in message
...




I need some quick assistance. I downloaded the functions in the freely
downloadable file at http://home.pacbell.net/beban referred to in another
post, but I don't know how to make them available to use. Any help? I
believe they could be macros, but I don't know. Alan had made reference
to
making them available in Personal.xls. Again I am not familar with this
aspect of excel

press ALT-F11 within that spreadsheet. Select all the code in there (which
are user defined functions) and copy it. Now go to the link provided and
proceed from there.


"Josh O." wrote in message
...
I appreciate the link. Unfortunately, I don't know enough about macros to
know what I am looking at. The file I download is a spreadsheet with
explanation of functions that are included in the download, but I don't
know
how to access them or make them available.

"Peo Sjoblom" wrote:

http://www.mvps.org/dmcritchie/excel/install.htm


--

Regards,

Peo Sjoblom



"Josh O." wrote in message
...




I need some quick assistance. I downloaded the functions in the
freely
downloadable file at http://home.pacbell.net/beban referred to in
another
post, but I don't know how to make them available to use. Any help?
I
believe they could be macros, but I don't know. Alan had made
reference
to
making them available in Personal.xls. Again I am not familar with
this
aspect of excel

I have the functions installed. One of the functions is "vlookups," it is
supposed to do the same as vlookup, but return multiple values from the same
lookup value. For example, if customer 1 appeared twice in a list, the
fuction should return the both of the result values.

However when I copy the formula, it displays the same value as the first
occurance. Has anyone had any experience using this type of function.

"Dave R." wrote:

press ALT-F11 within that spreadsheet. Select all the code in there (which
are user defined functions) and copy it. Now go to the link provided and
proceed from there.


"Josh O." wrote in message
...
I appreciate the link. Unfortunately, I don't know enough about macros to
know what I am looking at. The file I download is a spreadsheet with
explanation of functions that are included in the download, but I don't
know
how to access them or make them available.

"Peo Sjoblom" wrote:

http://www.mvps.org/dmcritchie/excel/install.htm


--

Regards,

Peo Sjoblom



"Josh O." wrote in message
...




I need some quick assistance. I downloaded the functions in the
freely
downloadable file at http://home.pacbell.net/beban referred to in
another
post, but I don't know how to make them available to use. Any help?
I
believe they could be macros, but I don't know. Alan had made
reference
to
making them available in Personal.xls. Again I am not familar with
this
aspect of excel