I am trying to count the number of cells in column B="large" when the condition in column A="week1". I tried the formula below and it counted all the...

Stand in cell A1, enter "=C1"uses the "drag link cell" in the down right corner of a cell. I will automaticly link A1 - C1 A2 - C2 A3 - C3 ect My question is...

I hope someone can help me. I devised a s/sheet in Excel 2007 using the COUNTIFS function. However, not all my colleagues like 2007 and have reverted back to...

hi, i have the below data and i need to make pivot from multiple sheets.i have tried to make by selecting multiple consolidation ranges, bbut it is not...

I have a list of 600+ zip codes that are curently in individual cells. I need to turn them into one list separated by commas. Is this possible? The best...

Can you please guide me about calculation of Antilog in the excel sheet. Regards

To those, if any, who use the array functions in the freely downloadable file at http://home.pacbell.net/beban: I refreshed the file yesterday with changes I...

I need help with correct formula to take a starting date from one cell and place a formula in another cell that will increase the number by one for every 365...

Hi, Does anyone know how to do this? Example: If F5 contains data, return the content of cell a1 to a cell on another worksheet. If statements don't work...

Please give me a hand. The source code in VB 6 is something looks like as follow: Dim ExcelObj As Excel.Application Set ExcelObj =...

We will be hosting a large fund raiser. I need to know the number of people attending. Here's my problem................ Some people come as couples, and...

I have two pivot tables that pull data from Access dB. This is for a warehouse productivity and accuracy. Each team consists of two employees: Picker and...

I have the following replace info in a macro. Selection.Replace What:="Of", Replacement:= _ " of ", LookAt:=xlPart, SearchOrder:=xlByRows, _ ...

I am having trouble adding an AND statement to the condition portion of the AVERAGEIF statement. Is there a trick to doing this?

Hi , I am using the sheet reference in a formula. the sheets are named on the basis of dates of a month... So i have to change the formula in every month...

Would someone tell me the exact mathematical equation for NORMDIST (x,mean,standard_dev,TRUE)? I have found an equation in Excel Help which is for cumulative...

Has anyone used Excel to track employee time and attendance? We have a basic worksheet set up, but are trying to determine if there is a specific way to show...

Bharnick, Try =A1&COUNTIF($A$1:A1,A1) in cell D1 and copy down. If you insert a row, you have (offcourse) to copy this formula to the cell in column D in...

I'm running Vista Home Premium SP2, 2 GB RAM, Firefox, Spyware Doctor, MBAM, SAS and CCleaner, Office 2007. All of a sudden only one (of many) worksheets...

I have a sheet that is comparing vendor's pricing. I am using the MIN to find the cheapest cost, but now I want to find out which vendor it is based on the...