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? |
| 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 |
HansVogelaar Thanks !
2 Replies
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 !
