Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding Missing Data
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. -- iturnrocks ------------------------------------------------------------------------ iturnrocks's Profile: http://www.excelforum.com/member.php...o&userid=37246 View this thread: http://www.excelforum.com/showthread...hreadid=570166 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Missing data using the autofilter | Excel Discussion (Misc queries) | |||
Numbers/Text data missing from excel to excel query? | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
interpolate missing data between points | Excel Worksheet Functions |