• 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 can...

    Mommiek10 pointsBadges:
  • Microsoft Excel subtraction using VBA

    I would like to have some coding in vb related to subtraction in Excel sheet.I have 2 sheets.I need to take data from 2 cells from the first sheet and perform subtraction and then placeresult in sheet2.I have huge amount of data in sheet1.I need to perform this operation with all the cells in...

    Devisri20 pointsBadges:
  • Creating a list in one Excel cell by referencing several other cells

    Using excel and I am trying to make a list generated into one cell, or cells right under each other. I have 85 choices for the user to select. If the user selects a symptom (column b, I want the treatment (in column C) to be displayed on a different tab. So the user would go through tab one and...

    Adventuredev55 pointsBadges:
  • Number formatting in Microsoft Excel

    I have a series of 8 digit numbers that I want to add 2 zero's to the middle of the numbers. For instance, I want 30251111 to be 3025001111. Without manually retyping every number (I have over 1,500 to modify), is it possible to do this with a formula? Any help would be appreciated!

    jlotts5 pointsBadges:
  • Qmf for Windows 8.1 fp18 – date datatype from db2 z/os 8 format error in excel 2003

    When I import a DB2 z/OS query result  containing date or date(timestamp) columns from QMF for WINDOWS in EXCEL 2003 using the Add-in the cells cannot be formatted. In the same column the date are displayed sometimes as dd/mm/yyyy, sometimes as nnnnn or in the previously defined format (example...

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

    shivasanjay2,525 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:
  • Microsoft Excel: Count number of distinct values in a range

    In my Microsoft Excel spreadsheet, I already have a large table with several filters. The only other thing I would like to add is a summary (underneath some columns) that contain the number of distinct values for that specific column. Is there a formula / function that would allow me to do that?

    ITKE351,945 pointsBadges:
  • Excel Macro to extract substrings from a comma-separated string.

    How can I write an Excel macro to exctract substrings from a comma separated string located in a single cell and put each substring in a cell of a certain column.

    Sdsdsd15 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:
  • Excel formula to find and replace letters in a word

    Hi, I have a cell that has a word written in it ex. damascus. Now with this formula, I need to be able to find the "a" and replace it with "A" so it will become dAmAscus. Is this possible?

    Microbert25 pointsBadges:
  • Excel equation

    When working out an equation in Excel, if I use a comma, it will work out the equation for me, but if I use a full stop or point the formula comes up with a #value error sign. eg. =4,5*5=22.5 but =4.5*5=#value Is there a setting I need to change?

    littlebiscuit25 pointsBadges:
  • Excel 2010 Second drop down based on first, not working

    I have tried a number of different formulas and data validation scenarios but I have not been able to get my second drop down to recognize the choice in the first drop down. I have a chart of sizes (including fractions) and several weights for each size. I want the weights in dropdown 2 to be only...

    jacktal5 pointsBadges:
  • Excel

    How do I find the sum in an Excel spreadsheet?

    Keteleyne1215 pointsBadges:
  • Cell formula

    I have a simple 2 column balance spreadsheet. I have my starting balance in column E Cell E4. I want to have a running balance in Column E. Column D has deduction amounts from balance in Column E. I have entered formula =(E4-D5) in cell E5 but this automatically enters the same starting balance...

    Schwenky5 pointsBadges:
  • Number formats

    I pasted a bank statement into Excel but I can't successfully do any calculations. Can you help?

    commercial5 pointsBadges:
  • Excel formula program

    Hi, I'm trying to do a table where I need to calculate how much commission I'm paying for a company. Before 35,000, I pay 35% commission after 35000 I pay 10%. The formula I have right now is =(IF(F9>=35,F2:F8*0.1,(IF($F$9<=35,F2:F8*0.35)))) and it works, but... I don't want the whole column...

    natmail10 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