reverse index function?

warhorse927

New Member
Joined
May 18, 2002
Messages
30
I attend a school that is on a Cohort system i.e. A group of people go through the program together. The good thing about this is that our classes are mapped out. We know the start date of every class we will take over the next 2.5 years. The problem:
Every Cohort has classes in the same order (different start dates,for now) so I created a table of 9 columns with the Cohort names across the top row. (BBA 501, BBA 502 to BBA 508. These are the column heads. In the row right below this are the number of students in the Cohort.
In the FIRST Colum (A) are the classes (History 202, English 111, BIO 210...)
In the body of the table under each Cohort name and # of students are the start dates for each class for that cohort. These are usually unique but there are two cohorts that coincide. My problem. between two dates, I need to know which cohorts have a particular class. To put it simply, I need to evaluate the intersection of the row and column and have it return the column head.
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

warhorse927

New Member
Joined
May 18, 2002
Messages
30
No, that returns the intersection, in my case the date. I want to evaluate the date to return the column heading i.e. I have a formula that returns the number of students in a class based on a date range =SUM(IF(orientation!$B26:$AA26>Begdate1,IF(orientation!$B26:$AA26<Enddate1,abastud,0),0))entered as an array formula beside each class on a different sheet. orientation is the sheet name,abastud is the number of students range (row)to get the number from. This works but I can't modify it to get the Cohort NAME.
 

Forum statistics

Threads
1,147,510
Messages
5,741,574
Members
423,668
Latest member
Audorin

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