FILLUP

=FILLUP(range)

range
a column of values with gaps consisting of blanks, errors, or zeros to be filled in from the next value below it.

The value of a next cell is propagated to the null-valued cells below in the columns specified.

lrobbo314

Well-known Member
Joined
Jul 14, 2008
Messages
3,929
Office Version
  1. 365
Platform
  1. Windows
FILLUP fills a column with the value of a next cell is propagated to the null-valued cells below in the columns specified.

Also uses other LAMBDAs `FILLUP` and `REVTABLE` listed below.

FILLUP
KLMNOPQR
1FILLUP w/ errorFILLUP w/ zeroFILLUP w/ blank
2
3#N/A3033
4#N/A3033
5#N/A3033
6#N/A3033
7#N/A3033
8#N/A3033
9333333
10#N/A2022
11#N/A2022
12#N/A2022
13222222
14#N/A1011
15#N/A1011
16#N/A1011
17#N/A1011
18111111
19
20
21#N/AC0CC
22#N/AC0CC
23#N/AC0CC
24#N/AC0CC
25#N/AC0CC
26#N/AC0CC
27CCCCCC
28#N/AB0BB
29#N/AB0BB
30#N/AB0BB
31BBBBBB
32#N/AA0AA
33#N/AA0AA
34#N/AA0AA
35#N/AA0AA
36AAAAAA
Sheet3
Cell Formulas
RangeFormula
L3:L18,R21:R36,O21:O36,L21:L36,R3:R18,O3:O18L3=FILLUP(K3:K18)
Dynamic array formulas.


FILLUP
Excel Formula:
=LAMBDA(range,
    REVTABLE(FILLDOWN(REVTABLE(range)))
)

FILLDOWN
Excel Formula:
=LAMBDA(range,
    LET(
        r,IF((range=0)+(range="")+ISERROR(range),NA(),range),
        SCAN(0,r,LAMBDA(s,c,IF(ISERROR(c),s,c)))
    )
)

REVTABLE
Excel Formula:
=LAMBDA(table,
    LET(
        d,table,
        r,ROWS(d),
        INDEX(d,SEQUENCE(r,,r,-1),SEQUENCE(,COLUMNS(d)))
    )
)
 
Upvote 0

Forum statistics

Threads
1,216,503
Messages
6,131,022
Members
449,616
Latest member
PsychoCube

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top