0I need to combine the following to make a working formula for a large spreadsheet.
I only want to pull data where Column E = "STU" and Column B is EITHER "FTIC" or "TRANS".
('FA 08-20-10'!B:B="FTIC")
('FA 08-20-10'!B:B="TRANS")
('FA 08-20-10'!E:E="STU")
It needs to be incorporated into the following formula:
=INDEX('FA 08-20-10'!$M$2:INDEX('FA 08-20-10'!$M:$M,LastRow),MODE(IF(ISNUMBER(MATCH('FA 08-20-10'!$M$2:INDEX('FA 08-20-10'!$M:$M,LastRow),'FA 08-20-10'!$M$2:INDEX('FA 08-20-10'!$M:$M,LastRow),0)),MATCH('FA 08-20-10'!$M$2:INDEX('FA 08-20-10'!$M:$M,LastRow),'FA 08-20-10'!$M$2:INDEX('FA 08-20-10'!$M:$M,LastRow),0))))
I would GREATLY appreciate if someone can help me solve this! Thanks!