excel database subsets based on medians

mikedata

New Member
Joined
Sep 6, 2006
Messages
1
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
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

venkat1926

Well-known Member
Joined
Aug 21, 2005
Messages
4,824
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
 

Forum statistics

Threads
1,137,300
Messages
5,680,701
Members
419,928
Latest member
dolincasting

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top