$$Excel-Macros$$ Need Help Urgently on how to Parse data

2011-04-27 Thread Mog Obahor
I have an excel file with a list of column data. first of all, after the data is sorted based on the Col D, then I need a routine to check if any row data in Col D occurs more than once. If it occurs more than once.. For example: Column D has data on Row 2 and Row 3 same but the Date on Column I

$$Excel-Macros$$ Re: Looking for most effecient way to convert lots of data

2009-10-08 Thread Mog Obahor
Hey Paul Good work on the Phone number exercise. I was wondering if you don't mind sharing the dummy *.txt file you created to test the program and also if you could send the excel spreadsheet with the VBA code where you implemented it. I will like to study the methodology or your approach. It

$$Excel-Macros$$ Re: need help in excel formula

2009-10-08 Thread Mog Obahor
Sandeep I don't quite understand your problem, could you please restate it clearly. thanks Mog On Wed, Oct 7, 2009 at 9:36 AM, Sandeep wrote: > > > - Original Message - > *From:* G. Ram > *To:* excel-macros@googlegroups.com > *Sent:* Saturday, October 03, 2009 8:20 AM > *Subject:* $$Ex

$$Excel-Macros$$ Re: PDF password CRACKER

2009-09-30 Thread Mog Obahor
send it to me vivek I will help u crack it. On 9/30/09, vivek agrawal wrote: > Hi There.. > > I have downloaded a pdf file which is PASSWORD PROTECTED. > > CAn anyone PLEASE help crack the password. IF YES, then pls tell me so that > i can mail the pdf file to the concerned person. > > I would b

$$Excel-Macros$$ if statements to compare string

2009-08-28 Thread Mog Obahor
Hello Team, I have all the variables in the cells stored in an array format and I am iterating through the entire value to detect where "Jan" is . How do I do an If Statement check for this. thanks *Project Num* *Project Title* *Project Type* *Impl Date* *Jan* *Feb* *Mar* *Apr* *May* *Jun