Forum Discussion
Second to last value from table with condition
Hi experts Can you help me with the below? I have a list of cash values in a table, example as follows by a rotating week number (1-4). A ------------ B 1 ----------- 40 2------------- ...
Thank you very much for taking great pain. I don't have enough kind words to express gratitude. I have copied the formula and changed the row numbers due to change in data in my file. The formula suggested by you is there in cell number J1793 (filed with yellow colour) but it is returning nothing. The cell I1793 contains the last value arrived at after applying two conditions on column L & M. The latest file is attached for doing the needful.OliverScheurich
We have to enter the formulas as arrayformulas with ctrl+shift+enter if we don't work with Office 365 or Excel for the web or Excel 2021. In the Excel file the search criteria is in cell H1790. In the other file it was in a different cell therefore the formulas have to be adjusted.
- Thank you very much, I was working on Office 365 but real problems seems to be working on Google Sheet. You are right criteria also needed to be changed which I did but forgot to mention that in my post. Thank you once again for your time & great help