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...
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)...
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...
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 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.