monthly data discrepancies

J

jmjt

I do a monthly revenue report; salespeople are paid monthly by Customer ID.
New month's data is added/imported from a text file. I do a report of new
month "customer ID's added" and "customer ID's dropped". Presently I sort by
customer ID and bill month and do this visually. Does anyone know how I can
have excel do this process .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

3 variable 2 dimensional line graph 0
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
SUMIF with NAME RANGE 1
Filter out unique additions month to month 3
can't figure out the formula 3
Averaging weekly data into Months 1
Identify data in monthly sheets in WB and consolidate into master sheet 0
Combining data from multiple rows 2

Top