multiple critera

Good afternoon everyone, I thought I knew how to do this but seems not, I am trying to validate a cell value to see if it's in a name ranged and check if the cell above is the offset of the named ranged. here is an example of what I have: On sheet1 I have the following: Cell C6 contain a...

Hi, I am working on an index-match function. When I do it on the tab with the data it works fine, but when I do it on another tab it does not work...my formula is as follows... {=INDEX('Sheet1'!AB30:AB92,MATCH(A6&B6,'Sheet1'!C30:C92&'Sheet1'!B30:B92,0))}

I need a formula which can sum the mode of payments seperately occuring on different dates. Please see the attachme.it is like table 1 date cash crdit card 1-1-14 2-1-14 3-1-14 table 2 product booking date booking amount payment date payment amount Payment Mode...

I need a formula to count the number of unique item#'s (column B) within each category (column D). For example I need to know how many unique item #'s I have in impulse. For this example the answer would be 5 (the middle column is irrelevant data in relation to this request). I do not want...

I need help getting a formula to count how many instances happen between a certain time on a certain day. For example in column A5:A15 I have the Date of the incident and in column B5:B15 I have the Time of the incident. I want to count how many incidents happened between a certain time on...

I have a complain log sheet, i want to count values based on two columns but output should showed on different sheet in the same workbook. Please help me to create formula. Ranges: 'July 2013'!J3:J101 = "Resolved" 'July 2013'!K3:K101 = "Yes"

Hello, I was wondering if there was a way to create a macro or formula that could help me organize some invoice data. I would like it to search column A (Name) and column B (ID) and find duplicates within that range. For any A/B adjacent cell pairs with the same exact values, I'd like to have...

So I need to do a look up. The information below is from two spreadsheets. The look-up equation goes where #n/a is, below Total 87171. My result needs to to be the 2031. I tried using an index-match equation, but it doesn't work for some reason. It might have to do the fact that Total 87171...

HELLO GUYS, COMPLETE BOG STANDARD EXCEL INTERMEDIATE HERE! I HAVE AN ISSUE WITH A PROJECT IM WORKING ON, IF ANYONE HAS A SOLUTION PLEASE LET ME KNOW :) OK I HAVE A DOCUMENT WITH MANY SHEETS, I WOULD LIKE A SHEET TO MATCH TWO CRITERIA OF ITS OWN CONTENT, AGAINST ANOTHER SHEET THAT CONTAINS...

Hi there, I'm pretty new to this forum but have been using it to help me find answers to excel forumlas for a while. I'm hoping someone on the forum can help. I have a huge list of survey responses which asks people to identify their location and then rate how important 6 facilities in their...

anyone have an idea how to convert a match statement to vba with multiple conditions? I have situations from where it has to match two criteria, to matching six criteria. Any thoughts on how to do this? =IF(AND(ISNUMBER(MATCH(1,($K$2:$K$393=Y2)*($O$2:$O$393=$D$1),0))...

Hello, I am stumped. I have a spreadsheet with three date columns. I want to create a tally that will count each row only once if any of the three columns contains a date greater than 7/1/2011. Here is my formula for tallying just one column: =COUNTIF('Deduped Lead Contact...

Here's what I'm working with (in Excel 2007): <TABLE style="WIDTH: 157pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=209><COLGROUP><COL style="WIDTH: 36pt; mso-width-source: userset; mso-width-alt: 1706" width=48><COL style="WIDTH: 53pt; mso-width-source: userset...

I need the total number of cells that meet a specific criteria. I can break down what I need into 3 parts and using COUNTIF, get the results for each part. HOwever, I need the 3 parts to become one formula. =COUNTIF(January!B:B, "OS") =COUNTIF(January!A:A,">=1") =COUNTIF(January!A:A, "<=7")...

Hi I have 2 spreadsheets relating to empoyee records etc. Sheet 1 holds all the data on every employee. Sheet 2 contains a select few employees' details. I need to calculate their attendance at management meetings Sheet 1: Employee # / Date of meeting / Attended? 12345 / 10/12/2010...

I have a report, posted below, that gives different information about students. Here is a sample. Excel WorkbookABCDEFGHIJK1Fund NameStatusActual AmtData ValidDependency StatusTfcFund Family 2Tot AidResidentcyStudent TypeHousing2PELL GRANTA3200YD2302NPC Grant12015RF13DL SUBA4500YD2302NPC...

Hi, I am making a sales trackng sheet for my company. Basically what I am doing is making a report page. We have 6 people that could enter data into the sheet via a user form. One of my columns (data validation) is set to have their name. Also one of my rows is a VBA (copy, paste special)...