I have a range of Question responses from a survey that I'm seeking to find the most common response combinations from. Simply sorting the data doesnt...

Hello, I have two different spreadsheets. I'm trying to write a formula that says if the ID in A1 of the first spreadsheet matches anywhwere in column AE in...

I used Excel to create a Web Page, I also inserted pictures and saved as Web Page, question; when I edit with Microsoft Office Word, from my experienc in the...

help! i have a workbook that i've password protected and can't get into now. i've tried everything i know and it won't work. this is 2003. any possible...

Hi there, I have a column of numbers which I am looking to change. ie..all numbers between 1-10 should be replaced with a certain value and then all numbers...

I need a formula that looks at a cell and if it's not empty it preforms the following function: =IF(B17=B2,1,SUM(MONTH($B$2)-MONTH(B17)) B2 is set for...

The value in some of the fields to look up are decimals. EX: The result in the field is 5.6. The lookup is seeing this as 5 instead of 6. My formula is...

I have a spreadsheet with simple calculation formulas in the columns and one of the columns with the same formula copied and pasted into each cell is driving...

I have a spreadsheet with 1100 rows of data. I need to match the user id's in column A with same user id in column D. Have their data all be on the same line...

Is there any way to have more that 3 condition in conditional formating? -- Thank you

Hi I have the following situation: 94101 How do i add a (.) ( Period at the end of each number in each Cell) 94101 94101 93001 93001

I want to know how to multiply a single cell by a percentage. ie: 2000.00 x 17.5% or 2500.59 x 30% Does anybody know how to do this, appreciate your...

A good day ! I have this function : =AND(COUNT(B1;B3;B5)=1;COUNT(C1;C3;C3)=1;COUNT(D1;D3;D5)=1;COUNT(E1;E3;E5)=1;COUNT(F1;F3;F5)=1) ; this function...

I am trying to set up a formula to count days from start date to end date including the start day. I have a total of 30 date sets that I need to track and...

I have a spreadsheet where O:62 and O:63 are products of a formula in their rows. The cells in between are segmented, so I can't do a simple O1:0:60, it's...

I need a formula that will subtract March from June returning only the number of months. For example: 6/1/08-3/1/08=3 6/1/08-3/15/08=3...

How do I copy the carriage return and paste it into notepad without having the quotation marks surround it?

Hi, I wondered if there is a function in Excel that allows you to look up a value by two or more columns. (e.g. I want to ask for "column 1 = 1" AND "column...

hello there when i try to copy a sheet into new or the same work book it looks like its done but it hides somewhere somehow and i cant find it anywhere have...

I have a list of addresses in the following order: names (a1), business names (a2), streets (a3), city state and zip codes (a4), business phone (a5), cell...