• ## shishir48

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

#### How to Copy From Multiple Sheets Based On 1 Sheets Input

However, I do have one last question. I've edited the sheet and made it into its final format.
We had previously discussed having a specific column,...

Pahickham Yesterday, 10:16 PM

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

My ranges do not overlap, and this seems to be working, thank you very much for your help....

HuRocan Yesterday, 09:46 PM

#### How to calculate combinations

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

caabyyc Yesterday, 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 Yesterday, 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 Yesterday, 07:30 PM