But i doubt the someone will do it as i asked becasue i specified no
pivot tabel no nothing but only excel database formula...so...i'll be
glad to credit the person who achieves that.

Hmmm...

The formula I suggested DOES just that.

I *HATE* Pivot Tables so I use these types of formulas every day. They're
really very simple once you understand how they work and you've written them
by the thousands!

Here's something to consider, however. If you're in school chances are
pretty good that your instructor knows your capabilities. So, if you turn in
an assignment that contains work that is above your capability, the
instructor will know.

Good luck!

Biff

"skarbanan" wrote
in message ...

if the person who helps me out with a piece of his coding wants to be
crediti i will be happy to do it, i don't see the problem.
But i doubt the someone will do it as i asked becasue i specified no
pivot tabel no nothing but only excel database formula...so...i'll be
glad to credit the person who achieves that.


--
skarbanan
------------------------------------------------------------------------
skarbanan's Profile:
http://www.excelforum.com/member.php...o&userid=29901
View this thread: http://www.excelforum.com/showthread...hreadid=496084