excel database subsets based on medians

[mikedata]

I am new to excel and have a hard question for you.

I have an NFL database of 1520 games. It is on 1521 rows with tons of columns. Row 1 are descriptors. Column E is the game spread and column N is the pre-game lined total (how many points the 2 teams should score.)

I want to create a "virtual" subset of my main database. This subset is to be based on various medians I enter regarding the pre-game line (column E) and total (column N).

e.g., I want a subset with a median pre-game total of 44 (column N) and a median pre-game spread of home team -7 (column E). I know how to write for median of a column, e.g., =median(c2:c1524). But I need something much more sophisticated. I want to create a "virtual worksheet" with the aforementioned subset so I can perform addn tests such as determining a likely 1st half line and total.

I don't know if excel can do this or if add-in software is required.

I would appreciate any assistance or referral.

TYVM,

Mike

 

[venkat1926]

I didi not understand completely. will any member of the set in any column equal to the median. sometimes no member may be equal to median. e.g. as in the case of average, the average number of children in a community is 2.5 but no family will have 2.5 children.

I guess auto filer will help you. see the help.

venkat