+ Reply to Thread
Results 1 to 2 of 2

Finding Missing Data

  1. #1
    Jordan
    Guest

    Finding Missing Data

    I have a large list of information. One of the columns is a list of
    customers. In this list a customer will be isted multiple times, with
    different information listed in the other columns. One of the other columns
    is a date. For each customer I need to know that I have recieved data in one
    of the rows for each month. Is there anyway to look through a list using on
    columns as being "unique" in this case the customer and for each of the
    unique listings making sure we have each month listed?

    What happens is we get paid per month for each customer and we want to audit
    the list to make sure we are getting paid for each month. We can do it
    manually but it is very time consuming.

    Any help will be greatly appreciated.

    Cindy.

  2. #2
    Forum Contributor
    Join Date
    08-08-2006
    Posts
    203
    Im not sure I understand the problem completely, but from what I think it is, I would select all the columns, then DATA, SORT by the date column.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1