Please see work sheet attached to understand what I am trying to do. Not really sure if this can be done. Have not seen anything so far in my reading that allows it.
Thanx,
Richard
Please see work sheet attached to understand what I am trying to do. Not really sure if this can be done. Have not seen anything so far in my reading that allows it.
Thanx,
Richard
Last edited by RVT; 11-07-2013 at 02:29 AM.
D1 and copy down,
=SUMPRODUCT((C1>C$1:C$10)/(COUNTIF(C$1:C$10, C$1:C$10 & "")))+1
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks