Need help in Excel

Completed Posted Apr 11, 2014 Paid on delivery
Completed Paid on delivery

In Excel sheet, there is a dynamic table (Please see the attached image). I need to find what the value is for the last “Sell” in column N. Also, I need to find what the value is for the last “Buy” in column N. For example, in the attached image, the value for the last “Sell” is (-0.8). And the value for the last “Buy” is (-0.9). I need the method to be simple and use only formula or function. No VBA and No Macro. Please note that the table can reach up to 60 rows, and sometimes only one row only, and sometimes no data (empty table).

Excel

Project ID: #5793142

About the project

3 proposals Remote project Active Apr 11, 2014

Awarded to:

zExcel

Hi, I'll be happy to help you with these formulas Please feel free to message me -----------------------------------------------------------------------------------------------------

$30 USD in 0 days
(250 Reviews)
7.6

3 freelancers are bidding on average $27 for this job

Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$30 USD in 0 days
(326 Reviews)
7.6