Hello, I need some help with a function in excel so pls if someone knows how I'd really appreciate the help. So here goes, I'll try to explain it the best i...

Hi all Can anybody explain the difference between these two functions? I've created a report containing the ISNA function and a colleague has said that...

I am looking for a way to cut down the amount of time it takes me to 'clean' account data. I currently get sent monthly accounts which I merge into a single...

I have a long list of names in column A, with blank cells every so often. In column B, there are list of numbers. Cake 8 Cookies 4 ...

I am trying to write if statement and havent been able to get all to work, ex: =IF(and(O18="L TO R",q18=Right hand")),"5500-402-02",IF(and(O18="R TO...

Can anybody tell me Which is the Best Site for "How to make Charts in Excel2003" Thanks in Advance

I was wandering how can I avoid the repetition of values in a certain row or column. If I have digits from 1 to 9 and have a row with 9 columns, can I put...

howdy. When I print in excel 2003 the rows and columns break into a progressive stair-step pattern seemingly climbing towards the top right corner of the...

What is the difference between an electronic spreadsheet and an ordinary spreadsheet? Please send me the detailed result

Using this formula =sumproduct(--(sheet1!A2:A3000="APPLE")*(sheet1!A2:A3000="DECEMBER") that will give me how many APPLES in DECEMBER I replaced them for "1"...

I am creating a Lead Tracking workbook for the agents that work in my real estate office. There are 5 worksheets for 5 different types of customers that we...

Hi, We use excel 2007 and if we link from one document to another the documents link fine but cell data doesn't display. This only happens when we do this...

Is there a function (or other method) that we can use to round currency to the nearest 5 cents, ie $27.28 would round up to $27.30, and $30.01 would round to...

the EULA shows up every time I open an office program and I have to accept it again to proceed. Why? I have Office 2003 and just loaded it on my new computer...

lately, when I want to use a text box, I use a rectangle instead. It seems to serve the same purpose. Is there an advantage to a text box over a rectange? If...

I can't e-mail an Excel 2007 document. I am using Vista. The option for sending as an e-mail isn't available. I put the e-mail in the Quick tool Bar, but it...

i had downloaded a file from microsoft web page in which it showed different filter on the same sheet, please can you tell me how can i do that. thanking you,

I want to have a formula that I can automatically pull cell c100 from tab 1, tab 2, etc...from file 2 and pull cell d87 from tab 1, tab 2, etc... from file...

I have a spreadsheet which references sequential entries from sheet 2 into a pre-arragned repeating row grouping in sheet 1. I have been asked to alter sheet...

I have created an excel sheet which has names and adresses. Within the datasheet, I have an alert system, which tells me when someone has paid his rent by a...