| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding a number based on a criteria
y brain is still on vacation....
If somebody could be kind to help out with this little issue I have with a formula. What formula do I use If I want to have a retun value that is the year in which the last row number (7) is greater that 130 000kr ? I want to have the result in an other sheet than this table is done. I've tried IF and Hlookup formulas but in vain. A B C D 1 Year 1 Year 2 Year 3 Year 4 2 3 7 106 890 kr 7 249 027 kr 7 394 008 kr 7 541 888 kr 4 6 316 330 kr 6 442 656 kr 6 571 509 kr 6 702 940 kr 5 350 000 kr 344 732 kr 339 201 kr 333 393 kr 6 350 000 kr 350 000 kr 350 000 kr 350 000 kr 7 90 560 kr 111 639 kr 133 298 kr 155 556 kr Greatful for any kind of help! Thanks /Henrik |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the last entry in a column based on criteria | Excel Worksheet Functions | |||
| Return number OR sum based on two criteria | Excel Worksheet Functions | |||
| Finding cell contents based on certain criteria | Excel Discussion (Misc queries) | |||
| Finding cell contents based on certain criteria | Excel Discussion (Misc queries) | |||
| Finding the Largest Number, based on two criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
