Repeat data based on other rows

[Tove_L]

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]

@Tove_L 

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,"")

[#3 · Accepted solution]

@Hans Vogelaar Thanks !