SUMPRODUCT will work with all numeric values but there are many columns in my
report which have text values. Is there a way to fetch those records using a
macro or a non-array formula.
_________________________________________________________________________________________________
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know we don't know. But
there are also unknown unknowns. There are things we don't know we don't know."
________________________________
From: Naveen <[EMAIL PROTECTED]>
To: excel-macros@googlegroups.com
Cc: [EMAIL PROTECTED]
Sent: Wednesday, 3 December, 2008 1:28:42 PM
Subject: $$Excel-Macros$$ Re: Using VBA Macro as an Alternate to Conditional
Array Formula
Hi,
Find the attached file, it could be solved..........
Regards
Naveen Kumar M N
Transport Supervisor(HP)
91-08-99728 10886
Email :[EMAIL PROTECTED]
Best Wishes-Karunaada Kuvara
--- On Tue, 12/2/08, Alokeshwar Tiwary <[EMAIL PROTECTED]> wrote:
From: Alokeshwar Tiwary <[EMAIL PROTECTED]>
Subject: $$Excel-Macros$$ Using VBA Macro as an Alternate to Conditional Array
Formula
To: excel-macros@googlegroups.com
Date: Tuesday, December 2, 2008, 6:16 PM
Dear All,
Please see attached workbook and advice.
Thanks in anticipation,
________________________________
Did you know? You can CHAT without downloading messenger. Click here
Add more friends to your messenger and enjoy! Go to
http://messenger.yahoo.com/invite/
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
