Search results

This 'could' be easily done with a UDF, but that would slow your sheet down (and should be used as a last resort. Why not extend your grid so it has space for (say) the four items ? though this would require an array formula and nearly be as slow as UDF What happens if a 'person' dosen't like...

Have you disabled events anytime recently ? Are you SURE it's in the sheet ?

40% comes from testing the formulas with micro timers, varying sizes of arrays, running a calculate (say 100 times(per time period)), measuring the time and averaging across multiple attempts with the same formulas. (and the 40% 'maybe' unique to my machine, my installation, the way I hold my...

=SUMPRODUCT((B2:B7=A12)*(D27))/SUMPRODUCT(--(B2:B7=A12)) Should be :- =SUMPRODUCT((B2:B7=A12)*(D27))/COUNTIF(B2:B7,A12)) Why make it do the work if you don't have to ? This (depending on the size of the array) should be anything up to (approx.) 40% faster.

No, you would only need to know the base folder, you could then scan through all sub-folders to look at files. This assumes that ALL the found files were of the requisite type, if not you'd have to have some "file identifier" or the system would skip that file. It's doable but it's a lot of work...

Thread Hijack

Here is an example :- http://www.puremis.net/excel/cgi-bin/yabb/YaBB.pl?num=1143633690

This is eminently doable ... We can connect to an access database using ADO or DAO and fully manipulate the database (.mdb) It's typically done when you want a multi-user database with an Excel front end. Though it does depend on what you actually want to do with it.

Cross posted to Ozgrid http://www.ozgrid.com/forum/showthread.php?t=82641

The above was not suggested for end of month (or anything after the 28th of any month) but mainly for 1st of month or when you just want the month/year e.g. MAR 2007, where it works infalibly. I also notice (from re-reading the thread) that :- a) This thread is quite old, why was it resurected...

All you need is :- (say previous date is in A1) =DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)) no toolpak, no nothin' and it wraps round years too.

Why not just use a filter ? You can specify the manufacturer specify that date must be greater than or equal to 1/9/07 AND the date must be less than or equal to 31/12/07 Then you can copy this to where ever you want, reset the filter and you are good to go again.

You can not lookup a range i.e. =>39356:<=39447 and if your are looking for a date in column 5 (i.e. E) then the column info for the table should be 4 not 5 as it starts in B. I'm not even sure what you are trying to do here. I assume you want to lookup a date to use in your if statement to...

=sum(b5:m5)

What do you mean by "going down the column" ? Do you want to test ALL of these values ?

I'd like to be a procrastinator ... maybe tomorrow ???

Ohhh ! That's a pity ... cos I'm busy !!!

Why not do as the rest of us do and enjoy being grumpy ???

That is an inspirational story, I knew a blind couple when I was young (guess they must have met that way) they always said "Thank god we are not deaf, that really cuts you off from people" I always thought that was wierd cos 90 odd percent of human input is sight. By training I am am engineer...

Sorry, only just seen this, funnily enough ... via google Yeah I did get the name changed so it matches my infamy elsewhere :) got one back for you ... Blind guy walks into a bar and orders a beer ... After a minute or so he speaks out and says ... Does anyone wanna here a blonde joke ? The...