• Excel, Lotus Notes view

    Whenever I export data from view to Excel using the export menu, I choose in the format of comma separated values once exporting is done, I open it in excel with comma separated data as in separate columns, till this everything is fine. Now when I see data in a particular column in excel for eg...

    shivasanjay1,610 pointsBadges:
  • Excel 2007 – how to add a average formula to that cell/s that ignoring 0%’s

    Okay 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)) Thanks,Jared

    Jreifenstein001185 pointsBadges:
  • One formula for a single column in Excel 2003

    I am using MS Excel 2003. I have a spreadsheet with the exactly the same formula in every cell of a given column (This is possible by using the row() and the indirect() functions). The spreadsheet is using 6000 rows. Currently, I have copied the formula into each cell. This increases the...

    Gosteelers5 pointsBadges:
  • How do I associate an employee # to a name in Excel 2007?

    I work in a restaurant and created a tip out spreadsheet. I need to insert employee names constantly. It would be much easier to just type in their employee# and have their name appear in another cell. Ex: Column A=Employee#, Column B=Employee's name. I want to type in the employee's # in cell A1...

    Weazel5830 pointsBadges:
  • 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. jan,...

    Wiggetssis25 pointsBadges:
  • 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*'

    Tmdillon5 pointsBadges:
  • How do you calculate formulas in Excel 2007?

    I am new to Excel and have a project to do tomorrow at my new position. We have contracts that start on a certain date in 2010 and will bill for various time periods. For example, we received a  240,000contract and will bill for the remainder of 2010 at $10,000 per month. The total for 2010 will...

    Cathraff5 pointsBadges:
  • Why does my COUNTIF for the middle row not come up with the right counts?

    Why does my COUNTIF for the middle tow not come up with the right counts? The first on and last one are OK, but they only have one condition. =COUNTIF(D6:D38,"<30") ' -- OK =COUNTIF(D6:D38,"<60")-COUNTIF(D6:D38,">29") ' -- counts double? =COUNTIF(D6:D38,"<=89")-COUNTIF(D6:D38,">=60")...

    Jaymz69765 pointsBadges:
  • Inserting Hex values into Excel

    Im new to Excel and am trying to Concatenate a number of cells together and sperate them by a single character represented by a Hex "4F". The combined cells will then be written to a file on my PCs C drive by way of a script. I will Transfer the file to a Mainframe PDS. Ive used HEX2DEC and its...

    Marsh218335 pointsBadges:
  • Formula Assistance in Excel xlsx for Office 2010 w/ Windows 7

    I need to know which formula I can use that will produce the following result with the following existing data: Column A, Row 2 - (Cell A2) - Value is 200806140804 Column A, Row 3 - (Cell A3) - Value is 200806150805 Column A, Row 4 - (Cell A4) - Value is 200806160806   Is there a formula I...

    Mommiek10 pointsBadges:
  • Multiple Names in Excel 2007

    I have a Excel sheet with hundreds of names and the same person may be repeated twice How do I create a formula so that I can like it to a new sheet and it only show a persons name one time

    Maine325 pointsBadges:
  • Data entry and calculations in the same cell

    I have an excel template and would like to allow the user to input their date in one of two ranges and have the other range calculated automatically based on a formula to use in each cell This means that the formula needs to be outside the cells in the two ranges as they are both used for date...

    Askm5 pointsBadges:
  • 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 will...

    Jreifenstein001185 pointsBadges:
  • 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...

    Dangerchef35 pointsBadges:
  • 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 in all papers,but it doesnt work....

    Moonzy5 pointsBadges:
  • 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.

    Bpbp5 pointsBadges:
  • 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...

    Crawjo15 pointsBadges:
  • 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

    Sarunmphil5 pointsBadges:
  • 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...

    Linux - Ask the Expert270 pointsBadges:
  • 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...

    Colwyn25 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following