comapre

  1. J

    sheet to sheet value comparison.

    Hi, I have code below to check if column F and D values are in other page, Column E,G,H should be in other page as well. So I have code below. This code is not working correctly it ignores the comparison from other page. Private Function rowLast() rowLast =...
  2. N

    Formula for comparing two lists

    I have two lists that I want to compare. I have numbers in both lists, one in column C, the second in column H. I then have information in column I. I want to compare the list in column H to that in C. If a match is found between the two columns, I want excel to put the information in column...
  3. M

    Help me for search and compare

    Hi I have a vb script which compares two worksheets in two different work books. Life is green as long as it finds the same row on both sheets. If a row is missing in target my compare fails every data from that row onwards. I have 60,000 rows of data from Colum A- R see below example...
  4. M

    problem comparing rows and copying result to another sheet

    i have a problem with macro that compares rows here's how it should work if row starts with t76 then comapre row t76 with other rows (t75, t74), i want the macro to compare like follows : if Connector1 and Connector2 from t76 are the same Connector1 and Connector2 from other families...
  5. M

    problem comparing two rows

    hello guys i'm using a table like this one: A B C 1 value0 | value1 | value2 2 value0 | value1 | value2 . . n value0 | value1 | value2 i want to compare value1 and value2 two from rowX with value1 and value2 from rowY for examp, if they aren't alike -> delete rowX and rowY. thanks in...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top