Re: $$Excel-Macros$$ counting of a particular denomination

2013-08-29 Thread Kush Shama
Dear Anil, Thanks for your prompt response. However, I also need solution for second query i.e If I wish to calculate number of pieces for each of them, how could i do that using a formula. On Fri, Aug 30, 2013 at 12:22 PM, अनिल नारायण गवली wrote: > Dear Kushlesh, > > > You can u with countifs

Re: $$Excel-Macros$$ counting of a particular denomination

2013-08-29 Thread अनिल नारायण गवली
Dear Kushlesh, You can u with countifs(criteriarange,criteria) and enter Pl find the attached sheet Warm Regards, Gawli Anil Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Fri, Aug 30, 2013 at 12:04 PM, Kush Shama wrote: > Dear Team, > > Please f

$$Excel-Macros$$ counting of a particular denomination

2013-08-29 Thread Kush Shama
Dear Team, Please find the attached Excel File. I have two queries; 1. I have certain denomination in range A3:A10. If I wish to know the number of times a denomination has appeared which formula should i use? 2. Adjacent to those denominations there are certain amount of pieces of that denominati