please help. is it possible to password protect only one sheet in workbook? if so, could anyone please help. can i incorporate the script into an existing...

i am working with a list of addresses in my spreadsheet and i want to reverse the street numbers and street names. For example my adresses read like this...

Hello, I might be to tired but I can't get it right. In a sheet I have a database with 8 columns. The first ROW holds the titles. I named the titlerange...

I want to be able to have an amount in one cell then in aonther cell have the following function =roundup(c10+15/.9,0) so it takes the amount in the first...

Excel 03, how do you change the columns from numbers to letters. Both the column and rows are setup as numbers, instead of the rows being numbers and the...

Hi, I'm using SQL Server Reporting Services to produce reports, i'm then exporting the reports to excel, only I've run into a known problem with excel, ...

First, I have no idea how I would search for this question, so if it has been asked and someone would point me to it, I'll look there. Here is my problem: I...

I need to sort a column of date values that contain valid dates (i.e. 12/12/1990) as well as dates that contain zeros in the month and or in the day (i.e....

I have made up a new spreadsheet in Excel2007. Part of the sheet I have copied from a Excel2003 spreadsheet and pasted it into the new one. I have put Wrap...

I want to add data in one column after evaluating criteria in 2 separate columns. I have tried arrays and nested functions but can't figure it out. Any...

Hi, I am looking for a formula that does the following. If =1/04/2009 and = 1/31/2009 then P10 / If = 2/1/2009 and = 2/28/2009 then P11..... Any...

Hi, Does anyone know if there is a formula I can add into a formula already written that will highlight the cells that return true results and the primary...

Is it possible to have a formula use both vlookup and hlookup together? for example if i have a columns and rows that could change, but i have labels in...

Hi, I have this table with me and want to use if function the requirement is if a roll number has less than 40 marks it should be shown as failed in the next...

Hi all, l have like this: date 1 date 2 date 3 john dc nc mary nc nc peter dc of carl of ...

If cell "B6" in sheet7 value = "" then show userform3. How do I put that in code when the workbook is opened. This workbook always opens on sheet1. Thank...

I have a column formatted as text, I want to reverse the numbers around a1 1 a1 5 a2 2 a2...

I would like to use VLOOKUP to reference a set of data. When I paste the formula using 'Fill Down' the array values change. Is there a way to fix the...

I want to multiply two cells in a row that meet multiple criteria from other cells in that same row (like SUMIFS, but for a product). How can this be...