validate multiple cells

  1. D

    Summing highest value in cells limited by validation.

    Good day. I have a sheet used to track scores on an assessment. I have limited the possible cell entries (using the validation function) to either full points awarded, zero points awarded, or NA. I would like to be able to sum all the cells that have either full points or zero points, BUT for...
  2. E

    Fill in values based on 2 column criteria

    Hi Guys, Im struggling to find a formula to populate cells based on values to be checked in two fields (ICODE, COMPANY). In the example shown, all records where ever the ICODE = 49, i need to populate the fields AD1,AD2,AD3 or AD4 with the Product Name of the same company name but only where...
  3. T

    Validation across multiple cells

    I been successful with the following =IF(OR(D43=0,D43="Y"),"OK","Error") in D 57 for cell D43 but want to extend it to validate D43:D45 with "OK" or "Error" displaying only in D57 for the three cells validated and I cannot figure out how .. I am so frustrated I am actually asking for 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