Forum Discussion
Solved
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? ...
HansVogelaar Thanks !
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,"")
HansVogelaar Thanks !