• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. T

    Need to sum same cell from mulitple workbooks and ignore NA errors.

    I have 13 different workbooks. I need to sum the sum the values from B54 on the same sheet in each workbook. Some of these workbooks will contain an #N/A error in the cell, others will contain a numeric value. It is not an option to reformat the errors, we do not want to get rid of them. I...
  2. T

    Sum cell from multiple workbooks formula

    There are 13 workbooks in a folder (that also contains other workbooks and files). I am creating a consolidated workbook and I need to sum the values on the DashboardStats sheet cell B38, from each workbook. I would like to do this with a formula, not VB. I tried...
  3. T

    find the top ten largest values in N and display each with associated item in A

    I need to look down column N6:N400 and find the top ten largest values and display each one. For each top ten result I need to show the value from column A that is in the same row. I need two forumulas: 1. look down column N and find the top ten largest numbers and display each. 2. Look...
  4. T

    macro to copy cell and row, paste in new sheet in first empty row

    Cell H3 contains a date, formated mmm,d,yyyy B23:M23 contains numeric data. I need to copy H3 and B23:M23 to a new sheet titled "Historical" 1. H3 should go in column A on Historical 2. B23:M23 should be entered in the same column name, B-M 3. 1 and 2 from above should be in the same row...
  5. T

    Look down current month column and select first value without *

    I have a sheet with a column for each month. The column contains both numbers and *. I need to look down that column and show the value for the first cell that does not contain a *, for the current month. (I should mention that cell N1 has the current date) I need another one that will...
  6. T

    Average when there are #N/A

    I have two rows (B4:M4 and B6:M6) that will often, by design, contain #N/A. All other cells will contain a numeric value. I would like to calculate the average, but each range below may contain NA. B4:M4 = outages B6:M6=unplanned outages I am trying to get the average number of unplanned...
  7. T

    Count column F Y values for each seperate month in column A

    Can't get this to work. Column A5:A125 contains dates (format: January, 12 2010) Column F5:F125 contains "Y" or "N". I need to count all of the Y values that fall in each month of the year. One big issue that I am having is that the column A is formatted as a date. When there are blank...
Back
Top