Trying to get a Frequency Table Undone!

[Stephen_IV]

What I am trying to do is to get a frequency table undone. Can someone please help me. Thanks in advance.

Book2
	A	B	C	D	E	F
1	x	f
2	1	2				1
3	2	1				1
4	3	4				2
5	4	10				3
6	5	2				3
7	6	2				3
8	7	2				3
9	8	2				4
10	9	2				4
11	10	2				4
12						4
13						4
14						4
15						4
16						4
17						4
18						4
19						5
20						5
21						6
22						6
23						7
24						7
25						8
26						8
27						9
28						9
29						10
30						10
Sheet1

 

[shg]

Undone?

You're trying to create the list in col F via formula, or something else?

 

[Stephen_IV]

Sorry for not being clear. Yes a list in Column F.

 

[shg]

In F2 and copy down,

=MATCH(ROWS(F$2:F2)-1, SUBTOTAL(9, OFFSET(B$1, 0, 0, {1,2,3,4,5,6,7,8,9,10})))

 

[Stephen_IV]

Thanks shg4421, It worked great! How can I update that formula to work on the senario below? Thanks you again!

Looking for the same output but in column N.

Book2
	A	B	C	D	E	F	G	H	I	J	K
1	x	1	2	3	4	5	6	7	8	9	10
2	f	2	1	4	10	2	2	2	2	2	2
Sheet2

 

[shg]

Where does the output go?

If it starts in B4,

=MATCH(ROWS(B$4:B4)-1, SUBTOTAL(9, OFFSET(A$2, 0, 0, 1, {1,2,3,4,5,6,7,8,9,10})))