Showing results for 
Search instead for 
Did you mean: 

Fill Down, IF...

Fill Down, IF...

When using the Fill Down function, is there a way to limit it to filling ONLY when a prior record in another column is equal? For example, if a current record is blank in Column B, fill down from the prior record ONLY IF the Column A of the Current Record equals Column A of the Prior record.
Labels (1)
0 Kudos
1 Reply

Hello StrobelJones,

Are you looking for something like this?

if yes, then you would have to sort the columns by COLUMN and then do a fill down on Column(1). if this is not what you are looking for, could you please elaborate on your example?

Thank You,
0 Kudos