Hi Kris
Kindly select start year as 2012 or 2013. You will realize that these two yrs
do not hv any data but if you select them its populates the data from 2006
onward instead of blank.
Sent from my BlackBerry® smartphone from Airtel Ghana
-----Original Message-----
From: Kris <krishnak...@gmail.com>
Date: Sat, 24 Mar 2012 00:56:33
To: <excel-macros@googlegroups.com>
Cc: Kris<krishnak...@gmail.com>; <resp...@gmail.com>
Subject: Re: $$Excel-Macros$$ Excel formula help needed
PFA
Kris
On Saturday, 24 March 2012 12:51:10 UTC+5:30, Kris wrote:
>
> It does. Set your calculation to automatic.
>
> Kris
>
> On Saturday, 24 March 2012 12:43:42 UTC+5:30, hilary lomotey wrote:
>>
>> Thanks Kris for the quick reply
>> A little bug in the formula
>> If you include the named range matchcol in the formula. The figures don't
>> update when you select another year.
>> Sent from my BlackBerry® smartphone from Airtel Ghana
>> ------------------------------
>> *From: * Kris <krishnak...@gmail.com>
>> *Date: *Fri, 23 Mar 2012 21:50:49 -0700 (PDT)
>> *To: *<excel-macros@googlegroups.com>
>> *Cc: *<resp...@gmail.com>
>> *Subject: *Re: $$Excel-Macros$$ Excel formula help needed
>>
>> Hi
>>
>> In B3 on Sheet1
>>
>> =IFERROR(MATCH('P&L
>> (2)'!$H$4,INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A4:i4"),0),2)
>>
>> Define B3 '*MatchCol'*
>> *
>> *
>> Now in B12 and copy down & across,
>>
>>
>> =IF(COLUMNS($A12:B12)<=$H$6+1,INDEX(INDIRECT("'"&INDEX(ShtName,ShtSelected)&"'!A5:i120"),ROWS(B$12:B12),MatchCol+COLUMNS($B12:B12)-1),"")
>>
>> Kris
>>
>>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
