![]() |
#1
|
|||
|
|||
![]()
Hi,
I am using an excel file with the following format - Chapter| Start Page|# Of Page|"Status (N/R/D)" 1 | 1 |6 |N 2 | 7 |20 |N 3 | 27 |20 |R 4 | 47 |16 |D - I used the pipe sign (|) to separate the columns here. Anyway, I want to use an excel function that will work on two columns - "# Of Page" and "Status (N/R/D)". The function is required to do the following - 1. Filter the "# of Page" column to select those chapters only with no of pages between 10 and 15. 2. Filter the "Status (N/R/D)" column to show only those rows with "N" as status. 3 & Overall. I need the count of those rows matching the condition 1 &2. My question is - Is it possible to use any combination of excel function to do this operation. I do not want to use any excel macro but am trying to limit myself to an excel function. |
Tags |
excel 2013 formula |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
If Statement for Outlook VBA: Time & User defined columns | Son | Outlook | 0 | 10-02-2015 11:02 AM |
CountiF or CountiFs two columns conditions | Oceans | Excel | 11 | 05-02-2014 06:32 AM |
![]() |
teza2k06 | Excel | 3 | 02-13-2014 12:37 PM |
Countif | hockeytown | Excel | 3 | 01-05-2013 08:06 AM |
![]() |
ibrahimaa | Excel | 3 | 05-23-2011 11:23 AM |