FG
💻 Software

Fill down in Excel, but based on multiple values

Fresh5 days ago
Mar 15, 202659903 views
Confidence Score0%
0%

Problem

I have spreadsheets (not created by me) that have blank entries in one column where they should really have data. I want to take every empty cell and fill it with the nearest value above it. I'm looking for as little manual intervention as possible, because I'll have to do it repeatedly. I thought …

Error Output

HAVE:            WANT:           GET:
foo     1        foo     1       foo     1
        2        foo     2       foo     2
bar     1        bar     …

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Fill down in Excel, but based on multiple values

Low Risk

Mr. Excel has the answer for pre-Ribbon versions of Excel. Below are instructions for Excel 2007. With foo/bar in column A and your data in column B: Select all of the data in column A, from top to bottom. Click on Home->Find & Select->Go To Special…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment