Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Syndrome78

  1. Syndrome78

    If Column Has a Value Sum Another Column If It Matches

    Thanks Skip, Once again you've easily solved my problem and I really didn't think the formula would look that simple. On a side note I've never used and &0 in a formula, what does it do.
  2. Syndrome78

    If Column Has a Value Sum Another Column If It Matches

    Sorry for being vague and I don't have URL's to attach files or pics. I have pricing in column K and counts in column V. I'm trying to sum the counts in column V if there is not a blank cell in column K. So for the sum answer I'm looking for is 90. K V blank 10 $100.00...
  3. Syndrome78

    If Column Has a Value Sum Another Column If It Matches

    Hi All, I have an Excel spreadsheet with columns that have pricing in some cells, but some of the cells may not have prices in them. I would like to sum the numbers in column V1:V28 if it has a price in column K1:K28 and put the formula in cell K30. Thanks in advance for all who help
  4. Syndrome78

    Multiple IF Statements On Y/N Cells

    I have a new rate that I have to add for a calculation spreadsheet, but I can't figure out how to integrate it using existing IF Statement formulas. I have 4 rates for a class; rate 1 is a standard rate, rate 2 is a discounted rate for primary service, rate 3 is a discounted rate for primary...
  5. Syndrome78

    Link Comments in Excel

    Hi, I'm linking data from multiple spreadsheets into a summary excel spreadsheet. The data in the cells links fine, but I would also like to have the comments from the original cells linked as well. Is there any way to have the comments from those cells show up in my linked summary spreadsheet?
  6. Syndrome78

    Link Comments in Excel

    Hi, I'm linking data from multiple spreadsheets into a summary excel spreadsheet. The data in the cells links fine, but I would also like to have the comments from the original cells linked as well. Is there any way to have the comments from those cells show up in my linked summary spreadsheet?
  7. Syndrome78

    Find The Top Ten #s in a Data Sheet

    I need the date from the left hand column B and I will need to know the hour H# in row 1. The request is for the top ten highest values and they want to know what day and what hour they occurred. I need to know how I can get the top ten highest, what day they occured and what hour they...
  8. Syndrome78

    Find The Top Ten #s in a Data Sheet

    The large function works, but what conditional format can I use to find the date and hour associated with it.
  9. Syndrome78

    Find The Top Ten #s in a Data Sheet

    The top ten highest.
  10. Syndrome78

    Find The Top Ten #s in a Data Sheet

    I have a worksheet with 20 years worth of data and I was tasked to find the top ten load data values for the entire worksheet. Here is an example of the spreasheet. The H# is the hour and it goes up to H24. CompID Dt H1 H2 H3 H4 H5 1 1/1/1989 142 124 117 112 112 1 1/2/1989 134 120 115...
  11. Syndrome78

    Look Up Cells In Multiple Columns Referencing Max Value.

    Skip, Thank you so much, it worked and I'll use named range headers in the future. Carl
  12. Syndrome78

    Look Up Cells In Multiple Columns Referencing Max Value.

    I'm a little confused and I don't seem to have put the right formula in. The formula I came up with using what you put was: =INDEX(INDIRECT(B1),MATCH(MAX(A2:A1018),A2:A1018,0),1)
  13. Syndrome78

    Look Up Cells In Multiple Columns Referencing Max Value.

    I have a spreadsheet with multiple columns/rows of data. I need to find the max of one of the columns and the data in the other columns that are in same row. I've found the max, but I want to reference it in order to find the values of the other columns in the same row. KWH KVARH KVAH PF...
  14. Syndrome78

    Using Average IF Statement in Excel

    You were correct and thank you for your help. I was using the formula =SUMIF(L2:L67,">0",M2:M67)/COUNTIF(L2:L67,">0",M2:M67). It worked perfectly when I deleted the third parameter. Oh and Skip, I misunderstood which formulas you wanted to see. Thank All of you for your assistance.
  15. Syndrome78

    Using Average IF Statement in Excel

    The Load Factor formula is =SUM(range values)/(Max(range values)*(24*365)). The Savings formula is =(B2-C2)/B2. Some companies have negative Savings.
See more

Part and Inventory Search

Back
Top