Steinmeyer25
New Member
- Joined
- Jul 4, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- MacOS
Hi all,
I am having some problems making up a formula that extracts the last value (text) of a row.
It would be for row 33 in the screenshot. Right now the value in G33 should show, but the cells after G33 all contain formulas resulting in a blank cell.
By filling in the form, H33, I33,... and so on also show a value. The formula should than change to the last real value of the row.
Right know every formula i used counted the "empty" cells too, containing a formula.
Thank you all in avance,
Kind regards
I am having some problems making up a formula that extracts the last value (text) of a row.
It would be for row 33 in the screenshot. Right now the value in G33 should show, but the cells after G33 all contain formulas resulting in a blank cell.
By filling in the form, H33, I33,... and so on also show a value. The formula should than change to the last real value of the row.
Right know every formula i used counted the "empty" cells too, containing a formula.
Thank you all in avance,
Kind regards
Attachments
Last edited by a moderator: