Alan Beban xls functions - any current repository?

[Ikester]

I have been researching passing arrays via functions with the aim of developing a generalized index/exact match function and ran across reference to an Alan Beban set of xls functions (including here). Unfortunately his home directory (http://home.pacbell.net/beban) is no longer available and the latest posts I could find date from 2008 and earlier. Does anyone know where I might find those functions?

Much appreciated for any pointers.

 

[hiker95]

Ikester,

There is a lot of information out there if your search the web for Alan Beban Excel functions

 

[Ikester]

Ikester,

There is a lot of information out there if your search the web for Alan Beban Excel functions

For sure! Trouble is none result in any current repository. I entered exactly the search terms you suggested and all but a few were links I'd already visited. None of the others were more recent, certainly none hit upon any current repository.

 

[Rick Rothstein]

I have been researching passing arrays via functions with the aim of developing a generalized index/exact match function and ran across reference to an Alan Beban set of xls functions (including here). Unfortunately his home directory (http://home.pacbell.net/beban) is no longer available and the latest posts I could find date from 2008 and earlier. Does anyone know where I might find those functions?

Perhaps if you describe in detail (with before/after examples) exactly what you are trying to do, someone here might be able to develop the code for you without your needing to find what appears to be a no-longer-available resource.

 

[Ikester]

Hello Rick! ... and thank you! Actually I've read a number of your replies to various questions and, in that regard, you have been a big help already! I find that if I struggle with a problem rather than getting a solution dropped in my lap, I learn a lot more in the process. So I tend to look for examples of issues related to what I'm aiming to do and in the process find out even more than what I bargained for. I was hoping that the Beban functions might speed the process. Oh well, if not available anymore I'll carry on. Tonight I was testing a few things and think I am seeing the light. I'll post where I end up and you - or anyone else - can tell me how I could have done even better.