Re: $$Excel-Macros$$ Re: Help with Budget - Formula

Hello Ashish Sorry for not replying earlier. This is exactly what I need. Thanks a lot for the quick solution. Thanks Ashish On 5/18/2011 8:42 PM, ashish koul wrote: cell ( b3) =B2-SUMIF(C6:C65356,B1,D6:D65356) cell(c3)=C2-SUMIF(C6:C65356,C1,D6:D65356) On Wed, May 18, 2011 at 2:00 PM,

RE: $$Excel-Macros$$ Re: Help with Budget - Formula

See if it helps... Regards,    Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Pradhan Sent: Wednesday, May 18, 2011 2:00 PM To: excel-macros@googlegroups.com Subject:

RE: $$Excel-Macros$$ Help on Transpose Function based upon criteria

Check this one it will help you http://en.kioskea.net/forum/affich-132961-vlookup-find-value-3-4-5-etc Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KAUSHIK SAVLA Sent: Wednesday,

Re: $$Excel-Macros$$ Re: Help with Budget - Formula

Hello Thanks a lot for the good work Anil Thanks Ashish On 5/19/2011 11:12 AM, Anil Bhange wrote: See if it helps... Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On

$$Excel-Macros$$ Re: Macro for Converting txt to xls using Text Import Wizard

I can guess how you want it formatted, but is it possible for you to attach a sample excel sheet with the desired tabs/columns how you want it? On May 18, 3:31 pm, Susan 1 sunni...@gmail.com wrote: Hi ~ Wondering if you could assist me with the Text import wizard to configure the columns and

Re: $$Excel-Macros$$ Formula required

Hi Vikram, Find the sheet enclosed Regards Umesh Dev On Mon, May 16, 2011 at 11:07 PM, vikram vikramahuj...@gmail.com wrote: Hi, Please help regarding formula for validation: If we enter any numeric value in particular column it does not allow a duplicate entry and shows error

Re: $$Excel-Macros$$ MinMaxAverage : Using Sumproduct

Hi, Thanks for the reply. Can we do this without using array function. Regards, Chandra Shekar B On Thu, May 19, 2011 at 11:16 AM, Anil Bhange anil.bha...@tatacommunications.com wrote: HI Chandra, See if it helps… Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123

$$Excel-Macros$$ Rank value contingent on 1+ other criteria

I am trying to rank values in column D contingent on value in column A B. I also would like like values in column D to have the same rank. Example data is attached below. Column E shows the order in which I would like the sample to rank. What formula can I use? column AB