OK, this may seem fairly simple but I'm missing something ... Is there a formula that will calculate the Second Calendar Saturday of the Month for me?

I want to enter a value in one cell that will produce a result based on values in other cells. For example: Cell B5 has a drop down list where I select the...

I have a sheet with some numbers in white and some in black. I can use the "find" function to isolate and find the white numbers and then manually add all...

Formula to enter to extract the text within ( ) in a text string Example: "My Text String (MTS)" and extract or return MTS Currently the "(XXX)" is always at...

How do I tell how many pages I have created in my spreadsheet? Where does it say how many pages there are?

Hello, The AND statement is as follows: =and(--d2--c2,--c2--b2m--b2--a2). What's the purpose of the double unary here? Thanks!

I have a column of dates that i what to do a lookup on. The column looks like the following: 01/01/08 5 02/01/08 6 03/01/08 7 I what to find...

I have the following in a spreadsheet. Everything works great except the last column, the Total . The value of cell I3 is being totally ignored. Thanks for any...

Hi all, I've been working on this and can't seem to figure it out. Here's my data set: Sept08! ID Measures 123 0 345 1

Hi I have asked a couple of questions on here and you've helped greatly, here's 1 mo I want my document able to only save on 1 page ("introduction"...

I have an instance where we are using excel to calculate work times however on some calculations an error appears. I am told that excel does not calcuate or ...

I have a spreadsheet that is a 2000 version. No matter what I do, I cannot get the dang thing to convert to a 2007 format. Any ideas?

I'm tring to create a daily log/time sheet which will have start and stop times in adjecent columns. My problem is there may, or may not, be mutiple shift...

I have to spread sheets with similar fields but one has ITEM number and the other one doesn't. I need them to match so i can have the same item number on the...

I need help with a couple of issues in the same table. -the first one is: how to convert numbers to time; right now I have a cell that gives me 0.84 and I...

What I need to do is have people enter the time they start, what time they leave for lunch, come back from lunch and leave at the end of the day. I want...

I am writing a macro to automate several processes. I have the following table where column A has positive and negative values and column B is blank. I need a...

I need to make a flexible sum in an array( not a single column or row). Say: 1. sum range: B2:Z20 2. Criteria1 range: B1:Z1 Criteria 2 range: A2 A20 Any...

I have a table where I need to Sumarize different columns. Eg: =C9+E9+G9+I9+K9+M9+O9+Q9+S9+U9+W9 but in this row E9 and M9 have no data as all these cells...

I have 2 sheets setup. Sheet 1 has name listed in column A and Sheet 2 has data as listed in the example below. I need help with extracting the latest date...