| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with getting numbers in some range values!?
Wigi wrote:
Hi Ivica If you setup a simple table, the VLOOKUP function will do it. First column of the table has all the cutoff values. The second one has the corresponding range of values. HTH Hello Wigi. Sorry, i tryed to do it now, but with no success. Could you somehow help me with more detail? example, in column A i have this numbers: 1,2100 1,2100 2,0000 1,4900 2,6400 1,5600 1,3500 1,8300 1,7600 2,3500 5,7400 1,9800 2,3300 5,9400 1,6500 so what formula/procedure should i do if i want to do this few ranges: 1,03-1,15 1,15-1,30 1,30-1,40 1,40-1,50 tnx in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding numbers in a specific range of values | Excel Discussion (Misc queries) | |||
| two columns range of numbers need to list all numbers in the range | New Users to Excel | |||
| can numbers be assigned to values, replacing values for numbers | Excel Discussion (Misc queries) | |||
| Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
| Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
Threaded Mode
