Can anyone help ------ please!

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

I am stuck on a formula.

The following is the formula I will be using in the worksheet.

=IF(Num>0,INDEX(locations,SMALL(GetRow,1)),"")&IF(Num>1,",
"&INDEX(locations,SMALL(GetRow,2)),"")

What follows is the formulas for each of the defined ranges I have created.

Num: =SUMPRODUCT(CCRef=ControlCentre!$C73)

CCRef: =Potting04!$O$7:$O$100

Locations: =Potting04!$H$7:$H$100

GetRow:
=if(ccref=ControlCentre!$C73),row(locations)-cell("Row",locations)+1)

I am getting stuck on the last defined range, "GetRow". This formula is not
correct.
If you have difficulty interpreting what I am trying to get across I will be
happy to clarify further. I hope someone can help me out on this one.

Thanks
Pat
 
That solved that! many thanks.

It appears that the formula

may not be correct as I have modified this from an earlier formula in
another workbook I have used.

Num: =SUMPRODUCT((plants=MasterStock!$C25)*(pots=MasterStock!$D25))

The one I currently want to use is preventing a value from returning in

It seems to me that the function SUMPRODUCT is not suitable forreference does not change.

Any thoughts on this?

regards and again thanks.
Pat
 
Back
Top