topic Re: How do I copy and paste a value based on another column condition in Discussions

How do I copy and paste a value based on another column condition

VD — Fri, 09 Jun 2023 17:04:22 GMT

hi,

I want to copy the first row string and paste to all row of the net name column if they have the same group as the group 1 on the sample below

thanks,

jthi — Fri, 15 Jul 2022 06:02:18 GMT

Is this the table you want?

There are many ways of doing this, one would be to use formula. Here is one example formula:

:"net name"n[Col Min(Row(), :group)]

It uses Col Min to get first row for each group, and then uses that found row to get value from net name column.

VD — Fri, 15 Jul 2022 15:05:21 GMT

Great! It works. Thanks for a quick help.