Replies

Thanks-That’s the info I needed.

No that’s perfect and the speed is hardly noticeable.

Thanks

Using this Array formula:
{=MAX(IF(Tracker!$D$11:Tracker!$D$65488=D15,Tracker!$P$11:Tracker!$P$65488))}

If P11 to P65488 is blank, I get a date 1/0/1900. Instead of the date, how can I get NONE to be displayed in the cell?

I tried:
{=MAX(IF(Tracker!$D$11:Tracker!$D$65488=D15,Tracker!$P$11:Tracker!$P$65488,”NONE”))}

but no luck, the date still appears???

Found the problem, it all works fine thanks.

I get a runtime error 52 with the cursor blinking at the line with the red arrow.

Thankyou-Very well explained!

Questions
The column(s) I am importing from the different sheets contain formulas, How can I modify the code to extract the values-which are dates by the way.

also
The data extracts down one column, as the code directs it to do. Can each worksheet extraction be placed side by side say column c,d,e,f,g, etc. when it is imported into the blank workbook? I have it extracting to column C right now.

I would like to be able to loop through all the workbooks in a directory.

Well, I could have worked on that for 10 yrs and never come up with that formula.

Works like a champ. Thanks a bunch.

Well, at least when I initially looked at it it was a smiley, it looks normal now……..hmmmmmmmmmmm

For column F use =sum(F:F)/11*9

VegasNath’s formula got transposed into a smiley

Would a pivot table suit your needs?

see attached in sheet1

Appears to be the “Data Validation Formula” was copied across and absolute wasn’t applied.

So Col E & F work fine, but Column G now refers to Column F and Column H refers to Column G.

That’s if I understand correctly.

That’s neat

I like the file size also.
You have several pictures here.
Small file–thanks again

An alternative approach (which has been mentioned here I believe) is to include the photograph as a cell ‘comment’.

Thanks, I recall reading about that a while back.