$$Excel-Macros$$ Re: Vlookup and If formula

2009-09-17 Thread Jitu
Great thought sir, I will definitely follow your advice. Thanks Jitheesh Janardhan --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and

$$Excel-Macros$$ Re: Vlookup and If formula

2009-09-16 Thread Jitu
Hi prashant, Thankyou for your suggestion. I think next time, I have to use pivot tables rather than a formula. I'm just at a beginner and recreating such complex formulas like harmeetji's would be tough for me. Thankyou guys- --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: Vlookup and If formula

2009-09-16 Thread Jitu
Hi Harmeet Sir, Thankyou so much for all your efforts. Chocolate kya sirji, your deserve a cake for this--- Thanks --~--~-~--~~~---~--~~ -- Some important links for excel users: 1

$$Excel-Macros$$ Nested Formula

2009-09-12 Thread Jitu
Please let me know how can i send the excel file or where can i upload it --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free

$$Excel-Macros$$ Nested Formula

2009-09-12 Thread Jitu
I want these data in the format provided in sheets 510,511 and 512 and in the given format. I have been using autofilter option,by filtering period column and wages column and creating new sheets, then using vlookup formula to pull the data into my reports there any formula wherein I can pull the

$$Excel-Macros$$ copy data without copy hide data

2009-06-20 Thread jitu
Hi friends, i am posting here first time my views. if you want to copy the cloumn A and C then first u hide the cloumn B with key CTRL+0 then u select the cloumn A and C then press ALT+ ; and you copy the data and paste only cloumn A and C Tks & Rgds Jituji Bombay --~--~-~--~~-