1. N

    Copy range to another sheet when match conditions

    Hi all Hi have sheet(data) and sheet(source) like belove Sheet(data): <tbody> A B C 1 A123 999 888 2 A124 456 789 3 A125 123 456 4 A126 741 852 5 A127 987 987 </tbody> And Sheet(source): <tbody> A B C D E 1 ... ... A121 123 456 2 ... ... A122 456 789 3 ... ... A123 789 789...
  2. S

    Increment based on Adjecent Cells

    Hi All, Not been here for a while. Hope you are all ok and can help. <tbody> Column A Column B A123 A123 A124 A125 A126 A126 A126 A126 A126 </tbody> I have 2 columns as above. I want to add the incremental count of each number in column A into column B...
  3. J

    VLOOKUP and MIN functions

    Example worksheets: I'm trying to resolve for Worksheet1 B2 - B4 I want to find the earliest transaction date in Worksheet2 for each UniqueID in Worksheet1 Column A and place the date in Worksheet1 Column B. There are only unique ID numbers in A Worksheet 1 Worksheet2 is a transaction table...

Some videos you may like

This Week's Hot Topics