things

  1. K

    Cell Reference in a formula

    I have a file that gives me a list of all cells that have been changed. In the file it references Cell Address as a column of volumes. I need to go to that cell in the original file and copy another columns information. I have tried several different things and I just cant crack this...
  2. Y

    Filling in multiple data entries from value of single cell

    Hello everyone. I have been searching for a way to do this and don't even know the right questions to ask. I have always been able to figure things out without help, except Google, but this has me stumped. What I am trying to do is develop a plant database that will show all plants I will be...
  3. R

    Questions with PERSONAL.XLSB

    My company want to upgrade CPU, will that affect the macros that stored in PERSONAL.XLSB ? Will I have to re-record the macro again ? If there is upgrade of Excel version, will there be any compatibility issues ? What other things I need to take care for the changes ? Hopefully, the...
  4. B

    Data Cleansing

    Does anybody have any tips for large data set cleansing in excel. I work with data that originates from many different places like data warehouses, webpages, various applications. A lot of clutter comes along with it like non printable characters, spaces, html, unicode and many other things that...
  5. B

    Dara Cleansing

    Does anybody have any tips for large data set cleansing in excel. I work with data that originates from many different places like data warehouses, webpages, various applications. A lot of clutter comes along with it like non printable characters, spaces, html, unicode and many other things that...
  6. S

    Equation into Excel using PEMDAS

    Hello All, I am trying to put formula A13 into Excel but am not sure how to write it using PEMDAS. Any help would be appreciated as I can just plug in the numbers for things like Pmax and etc. Thank you in advance...
  7. C

    VBA to convert range to number

    I am trying to find a vba code that will convert a range to numbers, the range is C12:I2500. I've tried a few things that i know but no luck. Can someone help?
  8. H

    VLOOKUP with multiple results RETURNS text if multiple return values...? No vba...

    :eeek: Possible? Trying to get a non-vba solution to have a vlookup return the word "MULTI" if there are multiple RETURN values for a lookup values. Example: <tbody> <tbody> A B C D 1 lookup values Array 2 Holga 小非 9854 3 Doña 3023 4 Doña 3023 5 Holga 2 6 Holga...

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