p36

  1. S

    too many arguments

    How can I make this work? I will be forever grateful for your help. =AVERAGEIF(E16 P16 AA16 H15 P26 AA26 E36 P36 AA36 E46 P46 AA46,"<>0",AA46 P46 E46 E36 P36 AA36 AA26 P26 E26 E16 P16 AA16)
  2. J

    Copy part of a range with For each Loop ?

    Hi, Unsure of best way to achieve this but I'm thinking with a for each loop. Copy each row in Range(A10:H5000) if value in Column P is 0 to a new sheet Example if just P22, P36, P80:P100 contain a 0 then copy: A22:H22 A36:H36 A80:H100 Thanks for any help

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top