Functions

Data Validation drop-down width, with named range source (XL03 and
I have a data validation cell (List) that uses a named range as the source. The named range is: GraphLocList=Sheet2!$B$1:$J$1 The list is mostly 3-letter acronyms, with the longest entry being a 9-letter name. I have confirmed that the cells do not contain any extra blank characters, just the strings that are ... 23 Mar 2010 21:46

Calculate Number of Days worked in Each Month by Project
I want to calculate the number of days worked on a project in a rolling 4 month calendar. Working Days are Mon-Thu. My sheet looks like this: Jobname TotalDays StartDate EndDate DaysMo1 DaysMo2 DaysMo3 DaysMo4 Foo 3 3-22-10 3-25-10 3 0 0 0 Goo ... 24 Mar 2010 15:53

Matching two sets of data?
Hi, I have two sets of data, one in A1:A450 and the other in D1:D700. I want the matching data (reference) of the array in column A to appear in Column C or next to the matched value of column D. Example: A B C D 23 14 12 52 37 89 45 23 23 Thanks in advance for your help. ... 23 Mar 2010 22:56

VLookup with Search for in String
I need to look for this value within a cell i.e. A1XT-4-0713-01-00021-1.PDF within Folder:Folder:Folder:Folder:FolderPath:A1XT-4-0713-01-00021-1.PDF then return that row's third column's value. ... 25 Mar 2010 13:50

Calculating Resolution Rates
I'm trying to calculate resolution rates from our help ticketing system in Excel - I've tried several recommendations from here and they're not counting total hours (if the range is more than 1 day, it's not adding the additional 24 hours). My Dates are formatted like this: Column A: 2/4/10 9:25 Column B: ... 23 Mar 2010 19:31

Indirect and Sheet Name
I have a formula =COUNTA(INDIRECT(A3)) which returns the count of items in a range which is defined in cell A3, the formula in A3 is below. Is there a way of not having to include the sheet name (Sheet 1) in cell A3 and to include in the COUNTA formula. ="'Sheet 1'"&"!C"&A1&":"&"C"&B1 Thanks, Rob ... 24 Mar 2010 17:03

"AND FUNCTION" RETURNS FALSE WHEN CRITERIA IS TRUELY MET. HEL
I tried that but still a NO-GO. See link for a screen shot. https://emerson.sendthisfile.com/GvndbnUZAtYGVN1QSDhpQeoc Thank you, BB "Paul C" wrote: The issue is how you expressed your dates Try =AND(A2>=DATE(2009,10,1),A2<=DATE(2009,10,24)) As written Excel does not recognize 10/1/2009 a... 23 Mar 2010 19:31

"AND FUNCTION" RETURNS FALSE WHEN CRITERIA IS TRUELY MET. HELP!!!
I have a problem using AND function on date data. In cell A2, I have date date "10/1/2009". In cell A3, I have AND fuction as =AND(A2>=10/1/2009, A2<=10/24/2009). This should return a TRUE but instead returns FALSE. Why? Thank you, BB ... 23 Mar 2010 17:12

Nesting Lookup Functions
Is it possible to nest an HLOOKUP in a VLOOKUP equation? Here's what I have: =VLOOKUP(C27,A2:B5,(HLOOKUP(D27+1,INDIRECT(A2),21) Each VLOOKUP lookup value is the start of a range that I would like to be the first row of an HLOOKUP range. I might be going about this the wrong way, so if you have suggestions, I... 25 Mar 2010 13:50

Data Validation List from a Dynamic Named Range on Another Workshe
I hope this helps. I'm not following the formulas. I haven't used them with that syntax. Here is what I use to name a range that will vary in length. =Offset('SheetName'!$A$1,1,0,CountA('SheetName'!$A:$A)-1) It needs to be used in a column where that is filled with data right to the end of the data fields. ... 23 Mar 2010 17:12