My source worksheet contains all communities in our division. Each community has a specific #. Im trying to populte individual community worksheet from the...

Hi, Back in 2004, Jeff Borden asked about using GetPivotData with variable criteria output. Here's his original question: http://tinyurl.com/2saafw I have...

Hey! A question about random numbers in excel. I have a huge list of people and I need to assign to each one a random number between 0.0 and 1.25. The...

I would like to know how to turn a number such as "51319" into a date such as "5/13/19". As of now, when I try to format the cell to a date format, it...

I am trying to create a formula that looks at two dates, and based on the results places either a the calculation of number of days between the two dates,...

I have the following formula: =AVERAGE('7'!$E$164,'7'!$D$164,'7'!$C$164) It references a monthly workbook (#1 Turb-Jun09.xls) with a sheet for every day in...

How can you keep a reference to another cell from changing even if the other cell's contents are moved? The objective is to maintain a column of running...

I’m using Excel 2003, what I intended to accomplish to create a macro to unhide row (By default few rows will be hidden) based on the drop down list value...

Hey all, I've got 2 columns "A" has names & "B" has percentages. I've been able to use the VLOOKUP function w/in the same workbook as the data with success,...

Can anyone help me with this??? Is there a function that can identify if a person (name) is found in one of 4 worksheets. -- Alma Brumley

How can you keep a reference to another cell from changing even if the other cell's contents are moved? The objective is to maintain a column of running...

hello I have company #'s in column C ...the invoice amts are in column P & Q...I would like ...if there are 2 invoices i would like the invoice total of "P"...

I'm just learning to use the IF function, and it is not calculating correctly, so am looking for help. I'm using Excel 2000. For my spreadsheet, if a...

Need help on formula calculating start time, end time, start time, end time - with hours past midnight. What I have so far: C3 D3 ...

I am trying to copy data from cells to another worksheet missing out blanks - typically sheet 1 has data say in B1 D1 & F1 trying to get the data to sheet 2...

The VLOOKUP and HLOOKUP functions in excel return #N/A if the index is not found in the search list. The parameters should allow you to return zero or "" in...

Is it possible to use a date (created via an INDEX calculation) within a SUMPRODUCT calculation? I use a SUMPRODUCT calculation to generate headcount figures...

Entering a simple formula such as =AB1 into a cell results in =AB1 displayed. Formulas don't work either. Why would that be? Calculation is set to automatic,...

I am using Excel 2003. I have a group of cells with a data validation "list". That list contains 3 options -- check mark, "X", and "box" -- in Webdings. ...

I have to keep track of people attending meetings. The person prior to me created a spreadsheet with all the people attending with an alpha character in each...