replace values

  1. N

    Replacing value based on cell color

    Hi All, I am looking for your help in the below scenario. i am trying to replace values in column A if the font colour is green and it has a text “Expiring”. These should be replaced with cell value “Issued” and interior colour should be Amber. Below is the code I have used. Can you please let...
  2. C

    Formula to return a code per row based on multiple criteria and steps-EXPERT needed

    Good day Excel forum, I need the help of an expert to solve a puzzling and challenging problem. I will try to explain in the shortest way possible, but need to be thorough to explain in clarity. In the table below, I have need of a formula in the "Code" column to do some very specific...
  3. J

    Paste Range varies, need fix to replace and sort pasted cells only

    So when I paste it's always the same amount of cells from sheet "V All" cells A1:A9300 and they get pasted to the first blank cell in sheet "CLEAN ALL". BUT... I need to do the replace and sort of the range its pasting onto only which will change based on where it pastes... hope that makes sense...
  4. N

    How to replace several old values with new values on multiple tabs?

    I have a bit more than hundred tabs and want to clean the data on those tabs. Some values are written in multiple ways. If I do not want to find & replace all old values one by one on all tabs, how can I find old value and replace them with new values at once, if I create a new tab with old...
  5. E

    Copying duplicate rows down

    Hello everyone, i hope someone can help me out; i put the question in the excelsheet, but here a summary; With vlookup i gathered some results from other worksheets. There is a column called "Firm" with a standard value "3000" Now i need to do the following; for every row i found results...
  6. G

    VBA to replace values with Yes or No

    Dear All, I am looking for a better way to change a list of values to Yes or No. I have the below code which works fine. It examines the value on each line one at a time. This takes a long time since I have many records. ' Convert Exclude from a Value to Text (Yes or No)...
  7. M

    Replacing values

    Hello All, I'm using Excel 2010. I'd like someone to help me with this problem please. I'd like a formula to replace values that shows up in a different group of cells. In the first group of cells (yellow group), are a series of numbers. These numbers represent the numbers that are drawn...

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