Repeat Extracted Data In Advanced Filter

[Excel777]

Hi,
i wann get the extracted data repeated for every criteria like here

Data Criteria Results

<table border="0" cellpadding="0" cellspacing="0" width="480"><tbody><tr style="height:15.0pt" height="20"><td class="xl66" style="height:15.0pt" height="20">Number</td> <td class="xl66" style="border-left:none">Rfer To</td> <td>
</td> <td align="left">Number</td> <td>
</td> <td class="xl66">Number</td> <td class="xl66" style="border-left:none">Rfer To</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt;border-top:none" height="20">1</td> <td class="xl66" style="border-top:none;border-left:none">A</td> <td>
</td> <td class="xl65">1</td> <td>
</td> <td class="xl66" style="border-top:none">1</td> <td class="xl66" style="border-top:none;border-left:none">A</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt;border-top:none" height="20">1</td> <td class="xl66" style="border-top:none;border-left:none">B</td> <td>
</td> <td class="xl65">1</td> <td>
</td> <td class="xl66" style="border-top:none">1</td> <td class="xl66" style="border-top:none;border-left:none">B</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt;border-top:none" height="20">1</td> <td class="xl66" style="border-top:none;border-left:none">C</td> <td colspan="3" style="mso-ignore:colspan">
</td> <td class="xl66" style="border-top:none">1</td> <td class="xl66" style="border-top:none;border-left:none">C</td> </tr> <tr style="height:15.0pt" height="20"> <td colspan="5" style="height:15.0pt;mso-ignore:colspan" height="20">
</td> <td class="xl66" style="border-top:none">1</td> <td class="xl66" style="border-top:none;border-left:none">A</td> </tr> <tr style="height:15.0pt" height="20"> <td colspan="5" style="height:15.0pt;mso-ignore:colspan" height="20">
</td> <td class="xl66" style="border-top:none">1</td> <td class="xl66" style="border-top:none;border-left:none">B</td> </tr> <tr style="height:15.0pt" height="20"> <td colspan="5" style="height:15.0pt;mso-ignore:colspan" height="20">
</td> <td class="xl66" style="border-top:none">1</td> <td class="xl66" style="border-top:none;border-left:none">C</td></tr></tbody></table>


Thanks & Regards

 

[Excel777]

where excel experts

 

[Excel777]

any answer

 

[MickG]

Hi, You probably have not got a reply because it is not clear what your criteria is !!
Do you mean if the Total of the "1" 's in the "Numbers" column is 2 then you want the basic set of data repeated twice, or something else, please Explain further.
Regard Mick

 

[Excel777]

yes , this is what i mean

example if i have criteria as number "1" i would have results like that

Data Criteria Results

<table border="0" cellpadding="0" cellspacing="0" width="480"><tbody><tr style="height:15.0pt" height="20"><td class="xl66" style="height:15.0pt" height="20">Number</td> <td class="xl66" style="border-left:none">Rfer To</td> <td>
</td> <td align="left">Number</td> <td>
</td> <td class="xl66">Number</td> <td class="xl66" style="border-left:none">Rfer To</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt;border-top:none" height="20">1</td> <td class="xl66" style="border-top:none;border-left:none">A</td> <td>
</td> <td class="xl65">1</td> <td>
</td> <td class="xl66" style="border-top:none">1</td> <td class="xl66" style="border-top:none;border-left:none">A</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt;border-top:none" height="20">1</td> <td class="xl66" style="border-top:none;border-left:none">B</td> <td>
</td> <td class="xl65">
</td> <td>
</td> <td class="xl66" style="border-top:none">1</td> <td class="xl66" style="border-top:none;border-left:none">B</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt;border-top:none" height="20">1</td> <td class="xl66" style="border-top:none;border-left:none">C</td> <td colspan="3" style="mso-ignore:colspan">
</td> <td class="xl66" style="border-top:none">1</td> <td class="xl66" style="border-top:none;border-left:none">C</td> </tr> <tr style="height:15.0pt" height="20"> <td colspan="5" style="height:15.0pt;mso-ignore:colspan" height="20">
</td> <td class="xl66" style="border-top:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td colspan="5" style="height:15.0pt;mso-ignore:colspan" height="20">
</td> <td class="xl66" style="border-top:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td colspan="5" style="height:15.0pt;mso-ignore:colspan" height="20">
</td> <td class="xl66" style="border-top:none">
</td> <td class="xl66" style="border-top:none;border-left:none">
</td></tr></tbody></table>and if i have criteria as number "1" twice i would have results like that

Data Criteria Results

<table border="0" cellpadding="0" cellspacing="0" width="480"><tbody><tr style="height:15.0pt" height="20"><td class="xl66" style="height:15.0pt" height="20">Number</td> <td class="xl66" style="border-left:none">Rfer To</td> <td>
</td> <td align="left">Number</td> <td>
</td> <td class="xl66">Number</td> <td class="xl66" style="border-left:none">Rfer To</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt;border-top:none" height="20">1</td> <td class="xl66" style="border-top:none;border-left:none">A</td> <td>
</td> <td class="xl65">1</td> <td>
</td> <td class="xl66" style="border-top:none">1</td> <td class="xl66" style="border-top:none;border-left:none">A</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt;border-top:none" height="20">1</td> <td class="xl66" style="border-top:none;border-left:none">B</td> <td>
</td> <td class="xl65">1</td> <td>
</td> <td class="xl66" style="border-top:none">1</td> <td class="xl66" style="border-top:none;border-left:none">B</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt;border-top:none" height="20">1</td> <td class="xl66" style="border-top:none;border-left:none">C</td> <td colspan="3" style="mso-ignore:colspan">
</td> <td class="xl66" style="border-top:none">1</td> <td class="xl66" style="border-top:none;border-left:none">C</td> </tr> <tr style="height:15.0pt" height="20"> <td colspan="5" style="height:15.0pt;mso-ignore:colspan" height="20">
</td> <td class="xl66" style="border-top:none">1</td> <td class="xl66" style="border-top:none;border-left:none">A</td> </tr> <tr style="height:15.0pt" height="20"> <td colspan="5" style="height:15.0pt;mso-ignore:colspan" height="20">
</td> <td class="xl66" style="border-top:none">1</td> <td class="xl66" style="border-top:none;border-left:none">B</td> </tr> <tr style="height:15.0pt" height="20"> <td colspan="5" style="height:15.0pt;mso-ignore:colspan" height="20">
</td> <td class="xl66" style="border-top:none">1</td> <td class="xl66" style="border-top:none;border-left:none">C</td></tr></tbody></table>wish it clear now

 

[Peter_SSs]

One thing you didn't state is whether you are looking for a formula approach of a macro. Here is a possible formula approach using a couple of helper cells. See if it suits your purpose.

Formulas in D2 and E2 are copied down.

Excel Workbook
	A	B	C	D	E	F	G	H
1	Number	Rfer To	Number	Number	Rfer To		3	6
2	1	A	1	1	A
3	1	B	1	1	B
4	1	C		1	C
5				1	A
6				1	B
7				1	C
8
Repeat Data

 

[Excel777]

yes Mr peter I'm looking for formula not a macro
you are smart, Million of thanks