Fill empty cells based on evaluating of value different column in rows above
Hi I have the following problem:I want to fill cells via a formula or script in Column "Parent List" absed on next n-1 value in column Level: Fill emty cell (Column „Parent List“, Row 10):•In row with emty cell go to Level column containing value „4“•Calculate n-1 („3“)•Find next row above that contains value n-1 (3), which is row No 9. Copy character (7P61G05) of Material column into emty cell (...