How do I filter rows with duplicate information? I've downloaded a spreadsheet containing about 7,000 rows. Some of those rows contain duplicate data. I...

I'm trying to format my spreadsheets so that when I'm working with numbered lists, the numbers stay in sequence. If I delete or add rows or if I type a number...

Is there a Delete Function I can use to delete a row IF one cell is equal to another cell minus another cell?

I am having a problem with Excel. One column in particular is a "number" formatted like “text�. Some of the cells say they are formatted as text, but...

I have a large sheet with about 1000 rows and 9 columns. I want each blank cell to be filled with a color i specify (lets say yellow). How can I do this with...

Is there a way to set conditional formatting to respond when a cell contains the text "msg" somewhere in the body of text in that cell?

help me plz if you see one of the templates like balance sheet in excel some of the cells are deactived and users just input data in special cells. so how...

I have a worksheet ("Winners Log") which has a list of JPEG numbers in column A. I want to click on any JPEG number, have Excel find that JPEG photo in the...

What is the best way to apply conditional formatting in the following case? I have a column with validated text fields (users can select one of...

when i transfer an excel file that contains =convert formula when used on a pocket pc the formula is stripped away - why is this ? is there an add in for the...

Hello great folks who have saved me more than once: I have a data validation list (drop down list) in one cell, which offers a choice of 3 different...

Hi I need to find how to work out the total number of months where I have a list of fixed start and end dates, always beging on the first day and end on the...

Hi , I am trying to copy an entire spreadsheet from one workbook to another workbook. But it only copies the values not the formulas and if I try the paste...

When I have a large amount of data being fed into merged cells, wrapped text dissappears after roughtly 1000characters. Is there a way to change this? As...

I have a cell that contains a typical IP address in the form 123.456.789.012 (dotted decimal). I want to break each octect into a seperate cell, so that if...

When using the VLookup function, I am using "FALSE" as the argument, for the "range_lookup" argument, because I only want an exact match; however, it returns...

While doing some auditing I noticed that the IF() worksheet function behaves differently when it is entered as part of an array formula (control-shift-enter)...

Having a tough time with this one. Sheet 1 Column A = Start Date, Column B = End Date, Column C = Quantity. Sheet 2 Row A = Start Date, Row B = End Date. I...

I would like to track production start/stop times and then convert the total time to minutes instead of hours and minutes. I have been using a formula like the...

Is there any way to use Excel as a form for data entry and have the enter and/or tab key take you to the next cell for data entry when the next cell. ...