Hi, Right now I have two sheets, sheet 1 has a list of dates in column A (each date only listed once). Sheet 2 has individual purchases, with the dates in...

I have a series of variable values in one column. I also have a fixed value in one cell. I want to multiply all of the variable values by the fixed value....

I am using Excel 2007 and have tried using conditional formatting to format a cell's number format based on a condition in an adjacent cell but its not working...

I am using this formula: =IF(B3=C16,C16,"")*AND(IF(C3=D16,D16,""))*AND(IF(D3=E16,E16,"")) but am getting a value error What I am trying to do is if B3 = 2007...

How would I put the following logic into a formula? In Cell A16: IF there is text in B3 and C3 then concatonate the text values from c16&d16.

I am wanting to auto fill cells on the 2nd sheet of a spreadsheet with the information typed into the first sheet. The problem is, I need every 12th cell in...

I have a spreadsheet with multiple column. For example : Satus Id Delivered 12 Not delivered ...

i want to prevent users from adding new or blank worksheets on a form, but i cannot get the code below to work: Private Sub Workbook_NewSheet(ByVal Sh As...

I received a spreadsheet from an associate. When I print the spreadsheet it just prints one page even though the sheet is 6 pages. Now if I manually select...

I've been looking for a while for the average/mean symbol which is an "X" with a line over. To find it I went Insert/Symbols/ various Subsets such as...

what formula do i used to sum a list of text only if they are different. Example: Tell me how many stores are in this list = Target, Kroger, Target, Meijer,...

Based on threads on this site and others it appears the older versions of Excel would not support pivot table refreshes. Does anyone know if the new version...

I want to set a formula to count the number of items a column has. The cells in the column contain number though....Any thoughts??? Please help me

Hi everyone. In column B I have a list of numbers. Each number varies in length, but no number is longer than 6 cbaracters. I need a formula that will make...

I am using Excel 2007 and have a long spreadsheet that goes from Column A to Column IP. Firstly, when I try to put in a formula to add cells along the way to...

Example of what I am working with =IF('Scorecard Final Query Table'!$A$2="AEAL",'Scorecard Final Query Table'!B52,"") I want this formula to leave the cell...

I am doing a timesheet that shows a start time and and end time. I know how to make the result show up as a decimal, but I would like to be able to not have...

I'm trying to find a function & formula that will add all the Volume Total for specific day of the week in the Date column. For instance, I want add the sum...

Mostly using Excel 2002: what is the deal with disappearing comments in a shared workbook? How to prevent? Any patches? or has that problem been fixed in...

I have set up a formula, in Excel 2003, for days past due. So the formula is calculated based on numbers from columns and then I figured out part of what I...