| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula (or code) return the largest number of duplicates in a list.
On Tuesday, December 9, 2014 7:28:37 AM UTC-8, Claus Busch wrote:
Hi again, Am Tue, 9 Dec 2014 16:26:31 +0100 schrieb Claus Busch: the code is faster if you delete the formula column if you write Appliation.ScreenUpdating = false the code will also a little bit faster. I did both of those suggestions and the time is about half. Good stuff and many thanks. Howard |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I select the largest number in a list... | Excel Discussion (Misc queries) | |||
| Search multiple sheets and return largest number found | Excel Worksheet Functions | |||
| return largest number of a list of numbers in the same cell | Excel Worksheet Functions | |||
| Finding the 3rd largest number in a list | Excel Worksheet Functions | |||
| finding the second largest number in a list | Excel Discussion (Misc queries) | |||
Hybrid Mode
