help combination

  1. P

    Inserting an If Function

    I'm having trouble inserting and extra if function at the beginning of my formula. I have a 'Job sheet' which informs my workshop of what to produce based on what has been quoted (information for the job sheet is gathered from another sheet in the same worksheet). Currently, I have the...
  2. G

    Vlookup with If statement Issue

    Hi Guys, I have a keyword data dump that has 2 of every keyword (one has data for desktops, one has data for smartphones) I would like to write a vlookup formula that will first check if the keyword is "desktop". If so, pull the corresponding rank (which would skip over the smartphone rows)...
  3. K

    Excel Formula

    Dear all, Did any one can teach me how to set this difficult formula in excel cell ? Please refer to the image as below. Thank you.
  4. L

    Vlookup with a scenario

    Hello again, I need help with a vlook up formula. What i would like from the vlook up is illustrated below. There are two seperate pull sheets, well call them a & b. The user starts by selecting a scenario. The scenario indicates which months would be pulled from where. For example if the...
  5. W

    Help!Routing Combination

    Hey guys.. I am a newbie in this forum. I want to ask about combination procedure for following problem: I have 9 routes: 1. AB 2. BC 3. AD 4. AC 5. CD 6. DE 7. AE 8. AB 9. AC I want to display all possible combination of these routes with contraint the routes must include node ABCDE. I thought...

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