LinkBack URL
About LinkBacks
Dear all,
Please find attachment.
In Last two columns Can i use any formula that can give me last occurence Month & Quantity.
Regards
Vinay
Dear all,
Please find attachment.
In Last two columns Can i use any formula that can give me last occurence Month & Quantity.
Regards
Vinay
Hi,
Try these, and copy down.
N3=INDEX($B$2:$M$2,MATCH(0,$B3:$M3,-1))
O3=INDEX($B3:$M3,MATCH(0,$B3:$M3,-1))
Last edited by sweep; 01-19-2009 at 09:22 AM.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
N3: Lookup(9.99999999999999e+307,$b3:$m3,$b$2:$m$2)
o3: Lookup(9.99999999999999e+307,$b3:$m3)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
or n3
=INDEX($B$2:$M$11,1,MATCH(10^6,B3:M3,1))
and o3
=INDEX($B$2:$M$11,ROW()-1,MATCH(10^6,B3:M3,1))
Martin, for N3 you need not INDEX anything other than B2:M2 and for O3 you need not INDEX anything other than current row Bx:Mx (row = 1)... I'd only make one other point that there's little to be gained from using a number less than BigNum (IMO) -- it just adds risk.
Dear Sweep,
Thank you. it's working prefect!
Regards
Vinay
donkyote! its just quicker to put whole range rather than row,a quick drag puts it all in. then if later you want to add something it's there.as for big number hey ho if you are using more than 10^6 then you probably are a rocket scientist and dont need help. also its easier to remember than anything else.
humbly yours
rocky-aunty
Last edited by martindwilson; 01-19-2009 at 08:53 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks