Re: $$Excel-Macros$$ Query regarding serial no.

2011-10-25 Thread Maries
HI Ankit, Find the attachment. On Tue, Oct 25, 2011 at 9:42 AM, Ankit Agrawal ankit.agrawal...@gmail.comwrote: Dear Expert, Plz solve out attached query. Regards, Ankit -- -- Some important links for

Re: $$Excel-Macros$$ Query regarding serial no.

2011-10-25 Thread NOORAIN ANSARI
Dear Ankit, Please try below formula... =LIQ/EE/INV/1112/SUMPRODUCT(--($C$5:C5=C5)) =LIQ/EE/INV/1112/COUNTIF($C$5:C5,C5) -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*

$$Excel-Macros$$ Query regarding serial no.

2011-10-24 Thread Ankit Agrawal
Dear Expert, Plz solve out attached query. Regards, Ankit -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group