hi there,
u can use the subtotal function at each change in "myrate" - end result
u get a subtotal for all the coloumns. now click on all the minus sign
on the left of the sheet. now u get onlyu the sub totals. now use
cntrl+g click on special . n select visible cells now. now paste it
another sheet.. n replace the word total with null..


--
m_anoob
------------------------------------------------------------------------
m_anoob's Profile: http://www.excelforum.com/member.php...o&userid=19892
View this thread: http://www.excelforum.com/showthread...hreadid=345841