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
Bookmarks