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!

Search results for query: *

  • Users: Cordury
  • Order by date
  1. Cordury

    .txt to Excel Spreadsheet.

    I apologize that I was not clear. I was curious is an the Array function could separate the data in the format that I need.
  2. Cordury

    .txt to Excel Spreadsheet.

    If someone could let me know how to post a pic/image of the actual report, I will do it. The original post does not look very good.
  3. Cordury

    .txt to Excel Spreadsheet.

    I receive daily invoice paid/process reports from a third party vendor, so there is little hope that they will change the format of their files. I simply would like to read the .txt files in Excel. When I copy and paste the data, and use the Text to Columns function, there are serious format...
  4. Cordury

    Lookup/If Statement Inquiry

    Thanks, I was close :)
  5. Cordury

    Lookup/If Statement Inquiry

    =IF(ISERROR(VLOOKUP(C1,A1:A6,1,0)),C1*0.56,C1) Would that work?
  6. Cordury

    Lookup/If Statement Inquiry

    Thanks Blue. However, I did not post the proper. I have a column of numbers, and if the value is not 500 400 300 200 180 150 I just want to return the value in the cell. If it is one of the above values, I would like to muliply it by .56 Thanks, Cord
  7. Cordury

    Lookup/If Statement Inquiry

    I have a set of 6 numbers: 500 400 300 200 180 150 If a cell equals any of the above numbers I want the cell value to be multipled by .56 if else, multiply the cell value by .185 I am having issues with the embedded is statement. Should I add another column and try using a lookup (using a...
  8. Cordury

    Format Cells SIMPLE question

    Thank you Ken. Will the type save in the properties box?
  9. Cordury

    MAIL MERGE PROBLEMS

    Do you receive the same error if you already have your datasheet open and then open your Word Mail Merge doc?
  10. Cordury

    Format Cells SIMPLE question

    One more thing, will Excel save the format (in XLSTART) for future use ?
  11. Cordury

    Format Cells SIMPLE question

    First let me start off by posting, I'm an idiot. All I want to do is create a custom format that leaves positive percentages black and formats negative percentages with ()'s and formats the font red. The current type #,##0.0_%);[Red](#,##0.0%) Is not working for the postive numbers. Thanks...
  12. Cordury

    Forumla to exclude cells with a 0 (Zero)

    Ken, Columns AO,AJ,AE,Z,U,P,K contain an internal company metric. Your formula will pull the lowest value (greater than zero) from columns other than AO,AJ,AE,Z,U,P,K. I apologize if I am doing a poor job explaning my issue. Your formula =IF(MAX(AO3,AJ3,AE3,Z3,U3,P3,K3)=0,"NO...
  13. Cordury

    Forumla to exclude cells with a 0 (Zero)

    Ken, Your formula is working (sort of). It is pulling data from columns that I do not want it to pull from. I was hoping to return the lowest value (excluding zero) from $AO3,$AJ3,$AE3,$Z3,$U3,$P3,$K3 Thanks, Cord
  14. Cordury

    Forumla to exclude cells with a 0 (Zero)

    I understand why most of your suggestion works, however- Why is the reasoning behind adding 1 to the count of zeros in the last formula? After the above formula (to the right), enter this formula: =SMALL((AO4,AJ4,AE4,Z4,U4,P4,K4),BF4+1)
  15. Cordury

    Forumla to exclude cells with a 0 (Zero)

    Dale, Thanks for taking the time to explain the different forumlas. Yes it is a bire more lengthy than I would have liked but Hey- it works the same. Again, thanks for taking the time.
  16. Cordury

    Forumla to exclude cells with a 0 (Zero)

    Zath, I have added the "Brackets" to my formula. However, it is still not returning the desired results. I would like the formula to return the next lowest value (that is not a zero). Thanks,
  17. Cordury

    Forumla to exclude cells with a 0 (Zero)

    Zath, Brackets now surround my formula but it is still not returning the desired data. I would like the MIN formula to ignore all zeros and return the next lowest number?
  18. Cordury

    Forumla to exclude cells with a 0 (Zero)

    I know there is going to be a simple formula response to this but my brain is too focused on the holidays to come up with a solution. I have a spreadsheet that contains rates in about 10 columns. I would like to add a column at the end of the spreadsheet that returns the lowest value...
  19. Cordury

    Returning Just numeric values in a cell.

    Name conflicts with existing module, project or object library
  20. Cordury

    Returning Just numeric values in a cell.

    I do not see my Personal.xls under Tools/References. How can I select my Personal workbook?

Part and Inventory Search

Back
Top