Skip to main content
Solved

Excel Fill Down Function

  • February 19, 2020
  • 2 replies
  • 76 views

Forum|alt.badge.img

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

Best answer by ebygomm

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

View original
Did this help you find an answer to your question?

2 replies

ebygomm
Influencer
Forum|alt.badge.img+32
  • Influencer
  • Best Answer
  • February 19, 2020

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


Forum|alt.badge.img
ebygomm wrote:

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings