Charles has attended:
Excel Intermediate course
Excel formula
I have an array formula that looks like this:
{=MIN(IF('SHOT REPORT'!B$7:B$540='SCHEDULE TIMELINE'!A89,'SHOT REPORT'!BG$7:BG$540))}
This works really well and returns the minimum value from BG7 to BG540.
I'd like to add another bit to the formula that would say if there's a value in cell BI7 to BG540 of the Shot report to retrun the min value of that cell.
Please help!
Thanks
Charles
RE: Excel formula
Hi Charles
I've reporoduced your formula and as you say it works. Can you say a little more about the extra part to add? Or if possible send a copy of the file to enquiries@stl-training.co.uk
It would help to include in subject please forward to Doug.
Thanks
Doug
Doug Dunn
Best STL
RE: Excel formula - please forward to Doug
I'd like the extra bit of the formula to say something like "if there's a value in BI7 to BI540 retutn that ...instead of the value in BG7 to BG54"
So if there's nothing in BI7 to BI540 I get the valuse from BG7 to BG54 ...but if there's soemthing in BI7 to BI540 I get that instead.
Thanks!
Charles
RE: Excel formula - please forward to Doug
Hi Charles
This formula returns the min value in B7:B540 if it finds a value or the min value from BG7:BG540 if it doesn't.
=MIN(IF('SCHEDULE TIMLINE'!A89='SHOT REPORT'!$B$7:$B$540,'SHOT REPORT'!$B$7:$B$540,'SHOT REPORT'!$BG$7:$BG$540))
I'm not sure if that's quite what you are asking. To test if there are any values in B7:B540 you could try using the ISNUMBER function. However I can't find a way of incorporating that into the array formula.
Let me know if find a way, thanks.
Doug
