Hey. I am using several drop down lists in a worksheet. Some of the drop downs show the items starting at the top of the list, others start half way through a...

I’ve used this formula successfully =SUMPRODUCT(--(I1:I18="GTB1"),--(J1:J18=0)) What I would like to do is look for “GTB1� and “LOB1� in column I I...

I have the array formula: =SUM(IF((Sheet1!$Y1:$Y5809="26")*(Sheet1!$AJ1:$AJ5809=CREDIT!$A4),1,0)) It works fine except I want it to reference the cell that...

I want a cell from one sheet to return the sum of various cells in another sheet. For Example: Sheet 1: Description Quantity Cat ...

If I use the PMT function the montly instalment does not agree using traditional maths. e.g. £10000.00 loan over 48 months @ 8% per annum. i.e £10000.00 x 8%...

I seem to be getting differing results fromt he use of Yearfrac and edate functions: Example (all dates in mm/dd/yy format): I have used the yearfrac...

Microsoft Office Excel 2003 I have two rows of data. The first are numbers 1 through 100, the second are how many occurrences of the number from the first row...

I am trying to count how many times a Sales Rep's name appears and the corresponding referral source within several worksheets on the same workbook. Always...

Thanks so much for helping me yesterday, just need a little more assistance. I used your formula in the DRYBU column =IF(B6=15.4,B6/56,(100-B5)/84.5*B5/56) in...

is there a way to force excel to use relative paths instead of the full path to the file in which the table array resides? right now, vlookup looks for a...

hi how to replace a word with another word in formula for a range of cells. Like we have a1:c10, all have a formula, say "Rita" now we want all cells keep same...

I have a date time value in a cell It appears in cell as "1/1/04 18:00 In formula bar it appears as " 1/1/2004 6:00:55 PM I need to do calcs on this in...

I'm making a large text database that prints onto 2 pages, and I need to number each row in order to make it easier to locate items on both pages. What kind of...

I am trying to use a function to auto add the filename to a cell. I went to http://www.xldynamic.com/source/xld.xlFAQ0002.html for advice and got what i was...

I am just wondering how I can tackle a specific formula. I have a company list that is sorted by date. Is there a way that if that date has not been changed in...

I give up! How can I convert the following 1-2-3 formula for my Excel sheet: @IF(EH10""#AND#EF10""#AND#EH10-EF10.0001,1,"") I'm thinking I need...

I have a spreadsheet that was sent to me that has social security #'s in a 111-11-1111 format. I need to make it a 111111111 format. I just just wondering...

Hi, I'm trying to use the formula =SUM(N(FREQUENCY(RANGE,RANGE)0)) to count unique numbers which in the past has worked great, but now I'm using a worksheet...

I have placed the date in one cell, but I need to enter the day of the week automatically in another cell. Got a formula?

Hi, I am trying to use a wildcard function (*) in a sumif function, eg SUMIF(B:B,A1*,C:C) but excel converts the A1* to "A1*" rather that the content of cell...