Filled in Null Values - have to manually make formula to combine

13 views
Skip to first unread message

Benjamin Hill

unread,
Aug 29, 2023, 5:29:43 PM8/29/23
to User Group | Simple ML for Sheets (Public)
Very much a nice-to-have: It works great for filling in null values, so I'm using it more, and ran into the following:

After it finishes, I have to fill-down a formula to combine the actual values with the predicted values:
=IF(NOT(ISBLANK(E2)), E2, F2)

Which isn't so bad, until I'm trying to fill in blanks in 15 or so columns, at which point it gets kinda repetitive.

It would be nice to have the option of the results including a pre-filled column of "original, and if not original, then predicted" all in one place.  It could even use this formula to avoid duplication of data.
Reply all
Reply to author
Forward
0 new messages