cancel
Showing results for 
Search instead for 
Did you mean: 

Fill Down, IF...

Highlighted
Blue LED
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
Highlighted
DC Motor
Hello StrobelJones,

Are you looking for something like this?
Image: https://us.v-cdn.net/6030933/uploads/editor/v4/rtswt07hzjor.png

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,
Akshay
0 Kudos