In Microsoft Excel, what DATABASE FUNCTION used to find two (more than 1) largest or smallest number

In Microsoft Excel, what DATABASE FUNCTION used to find many largest or smallest numbers in a very HUGE column? (It means that you cannot use single function like MIN, MAX, LARGE, SMALL).

In other words, with one function, it will list many values (not only one)

In Microsoft Excel, what DATABASE FUNCTION used to find two (more than 1) largest or smallest numbers in a...?internet security 2006

Sorry Vinh, there is no single-cell function that returns multiple values into a single cell. However, check your built-in help for database functions and you will see DMAX returns a single value from a database if it is a named range.

Hope this helps,

Kind Regards,

QwertyKPH @ Yahoo

In Microsoft Excel, what DATABASE FUNCTION used to find two (more than 1) largest or smallest numbers in a...?microsoft

Excel function are working to get only one value in one cell

Means you can not return more than one value from one formula in one cell

But you can create one function in a cell, copy it to another cell and those two cells will bring two values but from one function

This is what Excel all about, and also the most of programming languages

Instead you can use DGET to do waht you want

Enjoy my profile, I am the VBAXLMan