Thanks patel45, it works well but I also have to need erased cell value in that matrix.

any reason why you won´t use the worksheetfunction Large for that? OK, Large that won´t delete the Max but for using the function there´s no need to delete the max.

Place this formula into A1 on the results sheet and adjust the name of the data sheet as well as the range
Yes, you're right about that HaHoBe, it is easier to find and sort the values with a formula. However, I have a complex algorithm actually and this is the first step of my algorithm. Because of this reason, I can not use a formula to reach what I wanted. Thanks anyway

You can examine http://www.excelforum.com/excel-prog...algorithm.html