Results 1 to 3 of 3

INDEX SMALL with conditional IF and OR

Threaded View

  1. #1
    Registered User
    Join Date
    02-20-2009
    Location
    Mineral, VA
    MS-Off Ver
    Excel 2003
    Posts
    73

    INDEX SMALL with conditional IF and OR

    I'm creating a report that pulls certain record entries from another worksheet (Activity) in the same book. Originally, it only pulled one type of activity... "SO". Now I need it to pull "SO", "CC" and "BT" type activities into the same report.

    Currently my formula looks like this and works fine for only looking for the "SO" type:
    =IF(ROW($B3)-ROW($B$3)+1>$M$1,"",INDEX(Activity!$B$1:$B$2000,SMALL(IF(Activity!E$3:E$2000="SO",ROW($A$3:$A$2000),99999),ROW($B3)-ROW($B$3)+1)))
    However, when I tried adding OR conditions to include the "CC" and "BT" types...well, it didn't work.

    I'm using Excel 2003...and I need help adding in the conditional logic for the two new types to also be selected.
    Last edited by cedarhill; 02-01-2010 at 02:44 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1