Thread
:
Pulling the largest numbers
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
Posts: n/a
Pulling the largest numbers
=SUM(LARGE(A1:A10,{1;2;3;4}))
HTH
--
AP
"Melanie" a écrit dans le message de
news:
...
I have a series of data with the information in rows. For each row - I
want
to find the 4 largest numbers, and add them together in the last cell of
the
row. I am looking for the best functions to use.
Any help would be greatly appreciated
Reply With Quote