Re: $$Excel-Macros$$ Need help to get the collection date with the help of formula

2010-12-14 Thread ashish koul
try this INDEX($B$1:$W$1,0,MATCH(Collected,B2:W2,0)) On Tue, Dec 14, 2010 at 11:28 AM, lucky singh lucky60...@gmail.com wrote: Hi All, kindly help me to get the collaction date with the help of an formula... I want to know the date of collection of each customer... please refer the

Re: $$Excel-Macros$$ Need help to get the collection date with the help of formula

2010-12-11 Thread C.G.Kumar
No attachment found. On Fri, Dec 10, 2010 at 3:16 PM, lucky singh lucky60...@gmail.com wrote: Hi All, kindly help me to get the collaction date with the help of an formula... please refer the attachment... Regards, Lucky --