Can you see if you can help me with this Excel issue,
What I am trying to do is:-
If the value in column D is in column C then output the corresponding column E value into Column A.
I have tried using the formulae which is in cell A2 but when I copy it down nothing happens??
Image attached...
Hi
I've got a formula which searches for specific text in a cell, then returns a phrase if that text is in the cell.
In the example below, if the word "Now" appears in the text in cell A1, then the phrase "Fixed Price Discount" will appear in cell B1.
The formula I have used is...
<tbody>
A
B
C
Tests
410--Troubleshoot Test
410
Troubleshoot Test
873---Water Pressure Test
Water Pressure Test
873
</tbody>
Hello,
The problem I'm having is that I have a column (Column B) of about 30 different tests that are...
I have an excel file that I am trying to do a calculation only if value of 'Closed" isn't present in another cell. Closed is a status I'm using in a drop down.
Trying to calculate if "Met SLA" or 'Did Not Meet" only if status closed is not included,
I think I need to consolidate a Search and...
I Have an extensive spreadsheet, with very long text cells:
Content Spreadsheet with cells like: (about 20.000 lines)
1. Complete/Long Manufacturer Name
2. Complete/Long Product Full Description
3. Lookup columns to be added:
[*=2]Part Number
[*=2]Type of Product
[*=2]Classification...
I am trying to build a nested formula that will search in a url string for a set of keywords and return a label.
I have tried several different ways of doing this and have not been successful.
Here are my attempts.
Thanks in advance for any assistance on this question...
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.