I think all did the job manually.... I used Excel, and a little VBA to fetch the records to excel, and then the formula len() to check for the longest username
haha, that's what I wanted to ask earlier, did you do it manually or use something did anyone else did not do manually?
I did. I Used my brain and didnt bother checking for the answer :p lolzz ps - how did u use Excel and VBA? btw?
this should explain you how did I did it 1] got the url with name sorted datewise 2] record a macro 3] new web query 4] used the url from step 1 5] selected the table only with the user details 6] this gave me 100 records in 1 step 7] modified the macro to get the info for all the records that could fit on one sheet 8] used len(), and sort desc 9] confirmed back the result from the forum letting out my secrets :lol:
@Mj: Check the attached file. I used the similar one to find the longest username Don't you know about macros?
i know about macros but never used them...my laptops gone bad, getting no display, when i get it back i'll check it as these days im using comp at cyber cafes