| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
looking up figures in a column and selecting next highest match
How do I create a function tolook at a column of figures and select
either the match or the next highest. So if I have a column called 'current' and want to create a column called 'new', the function needs to look at 'current', compare it with a list of figures and put the closest higher figure from that list into the 'new' column. Thanks Jane |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Activating "Todays Date" column upon opening? | Excel Discussion (Misc queries) | |||
| Selecting matching items in a column | Excel Discussion (Misc queries) | |||
| Selecting a column with an integer | Excel Discussion (Misc queries) | |||
| How can I sort an entire spreadsheet from a list | Excel Worksheet Functions | |||
Threaded Mode
