How to remove error notification when X7/M7=0 when one or both cell values are 0

hi, I have the below data...like this i have huge data in different sheets(which are named date wise) and i can not consolidate them in a single sheet as the...

Hi All I have data listed in rows that I want to display in columns which will then be used in another program and I can't use a pivot table. ...

I have two worksheets, I have entered the formula for a cell on the 2nd worksheet so that the cell contents are copied from a cell on the...

I need to know how to set up a function (maybe) to change the font color when I type the letter. For example, I have a field (column) contains Femal and Male...

Hi All, Thank you very much for taking the time to provide various formulas. I need to find /match the LAST time two specific numbers appeared together and...

I am a teacher and have an excel spreadsheet (2003) with student's marks in various columns. Each column represents a quiz/exam/OP or assignment and they are...

I have applied the registry patch described in http://support.microsoft.com/kb/831824/ but it does not seem to notice this if the subtotaling is done inside a...

Was this function removed from 2007 or do I just need to download an add-in?

I am trying to use sumif function to add up a range in excel using color as "CRITERIA". Is this possible? or is there another way to go about it? Thanks.

I have been having serious trouble trying to sort this out. It is a little complicated and I will score major points with my supervisor if I can sort this...

I have a large excel (Excel 97) file on an NT4 server. When I try to open the file (across the network) on my computer - XP pro with office2000 premium edition...

Hello, When I have this number, 268435457800737937, Excel gives me an error when I do the DEC2HEX formula. In an online converter, I get 3B9ACA06B551480....

I need to create a macro for unpaid rent with gray backgound red text and border and in bold style unpaid rent is listed as no in worksheet in paid colum.I...

I am working with several large excel sheets(stats, employees etc.). I am trying to tie all 4 of these sheets into 1 sheet that will pull data from the main...

I've got a daily time-tracking spreadsheet. The formula in A4 is: =(A2A1)+A2-A1+(A3B2)+A3-B2 (A1 = Start Time, A2 = Lunch Begin, B2 = Lunch End, A3 = End...

Hi I need to create a pivot table .... it could be revenue per. country. Let us assume that there are 30 countries. I only want to display top 10. I can find...

I have the following worksheet setup: Column A = Origin Column C = Destination Column E = Airline Cell A2: DTW Cell C2: IAH Cell E2: CO Cell...

I am trying to write a formula by which I could be able to handle 10 conditions in total. Please help me out as Ms Excel can not handle more than 7 nested ifs....

I have been researching and trying to figure out how to get a spreadsheet do some counting for me. I am on active duty with my National Guard unit on a...