Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Help

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Prob 1:
    I am getting a spreadsheet daily and by day 5 I have to make sure that all data from day 1 has been completed and no longer shows on the daily report.
    Prob 2:
    on a spreadsheet i have the date,address and device number. I only want one record of the device number. I have tried the unique values option but im still getting double ups because of the dates.
    Your help would be much appreciated

  2. #2
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-23 19:07, uns,nz wrote:
    Prob 1:
    I am getting a spreadsheet daily and by day 5 I have to make sure that all data from day 1 has been completed and no longer shows on the daily report.
    Prob 2:
    on a spreadsheet i have the date,address and device number. I only want one record of the device number. I have tried the unique values option but im still getting double ups because of the dates.
    Your help would be much appreciated
    Q1: Please be more specific. I cannot understand your request.

    Q2: Advanced Filter should have worked for you. Another option is to sort your data on the device number column and then delete the duplicates.

    Here is a macro which should do the job, assuming dates in A, address in B, device number in C

    '---begin VBA---
    Sub test()
    Dim lastrow As Long, x As Long

    Application.ScreenUpdating = False
    With ActiveSheet
    .UsedRange
    lastrow = .Cells.SpecialCells(xlCellTypeLastCell).Row
    .Range("C1").Sort Key1:=Range("C1"), Order1:=xlAscending, Header:=xlYes
    For x = lastrow - 1 To 2 Step -1
    If .Cells(x, 3) = .Cells(x + 1, 3) Then .Rows(x + 1).Delete
    Next x
    End With
    End Sub
    '---end VBA---

    Bye,
    Jay

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •