Workbook containing two sheets Sheet1 = trips Some cells in ColumnB is blank (0) ColumnA ColumnB Mon, Jan 08, 2007 Mon, Jan 08, 2007 ...

recently lost "redo-undo' feature. How do I reinstall this function? Thank you.

I need to show only the whole number, not the number resulting by removing the decimals. We do not want to force all of these cells. So, if the number is...

Hello, I need to show the average of a column (cells M8 to m5000) As this column is populated by a formula =(L8/H8)*100 And in turn this is populated by the...

hi! sorry..the data in my earlier post was wrong and the correct one is as follows: i'm having some id in colA & numbers (may be "+" or "-") in colB as...

Hi. I started read this group recently. I have one stupid question :) Why reply is almost always above message with question instead of under it? Is this a...

I want to select the last entry in a column, and insert this value into a formula elsewhere. A new number is added daily to this column. There are empty...

I want to add up the values of various discontiguous cells in a worksheet e.g. A2+A7+C4+D7+G3. What is the quickest way to do this? The autosum function...

I have two columns in an excel sheet. One column shows 1 representing male and 2 represnting female. In the second column I have marks scored by males and...

I'm sure this can be done. Excel can do just about anything. Only wish I could!! My spreadsheet has dates in Col. A, which are formatted as Date. Each...

How would I extract a number (or series of numbers) using a single cell formula from an alphanumeric text string that also contains spaces? One key component...

I have a spreadsheet where Sheet A contains names (including duplicates) in a range. I'd like Sheet 2 to list the distinct names in alphabetical order. Any...

This must have been done before, but for the life of me I cannot figure out how (for a cell that contains taxable income), to compute federal income taxes from...

I am trying to work out the minutes elapsed for a call monitoring system. The hours monitored are between 05:30 and 19:00 - so if a call gets logged outside of...

I am reposting this to see if I can get another answer. I need a formula that will allow me to search a column (B1:B19989) that contains text with the data...

Hi All, I would like a flexible Formula to Return the Column Number of individual Numeric Labels and their Numeric Value. I have a 2-Row by many...

I have tjis problem that is killing me. I have this: DATE | USER | CAR ------------------ 5.1.2005 | MARK | LINCOLN 6.1.2005 | JOHN | LINCOLN 8.1.2005 | JOHN...

On Sun, 11 Dec 2005 16:06:40 -0000, "Mike H" wrote: Hello, I want a function that allows me to enter a range and then returns the...

Hello Group - I'm trying to count the number of cells that contain the word "walk". Walk Walk this way Walking in the sand To walk away Let's take a walk

I need a formula that counts if column C = Sold, and column A = Name and column S and be either New* or Under* =COUNTIFS(C:C,"sold",A:A,"name")can equal Name...