Extracting Specific data from one table in order to create another table

Good evening Gentlemen,

I am attempting to extract from the table pictured below the PDS designated rows and automatically assemble them into a new table. I have tried using the filter tool but unfortunately it makes it impossible for me to apply the formulas necessary to determine Overall position, class position and points (the last three columns).





Screen Shot 2016-01-27 at 10.50.37 PM.png




This Screen shot below shows the table once the filter is applied..... but the formulas for calculating Overall position, class position and points are still using the hidden cells and are wrong.

For example Andrew Weyman's Class position should be 1st and Walter Kaye 2nd not 2nd and 6th. the formula I am using is =IF(E10=E9,J9+1,1) which works well before the table is filtered but clearly does not work now. If there is a way to do it by modifying the formula in some way so that it would only calculate based on what is visible I would be extremely grateful as this is by far the easiest way to manage the data.



Screen Shot 2016-01-27 at 10.57.30 PM.png




Failing that I attempted to use the formula described here http://www.myonlinetraininghub.com/e...s-from-a-range but it dose not seem to work as my table look like this now.... Its been a long day and I hope someone with more knowledge than I can help!!! Thank you in advance!



Screen Shot 2016-01-27 at 11.10.41 PM.png

Post a sample file in excel format rather than an image. Images are impossible to edit and nobody wants to recreate the file for you.
Attach a sample spreadsheet with expected results, remove any sensitive data.

Copy the headers of the main table over to M4:V4.
Enter this ARRAY formula in M5 and fill across to V5 and down as far as necessary to extract the PDS records. Delete the formulae in column U

Formula:

=IFERROR(INDEX(B$5:B$40,SMALL(IF($C$5:$C$40="PDS",ROW($C$5:$C$40)-MIN(ROW($C$5:$C$40))+1),ROWS($1:1))),"")

Array formulae are entered with Ctrl + Shift + Enter

In U5 enter this formula to determine the class position and fill down.

Formula:

=IF(T5="","",IF(P5<>P4,1,U4+1))

Results:

	M	N	O	P	Q	R	S	T	U	V
4	No.	PDS	TA	Class	Driver	Name	Best Lap	Overall Position	Class Position	Points
5	321	PDS	TA	BSR	Andrew	Weyman	01:28.246	11	1	15
6	273	PDS	0	BSR	Walter	Kaye	01:30.758	19	2	7
7	?	PDS	0	EX	Greg	Scilley	01:31.112	21	1	20
8	117	PDS	0	EX	Bruce	Bentel	01:34.044	27	2	12
9	28	PDS	TA	GT4	Brad	Keegan	01:18.525	1	1	20
10	??	PDS	0	MP	William	Lafitte	01:34.010	26	1	20
11	4	PDS	0	MS	Ron	Cressey	01:30.066	17	1	20
12	9	PDS	0	MS	Peter	Stravos	01:39.589	34	2	15
13	749	PDS	0	OP	Tom	Hoffman	01:26.990	8	1	20
14	127	PDS	0	U	Paul	Tordella	01:27.651	9	1	15
15	??	PDS	0	U	Jason	Hoffer	01:36.309	32	2	10
16	11	PDS	0	U	Michael	Schaible	01:39.042	33	3	8

Thank you for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.