Hi,
The sheet to display results in is called "Overview".
The sheet and column I want to find out the Conditional MAX for is "Netsuite" J:J based on the exclusion of any rows on the same sheet which contain the value "yes" in the column S:S
The current formula I have is =MAX(Netsuite!J:J) but this displays the max number even if there is a yes value in the S column which is for completed. I don't need to know the max of a completed row.
Thanks in advance.
Northcoms
Last edited by northcoms; 07-01-2013 at 08:01 AM.
Try this
Formula:
Please Login or Register to view this content.
Please confirm the formula by Ctrl + Shift + Enter Not just Enter
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
=MAX(IF(Netsuite!S:S<>"Yes",Netsuite!J:J,""))
entered with ctrl+shift+enter
Josie
if at first you don't succeed try doing it the way your wife told you to
Array formula
=MAX(IF(Netsuite!S:S<>"Yes",Netsuite!J:J))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
Life's a spreadsheet, Excel!
Say thanks, Click *
Originally Posted by Debraj Roy
Try this
Formula:Please Login or Register to view this content.
Please confirm the formula by Ctrl + Shift + Enter Not just EnterThanks Guys,
Excellent answer that works precisely how I intended.
Much appreciated.
Northcoms
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks