On Sun, 22 Nov 2009 21:28:04 -0800, Marc
wrote:

Ron, thanks for your post. Thanks to others for trying to help me as well. My
file has a lot more columns - I took the unnecessary ones out. I guess Ron's
solution works well!

I'm glad to hear that my solution is working for you. Thanks for the feedback.


My next question: i guess i cannot do something like this in a google
spreadsheet!

Probably be more appropriate to address that question to a NG that deals with
google spreadsheet. I can't answer that.
--ron