Hello,
I have a dataset of health center containing proportion of contraceptive coverage and whether they are title X clinics (1) or not (0). I am trying to find the min value by title X status.
title x min
non-title x min
This is my attempt but I got an error message. To me, my formula seems ok. Any thoughts.
=MIN(IF(F2:F37,1,$L$2:$L$37))
Thanks!
Marvin
That's an Array formula, use Ctrl-Shift-Enter
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Try =MIN(IF(F2:F37=1,$L$2:$L$37)) and set as an array formla (CTRL + SHIFT + ENTER)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Do you mean?
Formula:
Please Login or Register to view this content.
Pls be carefull.This is an ARRAY formula.
-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Maybe the site can provide some help. Search for MIN IF topic.
http://www.contextures.com/excelminmaxfunction.html
See this...
http://www.cpearson.com/Excel/ArrayFormulas.aspx
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thank you very much guys! I learned something new today.
Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.
You're welcome. We appreciate the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks