| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible array formula?
ID Side Size Type Price OCA Status
2345254 Buy 1 Lmt 103.3125 OCA Open 2345255 Sell 1 Lmt 103.34375 2345256 Sell 2 Lmt 103.5 2345257 Buy 2 Stop 103.5 OCA 2345258 Sell 2 Lmt 103.5 2345259 Buy 2 Stop 103.53125 OCA Open 2345260 Buy 2 Lmt 103.53125 OCA Open 2345261 Buy 1 RS 103.53125 OCA 2345262 Sell 1 RS 103.53125 2345263 Sell 2 RS 103.53125 Open 2345264 Sell 2 RS 103.625 2345265 Buy 3 Lmt 102.625 2345266 Buy 3 Lmt 103.28125 Open Can anyone Please help? With this data table how in excel can I find the record with the lowest ID with a price of 103.53125 and a status of open? Thanks in advance Jason |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array formula SUMIF with 2D sum_range array | Excel Worksheet Functions | |||
| Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
| Find specific value in array of array formula | Excel Worksheet Functions | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| Array Formula - using LEFT("text",4) in formula | Excel Worksheet Functions | |||
![Jason[_32_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
