MAX - Array Formula

**lucraft** · 06-28-2011, 06:28 AM

I cannot get the formula from the below thread to work:

http://www.excelforum.com/excel-gene...variables.html

Here's what I have used;

=MAX(IF(('Cab Level'!$C$3:$C$5152=$D3)*('Cab Level'!$H$3:$H$5152=$A3),'Cab Level'!$M$3:$M$5152))

Confirmed with CTRL+SHIFT+ENTER.

It returns blank cells, with no errors?

Any ideas??

Thanks in advance.

**teylyn** · 06-28-2011, 06:40 AM

Hello,

the formula is correct. Check the data. Check the cell references.

Post a sample workbook (just 100 rows, please)

cheers,

**lucraft** · 06-28-2011, 07:12 AM

Originally Posted by teylyn

Hello,

the formula is correct. Check the data. Check the cell references.

Post a sample workbook (just 100 rows, please)

cheers,

Thanks for the speedy reply.

Whilst creating the sample workbook, I found my mistake;

{=MAX(IF(('Cab Level'!$D$3:$D$5152=$D3)*('Cab Level'!$H$3:$H$5152=$A3),'Cab Level'!$M$3:$M$5152))}

The cell values in 'Cab Level'!$D$3:$D$5152 were VLOOKUPS to $D$3:$D$100 - I copied and pasted as values and the formula now works.

Cheers,
ML

MAX - Array Formula

LinkBack

Thread Tools

Rate This Thread

Display

MAX - Array Formula

Re: MAX - Array Formula

Re: MAX - Array Formula

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions