identical values

  1. P

    How to Find / Separate a Number from Message Text

    Is there a way to find and seperate a number from message text? These are all errors within the system. Ultimately I would like to identify material numbers that are generating multiple errors. Below are several examples. In some cases, the number is not completely seperated (adjoined to...
  2. D

    Excel formula question

    How can I create a formula that will search a column for identical values and then sum total key identified columns?
  3. J

    Dupicate search

    I would like when entering an identification # to be able to have Excel automatically search the same column to find if it was previously in the database, and if so, to place a "1" if it has been repeated or a "2" if it has not in another column. I was thinking I would need an IF function to do...
  4. J

    vlookup problem

    Hi, I have a list of items where column A has an invoice # and column B has item(s) matching with that invoice. I would like to do a VLOOKUP from another worksheet where I can type in the invoice # in one cell and have it spit out all the items that match that invoice #. Right now I can only...
  5. S

    Linking spreadsheets?!?

    OK im half way there. I have in my Word document my excel spread sheet, and on the 2nd page i have a 'paste special', 'paste link', 'picture' spreadsheet (copy of the first) The whole reason is because i want the second to update itself if i do anything to the first one BUT... as soon as i...
  6. S

    Create Identical Spreadsheets?

    I have embedded a spreadsheet into microsoft word with all formulas working. I would like to have exactly the same spreadsheet on page 2 of my document but linked to the spreadsheet on page 1, so that if i change any values on the first excel sheet, the second will also change. Effectively i...
  7. L

    Compare if identical value in all 7 columns

    I have a spreadsheet of hundreds of MAC addresses in 12 columns. I want to check that every column has the exact same list. As an example, let's say four columns with five values each, like this. Note that one row has XXX. 123 ABC F7F CDC 123 ABC F7F CDC 123 XXX F7F CDC 123 ABC F7F...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top