ExcelBanter - Formula to select top 3 from 4 totals in excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula to select top 3 from 4 totals in excel (https://www.excelbanter.com/excel-discussion-misc-queries/29544-formula-select-top-3-4-totals-excel.html)

roadsafetycouncil

Formula to select top 3 from 4 totals in excel

Need ideas how to select the top 3 from 4 items of data in a simple
spreadsheet. Cannot remember formula myself as I have not needed to do so for
some time. Bound to be some "IF" statements.

N Harkawat

Take a look at the function LARGE in help

"roadsafetycouncil" wrote in
message ...
Need ideas how to select the top 3 from 4 items of data in a simple
spreadsheet. Cannot remember formula myself as I have not needed to do so
for
some time. Bound to be some "IF" statements.

All times are GMT +1. The time now is 10:44 PM.