I used the following formula to create a timehseet. I work from 8:30 to 4:30 with an hour paid lunch from 11:30 to 12:30. This formula only gives me 7...

What version did Excel start highlighting the column letter and row number of the active cell? Is there a way to extend that highlighting into the sheet to...

I have 5 worksheets that I put data in. I would like to once a month to be able to merge this information and have a combined worksheets. I have read the...

Hi I have an excel sheet set up with text boxes that wil wrap if the text gets very long , however when I go to print this spreadsheet the text gets cut...

How can I get this formula to return a Rounded Down to an Whole Number? =IF(($I14-$A14)0,IMABS($I14-$A14)*0.8,"") Thanks

When I enter a customers name I would like their address, phone, etc. to auto-fill. How would I go about doing this?

Hi All, In one cell I want to display today's date which is easy =NOW() then format with date & time. In another cell I want to type in a future date &...

I am trying to create an excel file with 100 worksheets in it. These 100 worksheets will be having the prices of individual stocks in different years. After...

I have å spreadsheet with the following count function: =COUNTIF(V7:V197;"Closed") =COUNTIF(V7:V196;"Open") This gives me the sum of cells containing...

Hi everyone, hope someone out there can help me with this one, a bit long! I'm a fairly new user and using Excell 2007. Outside the main body of my worksheet...

=SUMPRODUCT((Data!E$1:E$2514=Lists!A13)*(Data!E$1:E$2514Lists!B13)*(Data!K$1:K$2514="Other")) I'd like to have this same number returned, but I'd like it to...

I have been working with pivot tables for some time now. When I use to create them, excel would open up a new worksheet and dump the pivot onto the blank...

I have numbers in one column (Position Control Numner) of sheet A(1000 rows), I want in another sheet (Sheet B) the unique numbers from the column (Position...

I have a column that has a list of site names. I need some sort of a function that'll search through the column and hide each row that contains the value of...

Hi all, Not sure if I'm not finding the function I want elsewhere, or trying to over-complicate the situation, but this is what I need: I have an...

how to change cell chart that's protected -- Kelley

When I filter a list the bottom left corner says 143 of 515 records (or something along those lines). That is great. However, sometimes it does not give me...

I have a database built in Excel (about 3000 rows and 25 columns). The database grows in rows daily. One of the columns (say D), lists street addresses,...

Here is the formula that I'm...

Forgive me for posting twice, I just saw this section Can someone help me here. Imagine this A B C D E ...