Re: $$Excel-Macros$$ Like pivot table function

Use the following formula. =SUMIF($A$3:$A$322,$F$3:$F$16,$C$3:$C$322) On Fri, Aug 12, 2011 at 4:49 PM, naresh v wrote: > I Have mentioned my problem clearlyplease find attached sheet > > > Regards, > Naresh V > > -- > > ---

$$Excel-Macros$$ conditional formatting based on calculation

Pdt Jan Feb March April May June July A 0.52 0.60 0.60 0.71 0.71 0.66 0.00 B 0.72 0.72 0.71 0.86 0.96 0.81 0.77 C 3.84 4.35 4.39 3.88 4.23 4.06 3.69 D 1.16 1.49 1.49 1.49 1.67 1.92 0.00 E 1.13 1.32 1.32 1.57 1.57 1.44 0.00 F 1.14 1.29 1.29 1.29 3.12 3.18 0.00 I can to apply conditional formatting

Re: $$Excel-Macros$$ Need Formula

Hi this is very good one..can u pls let me know how this formula works if don't know how any duplicate values are there in the series... Thanks Jagadeesh On Mon, Aug 1, 2011 at 5:13 PM, NOORAIN ANSARI wrote: > Dear Jocky, > > Please use below formula...it wll be useful in case of duplicacy.. >

Re: $$Excel-Macros$$ Match and index formula help required

Ashish Koul Thank you soo much for the help... On Wed, Feb 16, 2011 at 8:31 PM, ashish koul wrote: > check the attachment > > On Wed, Feb 16, 2011 at 6:19 PM, Jagadeesh B S wrote: > >> Hello all >> >> >> >> I have date like >&

Re: $$Excel-Macros$$ Intercompany company reconciliation report

Ashish Koul Its not working...:( Regards Jagadeesh B S On Fri, Feb 4, 2011 at 12:15 PM, ashish koul wrote: > HI > > try this see if it helps > > paste unique names and email ids on sheet 3 > > > > On Thu, Feb 3, 2011 at 2:50 PM, Jagadeesh B S wrote: > >>

Re: $$Excel-Macros$$ Intercompany company reconciliation report

as attachment also > > r u using outlook or notes > > On Thu, Feb 3, 2011 at 12:16 PM, Jagadeesh B S wrote: > >> Hello friends. >> >> Can any one help me on this? >> >> Thanks in advance >> Jagadeesh B S >> >> On Wed, Feb

Re: $$Excel-Macros$$ Intercompany company reconciliation report

Hello friends. Can any one help me on this? Thanks in advance Jagadeesh B S On Wed, Feb 2, 2011 at 5:30 PM, Jagadeesh B S wrote: > Hello friends I am looking for solution for our intercompany company > reconciliation report. > > > > I have data as per the sheet *dat

$$Excel-Macros$$ Intercompany company reconciliation report

the regard. Looking forward for some help. Thanks Jagadeesh B S -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

Re: $$Excel-Macros$$ Our NEW Microsoft MVP - Dilip Kumar Pandey

Congratulations Dlip.:) Thanks Jagadeesh B S On Mon, Jan 3, 2011 at 3:31 PM, Ayush wrote: > Dear Group, > > I am very very very very happy to share a good news with you. One of our > dearest group member "Dilip Kumar Pandey" is awarded Microsoft MVP award on

Re: $$Excel-Macros$$ Fwd: Help required for formule

Ashish Koul Could you please help me in understanding the formula and how did it...Pls help to learn writing complex formulas. Thanks in advance Jagadeesh B S On Tue, Nov 30, 2010 at 1:07 PM, ashish koul wrote: > Check the attachment see if it helps > > > On Tue, Nov 30, 2010

Re: $$Excel-Macros$$ Fwd: Help required for formule

helping others. * On Tue, Nov 30, 2010 at 12:18 PM, amrahs k wrote: > Hope this helps. Have a look at the attached workbook. > > On Tue, Nov 30, 2010 at 11:35 AM, Jagadeesh B S wrote: > >> >> Hello Friends >> >> I need a formula or macro( preferabley for

$$Excel-Macros$$ Fwd: Help required for formule

Hello Friends I need a formula or macro( preferabley formule) need to prepare this report . I need a formula which should get the details for the account # mentioned in the column A with the reference to the currency,form the sheet DATA, if the currency is USD It should pull the value in the colu

Re: $$Excel-Macros$$ Guidance needed for intercompany reco...stmt..

Hello all, Could someone please help me for my requirement Thanks in advance Jagadeesh B S On Fri, Nov 26, 2010 at 12:44 PM, Jagadeesh B S wrote: > Hello all > > I need to prepare the reconciliation report for my company and send it to > all the person who is responsible f

$$Excel-Macros$$ Guidance needed for intercompany reco...stmt..

to populate the values and a macro to integrate Excel and mailbox so that I can send it to all the people with the data highlighted in the box above. Please guide me to write the formulas for myself. Thanks for looking into it and helping me. Thanks in advance Jagadeesh B S 9963025705

Re: $$Excel-Macros$$ Help required for formule

Hi all I see there is some proble with the data only.which needs some changes to be done. Thank you so much for the help. Thanks Jagadeesh B S On Thu, Nov 18, 2010 at 7:56 PM, Ajay Varshney wrote: > Problem is with the data on the Data tab. > > > Almost all accounts have more

$$Excel-Macros$$ Help required for formule

Hello Friends I need a formula or macro( preferabley formule) need to prepare this report . I need a formula which should get the details for the account # mentioned in the column A with the reference to the currency,form the sheet DATA, if the currency is USD It should pull the value in the colu

$$Excel-Macros$$ Intercompany reconciliation

you Jagadeesh B S -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid

Re: $$Excel-Macros$$ Lookup Problem

Hi Kalyan pls use Pivot table u can see like the date below. Count of BP Name - Report Depot Name BP Name - Report Total Ahmedabad H K Sales Agency - Sanand 1 Parshwa Traders - Gandhinagar 1 Soham Agency - Chikhli 1 Ahmedabad Total 3 Ambala Chaman Traders - Ambala 1 Happy Traders

Re: $$Excel-Macros$$

hi all If i want to pull the dates also in the seond sheet how to pull that dates pls help. Actually i want to pul the data right side of the vlookup data. Pls help On Wed, May 5, 2010 at 1:41 PM, Aindril De wrote: > Hi Dheeraj, > > You have done half of the work...You have sorted the data a