Fill Down, IF...

[StrobelJones]

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.

[Akshay1]

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