apologies

  1. S

    Not sure where to start. NOOB Q

    My apologies if this has already been asked and answered, but I'm not sure I even know what to search for :) I was wondering if there was a formula (or method) for excel to auto-complete or auto-fill data to the right using data pulled from another source when a value from a drop-down list...
  2. I

    Index+match+small+if+countif formula

    Good day, I have been using a formula below to calculate SP id's and sale amounts. It worked fine but suddenly it does not pick up the next ID number. Apologies - I do not know how to paste the example properly. {=INDEX($H$20:$H$29,MATCH(SMALL(IF(COUNTIF($K$19:K19, $H$20:$H$29)=0...
  3. U

    Formula Calculation Error

    Good morning all, I'm getting an error that is (as errors usually do) driving me crazy! It is a fairly simple calculation that works on hundreds of other lines ... except for one. The cell in question is M36 Apologies, as this is my first post and I do not know how to attach a spreadsheet...
  4. M

    Data Validation - Allow Any Value

    Hi, I wish to validate a cell (lets say A1) as below. - If B1 = "cat" then allow dropdown List 1 - If B1 = "dog" then allow dropdown List 2 - If B1 = "fish" then allow free text / anything Any ideas? Help appreciated. Apologies if an answer has already been posted but i couldnt find it...

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