SOLVED

New Contributor

# Repeat data based on other rows

I am trying to find a function which will repeat a specific function so that I can display only the relevant cells in a spreadsheet when applying a filter function.

 company Repeats repeat? per aa as 3 yes per aa as 3 per aa as 3 kolbu as 2 kolbu as 2 skreia as 3 yes skreia as 3 skreia as 3 jci invest 1

This is what the list looks like before applying the function

This is what the list should look like after applying the function

 company Repeats repeat? per aa as 3 yes per aa as 3 yes per aa as 3 yes kolbu as 2 kolbu as 2 skreia as 3 yes skreia as 3 yes skreia as 3 yes jci invest 1
2 Replies

# Re: Repeat data based on other rows

Let's say your data are in columns A to C, with the headers in row 1.

Select column C.

Press Ctrl+G or F5 to display the Go To dialog.

Click Special...

Select Blanks, then click OK.

Note which cell is the active cell - in your example it would be C3.

Enter the following formula, then confirm it with Ctrl+Enter to populate the entire selection.

=IF(A3=A2,C2,"")

best response confirmed by Tove_L (New Contributor)
Solution

# Re: Repeat data based on other rows

@Hans Vogelaar Thanks !