what am i doing wrong with my sumproduct()? A1 = 7/1/2008 (thats July 1st 2008) D1 = 13 E1 = 11 just to make calculating eazy i followed the 13 and 11 pattern...

Hello, I need help creating a macro, and can't figure out how it should be written. I want the macro to look for duplicate names in column B, add figures in...

I have been using an excel workbook to create my employees schedules. I have 8 worksheets in the workbook; one for each day of the week and the last, a...

Hi all, here is the layout of my spreadsheet: a3=apple a4=orange a5=pear b2=red c2=green

Hi, I tried to explain the problem in the subject like but i know i failed miserably. Anyway, here is the problem. so if a person's average daily sale is...

I need to find the MAX of a column of numbers that contain in them with out putting the less than in a separate colum. Example: 2 0.1 8 7 3

Here is an update to my question posted last week: I have a spreadsheet with close to 700 lines of information on it. The current format of the spreadsheet...

I have to deduct between two dates. From 31-10-2008, I have to deduct 1-11-1969. It may be seen that the difference is 39 years. But in excel it shows 39...

Cell A1 content is "=B2". I want to reference A1 and get the contents of B2.

Hi Everyone , I am thinking a way to set up a template for other to use. Could anyone give some comment or suggestion to help me to calculate the cost?...

Folks, I ran into an odd behavior when trying to use an indirect reference to a range used as an argument in a statistical function. A: 1: Data 2: ...

I recently started using Comcast phone. When I download lists of calls, the numbers are of the form minutes:seconds I'd like to add up those numbers. Short...

Here is what I have: A B C D 12345 X 9 a 98765 R 3 t 98765 X 4 b 56489 ...

I have a spreadsheet that i want to hide columns a:H if the value in cell L1="N" and unhide if theres a "Y". i'd prefer for the "macro" to be real-time...

Hi, I have a table of 3 types of information - Column A - Query type Column B - Resolver Name Coulmn C - Resolution date I would like to count the number of...

hi. I need help writing a macro that will hide and unhide rows based on the value in Cell A1. In the below example, If Cell A1=100, rows 3 and 4 would be...

The second field in my concatenate function is actual costs, the first is line of business. One value, for example, is $29,501,341.16 which I can round down...

I know this is likely an insanely simple situation, but it is early Tuesday and I am stumped. I have a simple spreadsheet breaking hours down by percentage...

I am looking for BOOLEAN Algebra Functions. Can't find any help in EXCEL. While I can work around the OR, AND, and NOT, I need XOR.

I have some VLOOKUPs which sometimes return 50 or 60 characters (they're in merged cells). I want the text to wrap, and the cell to enlarge to fit the text -...