Solved

Excel Fill Down Function

  • 19 February 2020
  • 2 replies
  • 18 views

Badge

Hello Friends,

I need an urgent help. Can anyone please help?

I am having something like this:

and i want to fill down the values something like this in excel:

its like a fill down option for sample id and ID till the time it finds a new sample line in text_line data or till the time it finds a blank value in its own column and stop when next row has a value.

Also attaching the excel file for your reference.

Thanks

icon

Best answer by ebygomm 19 February 2020, 09:13

View original

2 replies

Userlevel 1
Badge +21

Yes, you can do this in an Attribute Creator using adjacent feature attribute handling and a conditional formula. So this looks at whether Sample ID has a value and if it does then the value remains as is, otherwise it is set to the Sample ID of the previous feature

Badge

Yes, you can do this in an Attribute Creator using adjacent feature attribute handling and a conditional formula. So this looks at whether Sample ID has a value and if it does then the value remains as is, otherwise it is set to the Sample ID of the previous feature

You are a life saver!! Thanks a ton

Reply