$$Excel-Macros$$ find or extract unique values in a column excel

Hi i want to find unique values form sheet 2 on sheet 1 anyone knws the formula. Thanks, --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Vi

$$Excel-Macros$$ Re: Help plz

Hi Prashant, Please find the attached Excel sheet. Hope this would solve your query. Thanks, Sreevijay 2009/9/12 Prashant Bhawar > > Hello Frnds I want some solution > > I want to separate First Name, Middle Name & Last Name > > means if I hav Full name in A1 then i want First name in B1,

$$Excel-Macros$$ Re: Lookup Query

Hi Gyanesh, Attached query has been solved using two options. Select which you like. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/8/09, gyanesh jain wrote: > > > Hi friends, > > I have some Q

$$Excel-Macros$$ Re: Calculate Latest Value

Hi Mahesh, Attached query has been solved using different formula(s). Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/11/09, mahesh parab wrote: > > Dear All > > in attach sheet i want to find la

$$Excel-Macros$$ Classic Excel 2003 Style Menu in Excel 2007 (Free Download)

"You will have a classic mode, right?" - Bill Gates to Jensen Harris, after seeing the Office 2007 ribbon Bill Gates was smart enough to see that Office 2007 needed a classic mode. But somehow, the Office development team convinced him that a classic mode wouldn't fit with the future direction of

$$Excel-Macros$$ Excel VBA to colorize cell based on another cell

I have approximatedly 34 different desired color combinations I would like to colorize certain cells based on selected value. I.e., in English, it would be something like: Black=0 :White=2:Red=3 :Green=4 Blue=5 :Yellow=6 :Magenta=7 :Cyan=8 Get value of AK40, call it "Supply"

Fwd: $$Excel-Macros$$ Excel to MDB... Auto analysis

Hi excel gurus.. can someone help me on below problem.. -- Forwarded message -- From: pradeep palande Date: Sat, Sep 12, 2009 at 4:37 PM Subject: $$Excel-Macros$$ Excel to MDB... Auto analysis To: excel-macros@googlegroups.com Hi All Excel Gurus, Help required in below. I

$$Excel-Macros$$ Re: Help plz

Hi Prashant, Refer to the attached file. I have given two set of nested formulas to achieve the required results. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/12/09, Prashant Bhawar wrote: > >

$$Excel-Macros$$ Help plz

Hello Frnds I want some solution I want to separate First Name, Middle Name & Last Name means if I hav Full name in A1 then i want First name in B1, Middle Name in C2 & Last name in C3 -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ Re: Nested Formula

Hi Jitu, You can use DSUM or SUMPRODUCT to solve your query. For better illustration, you should attache the sample test file. It is very simple to attach the file, just send an email to "excel-macros@googlegroups.com" and attach the file. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),B

$$Excel-Macros$$ Re: Pls Help- Div by Zero error

Hi Anup, It is happenning because you are dividing some thing (any number) with Zero. To avoid this, you should use ISERROR function. =If(iserror(your divison formula),"",your divison formula) For better understanding, attach your spreadsheet. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons

$$Excel-Macros$$ Re: find & replace Suffix / cell

Hi Manoj, Attached workbook has been solved with explanation. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/11/09, Manoj Kukrej wrote: > > hi, > > > > Pls find the attached sheet > > I want t

$$Excel-Macros$$ Re: Help on formula

Hi Dhananjay, It's perfectly ok, and you are always welcome to seek support. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 9/12/09, Dhananjay Pinjan wrote: > > Hello Dilip, > Sorry for your inco

$$Excel-Macros$$ Pls Help- Div by Zero error

While calculating the IRR this error occurs. Could anyone help   Anup Now, send attachments up to 25MB with Yahoo! India Mail. Learn how. http://in.overview.mail.yahoo.com/photos --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ Excel to MDB... Auto analysis

Hi All Excel Gurus, Help required in below. I have few excel spreadsheets which contains the share rates. (Daywise share rate for all the shares) What I want is... Macro which will copy all the data from all the spreadsheets to mdb (MS access) file. Lateron would like to have a macro which wi

$$Excel-Macros$$ Re: Nested Formula

Please reply to this email with the attachment On Sat, Sep 12, 2009 at 4:07 PM, Jitu <7jit...@gmail.com> wrote: > > Please let me know how can i send the excel file or where can i upload > it > > > > --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Nested Formula

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

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$$ Re: Urgent....Excel 2007 file recovery

I will try to solve this problem sorry i m late i m not a regular user thats why i cann't rply soon bye have a nice day --~--~-~--~~~---~--~~ -- Some important links for excel users: 1.

$$Excel-Macros$$ Re: Urgent....Excel 2007 file recovery

Dear this file have opened in my system and office version 2003 if u want to open 2007 version plese try open as 2003 in 2007 version ok my no. +919466848388 Sandeep Mathur --~--~-~--~~~---~--~~