Re: $$Excel-Macros$$ Help for formula (which formula give me exact numbers when I change month)

2012-08-06 Thread amar takale
First Thanks very much Kantilal Sir,But I would like to which I desired output in sheet (Yellow color) Is it possible? On Mon, Aug 6, 2012 at 11:01 AM, Kantilal Badale wrote: > Hi, > > See if attached sheet is useful. > > U can Change month in value field to get the desired result > > Regards > >

Re: $$Excel-Macros$$ Help for formula (which formula give me exact numbers when I change month)

2012-08-04 Thread vijayajith VA
Hi ,, Use Ctrl Shift enter for Priti_Verma s formula... Thanks On Sat, Aug 4, 2012 at 1:17 PM, amar takale wrote: > Pls help me all experts.I attached file. > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like P

RE: $$Excel-Macros$$ Help for formula (which formula give me exact numbers when I change month)

2012-08-04 Thread Priti_Verma
Try this in C15:I15 as array =TRANSPOSE(OFFSET(INDEX($C$5:$N$5,1,MATCH(C14,$C$5:$N$5,0)),1,0,6,1)) Priti From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: 04 August 2012 1:18 To: excel-macros@googlegroups.com Subject: $$Excel-Macro