SOLVED

Repeat data based on other rows

%3CLINGO-SUB%20id%3D%22lingo-sub-2006364%22%20slang%3D%22en-US%22%3ERepeat%20data%20based%20on%20other%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2006364%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20find%20a%20function%20which%20will%20repeat%20a%20specific%20function%20so%20that%20I%20can%20display%20only%20the%20relevant%20cells%20in%20a%20spreadsheet%20when%20applying%20a%20filter%20function.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%221%22%20width%3D%226%20pz%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2276px%22%20height%3D%2257px%22%3Ecompany%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2257px%22%3ERepeats%3C%2FTD%3E%3CTD%20width%3D%2259px%22%20height%3D%2257px%22%3Erepeat%3F%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2276px%22%20height%3D%2230px%22%3Eper%20aa%20as%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2259px%22%20height%3D%2230px%22%3Eyes%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2276px%22%20height%3D%2230px%22%3Eper%20aa%20as%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2259px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2276px%22%20height%3D%2230px%22%3Eper%20aa%20as%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2259px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2276px%22%20height%3D%2230px%22%3Ekolbu%20as%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2259px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2276px%22%20height%3D%2230px%22%3Ekolbu%20as%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2259px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2276px%22%20height%3D%2230px%22%3Eskreia%20as%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2259px%22%20height%3D%2230px%22%3Eyes%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2276px%22%20height%3D%2230px%22%3Eskreia%20as%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2259px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2276px%22%20height%3D%2230px%22%3E%3CP%3Eskreia%20as%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2259px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2276px%22%20height%3D%2230px%22%3Ejci%20invest%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2259px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3CSPAN%3EThis%20is%20what%20the%20list%20looks%20like%20before%20applying%20the%20function%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThis%20is%20what%20the%20list%20should%20look%20like%20after%20applying%20the%20function%3C%2FSPAN%3E%3C%2FP%3E%3CTABLE%20border%3D%221%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2276px%22%20height%3D%2257px%22%3Ecompany%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2257px%22%3ERepeats%3C%2FTD%3E%3CTD%20width%3D%2263px%22%20height%3D%2257px%22%3Erepeat%3F%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2276px%22%20height%3D%2230px%22%3Eper%20aa%20as%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2263px%22%20height%3D%2230px%22%3Eyes%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2276px%22%20height%3D%2230px%22%3Eper%20aa%20as%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2263px%22%20height%3D%2230px%22%3Eyes%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2276px%22%20height%3D%2230px%22%3Eper%20aa%20as%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2263px%22%20height%3D%2230px%22%3Eyes%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2276px%22%20height%3D%2230px%22%3Ekolbu%20as%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2263px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2276px%22%20height%3D%2230px%22%3Ekolbu%20as%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%2263px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2276px%22%20height%3D%2230px%22%3Eskreia%20as%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2263px%22%20height%3D%2230px%22%3Eyes%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2276px%22%20height%3D%2230px%22%3Eskreia%20as%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2263px%22%20height%3D%2230px%22%3Eyes%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2276px%22%20height%3D%2230px%22%3E%3CP%3Eskreia%20as%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E3%3C%2FTD%3E%3CTD%20width%3D%2263px%22%20height%3D%2230px%22%3Eyes%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2276px%22%20height%3D%2230px%22%3Ejci%20invest%3C%2FTD%3E%3CTD%20width%3D%2267px%22%20height%3D%2230px%22%3E1%3C%2FTD%3E%3CTD%20width%3D%2263px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2006364%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2006530%22%20slang%3D%22en-US%22%3ERe%3A%20Repeat%20data%20based%20on%20other%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2006530%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F908318%22%20target%3D%22_blank%22%3E%40Tove_L%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet's%20say%20your%20data%20are%20in%20columns%20A%20to%20C%2C%20with%20the%20headers%20in%20row%201.%3C%2FP%3E%0A%3CP%3ESelect%20column%20C.%3C%2FP%3E%0A%3CP%3EPress%20Ctrl%2BG%20or%20F5%20to%20display%20the%20Go%20To%20dialog.%3C%2FP%3E%0A%3CP%3EClick%20Special...%3C%2FP%3E%0A%3CP%3ESelect%20Blanks%2C%20then%20click%20OK.%3C%2FP%3E%0A%3CP%3ENote%20which%20cell%20is%20the%20active%20cell%20-%20in%20your%20example%20it%20would%20be%20C3.%3C%2FP%3E%0A%3CP%3EEnter%20the%20following%20formula%2C%20then%20confirm%20it%20with%20Ctrl%2BEnter%20to%20populate%20the%20entire%20selection.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(A3%3DA2%2CC2%2C%22%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

 

companyRepeatsrepeat?
per aa as3yes
per aa as3 
per aa as3 
kolbu as2 
kolbu as2 
skreia as3yes
skreia as3 

skreia as

3 
jci invest1 

This is what the list looks like before applying the function

 

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

companyRepeatsrepeat?
per aa as3yes
per aa as3yes
per aa as3yes
kolbu as2 
kolbu as2 
skreia as3yes
skreia as3yes

skreia as

3yes
jci invest1 
2 Replies

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

best response confirmed by Tove_L (New Contributor)
Solution

@Hans Vogelaar Thanks !