I tried it and for some reason cannot make it work.....

Let's not waste time. The expression should have worked (I tested it before
posting). So, probably data inconsistency somewhere. Upload your sample file
using a free filehost, then post a link to it here. Use this free, easy to
use filehost to upload:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload, then paste it
here in reply. Desensitize your sample as appropriate.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,000 Files:359 Subscribers:56
xdemechanik
---
"Joseph" wrote in message
...
I tried it and for some reason cannot make it work.....

These are the headings that I currently use in Worksheet1:
Columns--
A- Month (JAN,FEB,MAR,etc)
B- Date (mm/dd/yyyy)
C- Model
D- Cust Name
E- Type
F- Amount paid
G- Product A purchased (aftermarket products)
H- Product B purchased (Extended warranty)
I- Product C purchased (protection package)
J- Category

I appreciate any ideas you can provide me with,,,,

Thank you