Solution to Error: Finding Minimum Value With Second Condition Met

Finding Minimum Value With Second Condition Met

Let's say I have the data below, in columns A and B.  I'm trying to construct a formula, if possible, that would select the row that meets the condition that says "the value in column A is the minimum value for which the value in column B equals 1".  So
in the sample below, the next-to-last row has the absolute minimum value in column A, but the value in column B is zero.  The correct choice would be the third row, which has the "most minimum" value (51) that is also flagged with a "1" in column B.
 
Thanks in advance for the suggestions,
 
Eric
 


102
1

66
1

51
1

82
1

107
0

70
1

67
0

0

81
1

29
0

79
0

Keys to the Problem Finding Minimum Value With Second Condition Met

Download Error Fixer for Free Now

Eric,
Try this array formula (assumes data in A2:B12):
=MIN(IF(B2:B12=1,A2:A12,""))
 
_________________
Regards, Tom

Check Windows System Requirements

This error can be due to some configuration requirements for you system. If your computer hardware is not up to par, then make sure you upgrade where necessary before continuing:

Microsoft Windows Requirements :

• 1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
• 16 GB available hard disk space (32-bit) or 20 GB (64-bit)

Another Safe way to Repair the Problem: Finding Minimum Value With Second Condition Met:

 

 

How to Fix Finding Minimum Value With Second Condition Met with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your system. When you open it, it will perform a scan.

2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in this software. Like dll downloading, windows updating and print spooler error repair.

Related: 2 GIG SD Cards and Windows 7 64 Bit Puzzler adobe reader doesn t work with ie8 in Windows 7 Home Premium Can t read pps powerpoint attachments from my Windows Mail Are there Windows 7 drivers for an Adaptec 2940U SCSI card Brightness won t adjust with Windows 8 1 BSOD Windows 8 help After automatic Windows Updates all pictures are blurry in Internet Explorer 9 Can you install flash on Windows CE7 to enable online flash games to play Action Center telling me to download 32 bit drivers when I am running 64 bit Windows 7 Catalyst Control Center Host application has stopped working Windows is checking for a solution to the problem when logged in to Windows Can t use the edit toolbar in Windows Live Movie Maker Custom created wallpaper in Vista loses resolution in Windows 7 Compatibility issue with Starz and Windows 7 64 bit Desktop Icons disappear when right clicking on desktop in Windows 7 After updating to Windows 8 1 receiving error code 0X80070002 and all of my apps stopped working Do I need the original Windows disks to use Virtual PC 2007,Can I Download Elgato Eye Tv3 Digital Receiver Since My Laptop Does Not Have A Cd Player?,Printer Problem After Win 7 SP1 Installed,HomeGroup Not Working Both Ways,MapPoint Microsoft 2011 Problems Working New Down Load Complete But Software Will Not Open And Work...running Windows 7,I Justed Randomly Start Getting The Blue Screen And I Cant Figure Out The Problem.
Read More: [Solution] Can't turn off the Formula option in Excel 2007,Win 7 Backup and Restore program Content Question [Solved],Troubleshoot:Is Adobe 7.0 compatible with Windows Vista?,Fast Solution to Error: how do I change the user account from limited access to administrator when there's no administrator account on the machine?,Tech Support: Audio playback on ITunes,Tips On How To Decorate Your Apartment,Regular MBA vs Online MBA,A Review of the Google Assassin Google Adwords Course,Attempting to logon to windows7 home premium,Hard drive NTFS file structure error reported by Windows events.