PDA

View Full Version : Check and Transpose



Porkypig
05-13-2007, 01:49 AM
I have the raw data that consists of AccountNo, Type, Date, whether send by Auto or Manual.. see sheet1.

I need to manipulate it and present it like Sheet2.

1. I need a list of distinct account no
2. I need to loop through the Type and determine whether is it generated auto or manual and place the date under the matching type for each account no.
3. If same account no has the same type and done by the same mode of handling but different date, only captured the latest. Eg. 4th Apr and 20th Apr? the report only capture 20th Apr.

Thanks in advance for any help. :help

Porkypig
05-13-2007, 01:56 AM
Sorry ...forget to attached the spreassheets. :dunno