Excel Formulas

Copy Data from an entire row in Excel 2003 Sheet to another sheet in the same workbook automatically

I have an excel workbook that has a Year To Date summary in it. People enter new data into the YTD summary (along a row there are 15 columns of data to be entered). One of the criteria for the entries is report date. I would like to have other sheets in this workbook (Each named a month, ie....

Excel 2007 - how to add a average formula to that cell/s that ignoring 0%'s

Ok i figured out how to ignore zero %'s for a graph. Now what I'm stuck on is how to add a average formula to that cell/s THis is what i had.... =IF(SUM(U171,U122,U74,U27)=0,#N/A,(SUM(U171,U122,U74,U27),(AVERAGE(U171,U122,U74,U27)) Thx Jared

Excel 2007 - How do I ignore zero %'s for a graph?

Excel 2007 - How do I ignore zero %'s for a graph? example: you have data that looks something like this: week # 1 2 3 4 5 6 PTP% 10% 13% 0% 0% 0 % Then graph the PTP% across from week 1 which is 10% to week 6 which is 0% On the graph all u will see is the plots from week 1 & 2. But then you...

Excel custom format, weekday & date line break query....

I created a spreadsheet which is to act as a rota, with the day and date displayed to the left. I entered the date then went to the custom format tab and entered dddd dd/mm/yyyy so it would display the day and date. So it can be printed with all the relevant data it is nessacery for this data to be...

Using Excel 2003: Adding days to a cell that contains both a text and numeric entry.

Can a formula be written that allows days to be added to a cell that contains both text and numeric information? For example, Cell A1 has NAME 1/3/09. I want to add 30 day increments to the 1/3/09 date in adjacent cells. Can it be done? If so. how? Thanks.

How do I enter a defined variable into a FormulaR1C1 statement?

I’ve defined the variable ‘Year’ as shown below, and I use it a number of times in my script. However, I’d like to use it in the “FormulaR1C1” command as well (shown below). How would I enter the syntax, so that it references my variable 'Year'? Currently I’ve manually entered the...

What is the difference between =+ and =?

Hi, I have a excel sheeting showing a formula as c1=+A1*B1. What does it mean? If I try with C1=A1*B1 the results are same. Then why do we need =+? pls help. Arun.K.S sarunmphil@gmail.com

Use of the EXCEL formula function to copy data and insert an asterik on both ends of output.

Is there a method to use the formula function to copy the contents entered in one cell (A2)into cell B2 with the addition of an asterisk '*' on both ends of the copied text? An example being - Enter 'H123456' in A2, with the output in B2 being '*H123456*'

Spread sheet formulas

How do I set up spread sheet formulas. The help section that came with the software is useless to me as it is much too technical. Our children's charity nonprofit runs off one PC, and being able to use the spread sheet would be wonderful instead of making up documents adding on a calculator for...

Multiple VLOOKUP with multiple results

There is 3 sheets 1st master sheet,2nd B-1 & 3rd B-2.In (master sheet) column A there are repeating towers name (eg:B-1,B-2,B-1,B-3), column B there are repeatation of apt. no. (eg: 101,102,101,103,104,102), column C there is a amount(eg: 15000,20000,etc.), i want to give formula in each sheet to...

can anyone help with a formula for excel

I have Excel 2007. There is one sheet with 2 columns of data. Column one has a series of numbers (e.g, 111,22,3333,etc). Column 2 has a series of terms (e.g, work,gym,home,etc). My problem is: whereas there is a series of numbers in column 1, the terms in column 2 only appear on the first row of...

Deleting all formulas in a worksheet when unprotected in VBA code

I would like to know the vba code for deleting all formulas within a worksheet if the worksheet is unprotected by any one, obviously I would have to have an administrators code in case I need to unprotect the worksheet myself. My workbook contains many worksheets and with many formulas I have...

Is vlookup the correct formula to use for my task?

This is the formula that I am trying to write: When the cell row values in columns A and B, are equal to the cell row values in colums E and F are the same, I would like that information to appear side by side in separate colums for comparison. For any company data that does not match with vendor...

Excel Form Macro

Hello Excel Gurus, I am in great need for an Excel Froms Macro that Switches a Spin Control (asignes integer value) to a cell and is mux'ed betwen different cell references that are activated by a radio button. I created a model code fragment well over a year ago and got the functionality to work...

Current Date in Excel Query

I am using Excel 2003. I am trying to run a query that will used daily and the only thing that will change with the query is the current date. Is there a way to use a formula saved in the query that will automatically use the current date instead of having to manually input it everytime? Thank you!

Adding dayys to a date without adding weekends

I want to enter a date into a cell in microsoft excel and in another cell I want it to add five days onto the previous date without includind the weekends in so if I enter the 7/16/2008 into the first cell then I want to have it add five work days making it the 7/23/2008 instead of five regular...

Ms Excel Question

i have entered different students name in column A, Paper name in Column B & their marks in column C. like: john english 90 magi maths 15 john stats 99 john history 35 & i've applied this formula: =if(A2:A66000="John",sum(C2:C66000)) to get the total marks of John...

Excel 2003 linking text format in two workbooks

I have 8 different workbooks that are linked to one master workbook. In each of the 8 workbooks people need to select certain names and change the text format to bold. however when the master workbook is open and updated the BOLD format is not there. Each of the 8 workbooks are changed monthly...

Search for duplicates in a collumn and delete the row on which it occurs

Hi, I have a spreadsheet with list of identifiers in collumn 1, this is auto generated and due to the source info some of them duplicated, what I want to do is find the duplicates and remove the entire row they appear on. I know this is possible using clipboard and filters but I would rather...

Retreiving data from within square brackets, there may be more than one in each cell (spreadsheet owner refuses to change it grrrr)

I have a spreadsheet with a column containing data in the following format Column G Row 1 [1T40131A] [GB50131A] [GB50131B] [GB50131C] [1T50131D] Row 2 [1T400133] Row 3 [303640]*VF Row 4 [240700]*RN I would like to create a UDF that will retrieve the data within the...