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

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top