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

try this INDEX($B$1:$W$1,0,MATCH("Collected",B2:W2,0)) On Tue, Dec 14, 2010 at 11:28 AM, lucky singh 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 attachment... > > >

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

No attachment found. On Fri, Dec 10, 2010 at 3:16 PM, lucky singh wrote: > > Hi All, > > kindly help me to get the collaction date with the help of an formula... > > please refer the attachment... > > > Regards, > Lucky > > -- > > -

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

Hi All, kindly help me to get the collaction date with the help of an formula... please refer the attachment... Regards, Lucky -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks an