Hello, I'm trying to automate an excel spreadsheet to track the employees' resolution time to problem solving. I have a standard table where it states the...

You can probably use something from this site =SUMPRODUCT((I2:I100=A2)*(E2:E100="S")) http://www.cpearson.com/excel/duplicat.htm -- Regards,

Hi: I have a spreadsheet with 10 columns and about 200 rows. Each row is a record. There is a total row in row 201 that performs basic calculations (like...

I constantly use the functions/commands: Format/Column/AutoFit Selection. Is there any way to make a column automatically widen to fit contents as...

I like the "Auto Filter" feature, especially with a "Subtotal" at the end of several columns of my spreadsheet. What I need know is something like a...

I have a list of radio stations in column A in my destination sheet. (KBXR,KOTZ,WFUV, etc.) I import numbers weekly that correlate to each station. In order...

Every time I enter a number into a sheet (all my sheets) it adds a zero at the end automatically, e.g. 12 becomes 120. Now I can stop this by typing 12.0. I've...

I have a spreadsheet that looks like the following: A B 1 Last Name First Name 2 Jones Jim 3 Smith Bob 4 Williams Joe If the...

Can anyone tell me when using the STDEVP function in excel to obtain standard deviations, is the resulting answer 1 sigma standard deviation or 2 sigma...

I think what you're after is this, entered with Ctrl-Shift-Enter in cell C2 =MIN(IF($A$2:$A$10=A2,$B$2:$B$10)) Change the 10 in both spots to reflect your...

Greetings! Is there a way to place a graphic behind cells so that I can see the graphic but still click in the cells over it and add numbers or formulas to...

What is the syntax required to include ISBLANK within the criteria of an advanced filter? ie: Criteria Name Date TOM =ISBLANK(???) ...

How can I get cell contents on the 1st and 15th of each month and automatically enter those contents in another cell. Thanks, Barney

I have a spreadsheet that has several tabs with some columns of whole numbers, I would like to round these numbers to millions with either formatting or a...

Hello, I have a column that I am taking on row in a column and * by 20% form the # found in the same row in a different column. I can do this for each row...

Use a defined name like =vlookup(I2,MyTable,2,0) or =vlookup(I2,$K$1:$L$280,2,0)

Hi, I have a spreadsheet of contacts with the names, company, fax area code, fax local number in separate columns. And I am trying to unite the two...

Hi, I have a list of thousands of customers in column A. I just need to find out the count of unique customer names that appear in this list. If also...

I have the following columns A=month B=year C=Priority D=Inspected Column A data is Nov, Dec etc Column B data is 2003, 2004 etc

Is there a way to log all input that is entered through a inputbox? I have a inputbox in a macro that a user enter data into. What I would like to through...