ukmxer
09-12-2007, 01:09 AM
Is it possible to look at col C for a result greater than 0 and if one is found then copy cells abc of that row onto another sheet. Then repeat until end of data.
Then on the other sheet sort the data using column C in to descending order.to find the highest scores.
A=mem num (integer)
B= Name (String)
C= score (integer)
Then on the other sheet sort the data using column C in to descending order.to find the highest scores.
A=mem num (integer)
B= Name (String)
C= score (integer)