• ## Pecoflyer

There is no available content written by Pecoflyer
• ### Recent Forum Posts

#### How to calculate combinations

or
=SUMPRODUCT((MID(B20,ROW(\$1:\$99),1)=",")*1)+1...

caabyyc Today, 08:34 PM

#### Finding values in a range of from/to arrays

Yes, your are right, sorry for that.

(revised) B2=IFERROR(LOOKUP(1,0/((A2>=ranges!\$A\$2:\$A\$18)*(A2...

caabyyc Today, 07:51 PM

#### Finding values in a range of from/to arrays

I note that there are gaps between some of your ranges and that none overlap, so a simple formula in B2 of the data sheet:

Code:
`=SUMPRODUCT((\$A2>=ranges!\$A\$2:\$A\$18)*(\$A2=ranges!\$A\$2:\$A\$18)*(\$A2=ranges!\$A\$2:\$A\$19)*(\$A20,ROW(ranges!\$A\$2:\$A\$19),""))`
...

p45cal Today, 07:30 PM

#### Finding values in a range of from/to arrays

Thanks caabyyc, but it doesn't work properly. Example is 50041 or 50042, neither of those is found in the from/to columns in the ranges! worksheet. This...

HuRocan Today, 07:26 PM

#### Help needed for excel vba code

rahiljaved/ROG, cross post one more time without supplying links and you're gone from here.