[Solved] Get previous value for the category

[PeterV]

I'm searching the internet and Bing AI to find an answer to following question.
What is the formula to find the value of a cel in a column of the last previous row that has a corresponding value in a another column, giving the fact there's no sorting in any columns. See attachment for details. Maybe it's a trival thing, but since I can't find the solution, I will be glad someone can give an answer.

Puzzle calc openoffice.ods

(13.34 KiB) Downloaded 181 times

Edit: Changed subject, was Formula for info in previous rows in Calc  Make your post understandable by others  -- MrProgrammer, forum moderator

[MrProgrammer]

Hi, and welcome to the forum.

Bing AI

Ha! But thank you for trying. It's more than most visitors here do. We do have topics in the forum about this subject, though I appreciate they may be difficult to locate.

What is the formula to find the value of a cell in a column of the last previous row that has a corresponding value in a another column?

Formulas in yellow cells must be entered as Array formulas. Press ⇪⌘Enter (Shift+Command+Enter) on a Mac or Ctrl+Shift+Enter on other platforms; if you press Enter by mistake, use Edit → Delete Contents → Formulas, then try again. Do not attempt to drag an array formula to other cells using the Fill Handle. You can fill the formula down by double-clicking the Fill Handle, or you can use Copy and Paste. D2 is the constant 0 because that row never has a previous value.

202312241310.ods

(19.99 KiB) Downloaded 197 times

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

[Villeroy]

Open the attached database document.
Open the form therein.
When you navigate to a record having a precedent, the precedent's details are shown in the white boxes.
Works indepentently from any sort order as you can see when you sort ascedingly or descendingly by figure or date.

[PeterV]

Thank both for the quick answer.