HI ALL, I have a Excel table having the following fields. Column A contain Dates and column B contains Product Name. I need a macro which will count the values based on Multiple criteria. I am able to accomplish the desired task using an excel formula i.e. =SUMPRODUCT((A$1:A1$0=A1)*(B$1:B1$0=B1) But i need to do this using VBA. Please let me know the desired code. I shall be very thankful to you.
Thanks in adavance. On Fri, Dec 19, 2008 at 6:37 PM, justsh...@gmail.com <justsh...@gmail.com>wrote: > > HI GUYS, > I AM FACING A LITTLE PROBLEM HERE. I HAVE AN APPLICATION THAT EXTRACTS > DATA FROM THE DATAWAREHOUSE AND EMIAL THE DATA CONTENTS TO THE END > USERS BY EXPORTING THE DATA INTO EXCEL SHEETS.The problem starts here, > there are some null values in the data and they are replaced by a 0 > (zero) at the report level and when the other application tries to get > the data from the reports, the seo stays there but the format changes > to text and the little green devil appears. No I have tried the > following things: > - writing a macro and disabling the error checking > (not good approach as the end user still cant use that column in > addition etc) > ( Also I dotn want the users to see the macro dialogue popup and they > might think I am trying to hack into their system) > - I have tried disabling the error option but that doesnt work. > - I have tried to set the format of the template file and set the > format of all the cells as NUMBER but doesnt work. > > Please help mein this regard. The problem should be fixed in a single > template file and the same file is being used by 20 reports that are > to be mailed to the business users on daily basis. I know this is a > small issue, but still, CLIENT IS A CLIENT :P > > Please help me. > Regards, > shez. > > > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
