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 MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Jkaen
  • Order by date
  1. Jkaen

    Column lookup based on cell content

    Nevermind I managed to solve this in the end, for anybody else looking, solution is: {=IF(ISERROR(INDEX('Gantt Chart'!$A$5:$AB$31,(SMALL(IF(INDIRECT("'Gantt Chart'!R5C"&$G$2+3,0):INDIRECT("'Gantt Chart'!R31C"&$G$2+3,0)>0,ROW('Gantt Chart'!$A$5:$A$31)),ROW(1:1)))-4,1)),"",INDEX('Gantt...
  2. Jkaen

    Column lookup based on cell content

    Hi all, I am stuck trying to implement a function into excel. The part I am stuck on is using a lookup based on a cells content. I assume I want some use of the indirect function but cant quite make it to work. The main issue I have is if the cell content of f2 is 1, I want to lookup D5:D31...
  3. Jkaen

    Drag Formula to increment worksheet

    Thanks for the responses, I know multiple sheets are generally frowned upon, its just occasionally its difficult to do otherwise. Seems i made a mistake renaming the tabs too early to make onlyadrafters solution to work. Think the answer is to rework things in such a way I can get it all on 1 sheet
  4. Jkaen

    Drag Formula to increment worksheet

    Hi all, I have a tracking spreadsheet set up to track various procurement activities with each package as a separate worksheet. I then have an index page with hyperlinks to the individual worksheets for summary purposes. What I want alongside these links is to pull up various data from the...
  5. Jkaen

    API 5CT tubing as pipeline

    We are doing stress because the client requests it. I think their head office has said they can only use the drill pipe if they get full stress analysis on the line first
  6. Jkaen

    API 5CT tubing as pipeline

    Yes, we are not completely happy about it, but are trying to be flexible and helpful to the client etc. The stress guys are complaining that as it would be a custom joint in Caesar they don't have any details regarding the performance of the joint which invalidates the whole model. Will try to...
  7. Jkaen

    API 5CT tubing as pipeline

    Hi all, We have been asked by a client to use existing API 5CT tubing (5", L80 GRE lined, threaded ends) as pipeline material for a water injection network. I can't see anything in ASME B31.4 stopping us from using this material, but we are a bit stuck on how to handle branches off the main...
  8. Jkaen

    Conditional Grouping Data from Table

    Hmm, seems I do need to get familiar with pivot tables, as it does do what I requested after all. As it happens the extra functionality I get from the array approach is of value to me, but i have been dismissing using pivot tables in my spreadsheets without really understanding them. Thanks...
  9. Jkaen

    Conditional Grouping Data from Table

    IDS, Maybe I am not understanding your suggestion correctly. To me sorting or pivot tables adjust how the data is displayed within table A. I don't want to alter the arrangement of this table, I want to selectively draw information from this table and display it in another on a different...
  10. Jkaen

    Conditional Grouping Data from Table

    For those following this thread in future, I did sort of find a result. I have had to pre add in rows for the second table, but using arrays as indicated here ended up helping http://thinketg.com/how-to-return-multiple-match-values-in-excel-using-index-match-or-vlookup/ Note that is your table...
  11. Jkaen

    Conditional Grouping Data from Table

    Ok, looks like I have to use Macros then. Table A is a bid bat with each row being an engineering deliverable which includes deliverable name (as per mock example) and hours for that deliverable (which I was hoping to understand how to deal with based upon this response. Table B is actually...
  12. Jkaen

    Conditional Grouping Data from Table

    Hi all, I am trying to group a bunch of text from column B of a table based upon an numerical value in column A of the table. I want the various qualifying text then all grouped (CONCATENATE I assume) in a second table I have attached a mock example of what I am after with random text in to...
  13. Jkaen

    Sum multiple lookup table across worksheets

    Hey all, hope you can help me. I am trying to get a framework contract tracking software sorted and have call in excel to try to obtain data from across various worksheets (circa 60) The formula I am using for a single worksheet is: {=INDEX('Sheet 2'!A8:I9,MATCH(A7&C7,'Sheet 2'!D8:D9&'Sheet...
  14. Jkaen

    Printing Multiple worksheets in Excel

    Lindsay got the solution, thank you very much (the print entire wookbook thing didn't solve it)
  15. Jkaen

    Printing Multiple worksheets in Excel

    Thanks for the reply, however this happens on my computer with CutePDF and my colleagues with both CutePDF and Adobe Acrobat 5. Goto last cell also has not shown anything, each worksheet is printing off as one page, the problem I am having is the workbook isn't printing off as a single entity
  16. Jkaen

    Printing Multiple worksheets in Excel

    Hi guys quick question for you. Most of the spreadsheets I work with a multiple sheets, I tend to print out all these sheets at once by selecting all the tabs and hitting print. The problem comes with making pdf files, where many of my spreadsheets will try to seperate out. For example a 5...
  17. Jkaen

    LEL of Ethylene Oxide in CO2

    Perfect 25362, that was just what I was after and somehow failed to find with 2 hours of googling, thank you very much.
  18. Jkaen

    LEL of Ethylene Oxide in CO2

    Hi Guys, I have read this thread http://www.eng-tips.com/viewthread.cfm?qid=33615 And while it helps in general terms with diluted hydrocarbons I am struggling to apply it to Ethylene Oxide (LEL 3%, UEL 100%) It is my thinking from a pure common sense viewpoint that as EO produces its own...
  19. Jkaen

    Missing chemical information

    Hi guys, I have posted a thread on the aspen forum (http://www.eng-tips.com/viewthread.cfm?qid=148041&page=1) but as it seems rarely used I thought I would post here in a slightly reworded form. Main problem is I am trying to model a reaction with various chemical streams, but dont have...
  20. Jkaen

    Additional components

    Hi guys another plea for help here. Currently using Aspen Plus version 11.1 and keep running into problems with components not included in the databanks, normally we can just use similar components, however in this case (2-iodoethanol) We can't even find anything similar, nor can I on the web...

Part and Inventory Search

Back
Top