Please Help! Data consolidation and sorting ...

[Bospatrollie]

Hi All,

I will try and make this as understandable as possible using only explanations ... unfortunately the spreadsheet consists of secure data and I cannot even consider attaching it for assistance.

I have A spreadsheet.
The spreadsheet contains 8 worksheets, of which I am only concerned with 7 as the 8th merely presents a graph.
The first 6 worksheets all contain raw data exported from BMC Remedy indicating the names of users who logged incidents to have their passwords reset or their AD Accounts unlocked over a 6 month period, hence 6 worksheets (per month basis).
The 7th worksheet contains raw data from another application known as FIM (A MS based interface which allows users to reset their own passwords) indicating all users who are registered to utilize this functionality.

The goal of my exercise is to consolidate the data and sort it to such an extent where I can ascertain which users phoned the service desk to log an incident for a password reset, even though they are registered to do it themselves via FIM ... I have been going through the list manually and it took me 10 solid hours to go through 265 ... ... ... ... I have 3'900 to go through!

Thanks in advance for all assistance.

[akhileshgs]

I dont think that, anyone can assist you without looking at a sample file..

Create a model of the file with junk characters and upload.
I always do that only