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------------- ...
downloaded your file, looking good but I am still getting #REF! error, could not attach my Excel file to this reply, please guide OliverScheurich
In the screenshot below i've highlighted where you can attach either a file or a screenshot.
- attaching screenshot will not help resolve the issue, please can I not attach the excel file to understand. However, I am attaching link to the file which is residing on my OneDrive.
https://1drv.ms/x/s!Avclfms7aCtXjF0EPX0f_ZClrECh?e=6UTmT3=INDEX(Z1412:Z1761,LARGE(IF((D1412:D1761=M1769)*(Z1412:Z1761<>""),ROW(1412:1761)-1411),2))Does this return the expected result?
Thank you very much it is working fine. Can you please suggest a formula for last value based on criteria with if condition based on another column, which works on google sheet as you may know Google Sheet does not accept formula with Filter & Aggregate commands