LinkBack URL
About LinkBacks
In your example, on Sheet1 C5
=MAX(IF(TEXT(Sheet2!$F$5:$I$5,"mmmm")=C$4,Sheet2!$F$5:$I$5,0)) (CNTRL SHFT ENTER)
It is an array formula so requires CNTRL SHFT ENTER instead of ENTER
You'll need to spell February correctly for it to work.
In your example, on Sheet1 C5
=MAX(IF(TEXT(Sheet2!$F$5:$I$5,"mmmm")=C$4,Sheet2!$F$5:$I$5,0)) (CNTRL SHFT ENTER)
It is an array formula so requires CNTRL SHFT ENTER instead of ENTER
You'll need to spell February correctly for it to work.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks