Hey guys. I have a question regarding the SEARCH function. I am trying to parse through data in an excel spreadsheet in order to look for certain characters....

Hi, I think this should be easy but I've had a long day...... I've got two columns A) Subject and B) Score. Within column A there are multiple subjects and...

I have a spreadsheet that contains peoples names and birthdates as follows: John 3/17/75 Jane 5/1/55 etc. I would like to do two things. First, I would like...

All, Let's assume I have a bunch of dates in column A. For Example: A 1 10/02/03 2 11/15/04 3 12/31/04 4 01/04/03 5

Dear Sir, I want to use sumif function inside sumproduct function Pls help me out

Hi! I've got a huge excel file with inventory items in one column, and quantities in the next column. I need to be able to do two things: 1) Be able to find a...

Is there a problem with using dates in IF statements? I'm trying to ask Excel to record 0 if the date is 9/9/99, and if it's not 9/9/99 put in the content of...

In excel I am using a spreadsheet, putting figures in ie Sub Total- VAT-Total, how do I set it up to automatically insert the VAT, after I have entered the...

I am currently using a formula array, kindly provided by Paul Sheppard, as follows:- {=SUM((Sheet1!$B$2:$B$9=Sheet2!A2)*(Sheet1!$C$2:$C$9""))} This array...

I am doing a count of information in rows. I want to show certain information in these rows, but don't want to count it in the total. What can I do?

Is there a way to save a routing slip that will prompt the user of the excel template to select the appropriate e-mail recipients on each use? I have an excel...

Hello I have tried below, and it works superb - but not all of the data i want to sumarise is on the same line on each sheet. so i want to do something like...

I have data that is imported into Excel and for some reason, not all the numbers are in one column but in three. I have been manually moving the numbers from...

I need to format a cell to show hours and minutes. For example 1'30". How do I do...

I'm not sure if I am using the correct function? I have several spreadsheets in the same workbook. Within each worksheet are columns for date 'MMM-YY' and...

Can you create an if statement for me? If a4=75,001 fee=2.00 if a4=75,001 but 125001 fee=1.75 if a4=125001 but250001 fee=1.50 if a4=250001 but1000001...

In my spreedsheet I figure plant hours but the problem I have say my hours are 7:30 hours. For other calculations I need 7 1/2 hours to read as 7.5. Is there a...

hi, how do I create new functions in Excell? a simple example is I'd like a MEAN() function that does the same as the AVERAGE() function. I'd like it available...

Hi Folks - I am comfortable using the VLOOKUP function. Here's my problem: I have a 15 row column of TEXT in SHEET1 that looks...