I have data with three or more columns with 30 rows. I want to update col3 and row 22 which is max of values in col 3 at row 13 & 18. Also i want to update col1 row 10 with same value as in col 2 at row 25. Can anyone help on this ? Tried using multirow formula but it gives me error that variable not found.
@Happylife2025 how you got any data you can share so we can test on what you see
@Happylife2025 Yes please share the data so we can be more helpful - even better would be the workflow with the data so we can further help troubleshoot.
Bacon