Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
advanced search
i am trying to make a search on excel that will show a certain amount of
cells with a minimum value. instead of going row by row and select the cells that have at least the amount i am looking for, can i use a function that will help me do it faster and more efficiently? i wouldn't mind search row by row but considering how big my spreadsheet is, it will take me hours to find what i'm looking for. can anyone help me? Your help will be appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
advanced search
Are you looking for something like the "Small" Function that returns
the Nth smallest number? =Small(A1:A10,2) Second Smallest number in A1 to A10 Die_Another_Day izzo wrote: i am trying to make a search on excel that will show a certain amount of cells with a minimum value. instead of going row by row and select the cells that have at least the amount i am looking for, can i use a function that will help me do it faster and more efficiently? i wouldn't mind search row by row but considering how big my spreadsheet is, it will take me hours to find what i'm looking for. can anyone help me? Your help will be appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
advanced search
no actually what i'm looking for is to find in a specific column (of about
5000 rows) all the cells that contain the minimum value of 2000 for example "Die_Another_Day" wrote: Are you looking for something like the "Small" Function that returns the Nth smallest number? =Small(A1:A10,2) Second Smallest number in A1 to A10 Die_Another_Day izzo wrote: i am trying to make a search on excel that will show a certain amount of cells with a minimum value. instead of going row by row and select the cells that have at least the amount i am looking for, can i use a function that will help me do it faster and more efficiently? i wouldn't mind search row by row but considering how big my spreadsheet is, it will take me hours to find what i'm looking for. can anyone help me? Your help will be appreciated. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
advanced search
How about AutoFilter?
Selection.AutoFilter Selection.AutoFilter Field:=ColumnNumerHere, Criteria1:="2000" Die_Another_Day izzo wrote: no actually what i'm looking for is to find in a specific column (of about 5000 rows) all the cells that contain the minimum value of 2000 for example "Die_Another_Day" wrote: Are you looking for something like the "Small" Function that returns the Nth smallest number? =Small(A1:A10,2) Second Smallest number in A1 to A10 Die_Another_Day izzo wrote: i am trying to make a search on excel that will show a certain amount of cells with a minimum value. instead of going row by row and select the cells that have at least the amount i am looking for, can i use a function that will help me do it faster and more efficiently? i wouldn't mind search row by row but considering how big my spreadsheet is, it will take me hours to find what i'm looking for. can anyone help me? Your help will be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search /Filter vertical Numeric pattern (down single column) | Excel Worksheet Functions | |||
How do i build a search table in excel | Excel Worksheet Functions | |||
build a search tool in excel | Excel Discussion (Misc queries) | |||
Using advanced filter to search for criteria in a list | Excel Discussion (Misc queries) | |||
FAQ Spreadsheet with search function | Excel Discussion (Misc queries) |