0

I am kinda struggling now. I need to make this formula from excel works in Google Sheet.

=INDEX($C$5:$C$24,AGGREGATE(15,3,($B$5:$B$24=$M$8)/($B$5:$B$24=$M$8)*(ROW($B$5:$B$24)-ROW($B$4)),ROWS($A$5:A5)))
  • 2
    Welcome. Please describe what your formula does and include sample input/output (expected results). – Rubén Nov 5 at 1:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.