compare two lists

  1. J

    Compare Copy Paste

    I am trying create and Excel Formula. To compare columns of names and then copy a number in a column next to the correct name. More info Column A = Actor ID Column B = Actor Column H, K, N, Q, T, W, Z = Actor Column G, J, M, P, S, V, Y = Actor ID (This is the column that I want a copy of the...
  2. mdeshazo

    find MIN and MAX dates based on rate criteria in another cell

    First - I have been using ther board for 6 years. And this online community is SO AWESOME at what ya'll do I have not had to ask a single question of my own - until now. I have a spreadsheet in which I must keep the VBA to a minimum, so most of solutions thus far have been formulas. And while...
  3. V

    comparing two lists

    hello I have a list of names, some of which occur several times, with values attributed to the names in the adjacent column. I want a list in which the names occur once and the all the values belonging to the name appear in the row the name is in. I have code which almost does it, but not...

Some videos you may like

This Week's Hot Topics

  • Check VBA code to locate value in cell
    Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
  • Reverse Numbers Formula
    Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
  • Count If Issue
    Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
  • VBA Check for multiple cell values and copy the cell in column A
    Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
  • Sending mails to specific recipients based on a cells value
    Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
  • Matching Number in Textbox
    Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...
Top