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 Rhinorhino 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: *

  1. truitt20

    Excel Transpose?

    I have data formatted in excel like the below: a b c xxx 10 20 60 yyy 30 10 20 ttt 40 5 15 vvv 50 70 30 And I would like to automatically get the data formatted in another worksheet like this via formula or some other auto means: xxx 10 a xxx 20 b xxx 60 c yyy 30 a yyy 10 b yyy...
  2. truitt20

    creating exe to open programs?

    is it possible to create a executable file to open various programs all at once? thanks
  3. truitt20

    Creating a .EXE to open programs

    I was wondering if it is possible to create an executable that opens various programs for me? It would be nice to just run the .exe and have all of my ten programs open up automatically. let me know if this is possible thanks
  4. truitt20

    OFFSET, COUNTA, Dynamic Range Formula

    I have one column: Date 1/1/2007 1/2/2007 1/3/2007 1/4/2007 1/5/2007 1/6/2007 1/7/2007 1/8/2007 This data range will expand each day. I want a dynamic formula that subtracts the "last" date from the first date automatically. Is this possible in a formula? I do not want to use named ranges.
  5. truitt20

    #VALUE! Error

    SO I am getting this in a few cells (which I am expecting to), the problem arises when I try to Sum the column. It will not do this b/c of the non-numerical text in the columns. Does anybody know of a workaround? thanks jt
  6. truitt20

    Query Issue

    YA!!! Working now!! Thanks so much!
  7. truitt20

    Query Issue

    HSBC Put k=130 exp 8/30/07 (jpm) 130 e HSCEI Put k=11097.9 11/29/07 (jpm) /drc 11097. HSI Put k=19822.5 10/30/07 (jpm)/nw 1982 HSI Put k=21208.75 10/30/07 (jpm)/nw 2120 HSI Put k=21742.65 10/30/07 (jpm)/nw 2174 Huaneng Power Put k=7.72 9/13/07 (jpm) 7.72...
  8. truitt20

    Query Issue

    Ya - still the same results. The string length it is pulling varies for some reason. Sometimes it pulls a length of 4 and then in another row it may pull a length of 7. Not sure how to really fix it either. I have been tinkering with your expression, but t no avail.
  9. truitt20

    Query Issue

    Great - that pulls data now, but it is pulling data in various lengths. not just the strike. do you know how to just pull the strike? For example: FTSE/JSE Tp40 Put k=22000.98 10/16/07 (jpm) is pulling: 22000.98 1
  10. truitt20

    Query Issue

    TRANSFORM Sum(JPM.[End Qty]) AS [End Qty] SELECT JPM.Security, JPM.[Sec Symbol], Mid(Trim(Mid([Security],InStr([Security],"=")+1)),1,InStr([Security],"")) AS Strike, JPM.[Sec Currency ISO Code] AS Ccy FROM JPM GROUP BY JPM.Security, JPM.[Sec Symbol]...
  11. truitt20

    Query Issue

    still just show the first number after the = i have been playing around with it too and cannot get it to work
  12. truitt20

    Query Issue

    Almost there. For: FTSE/JSE Tp40 Put k=22000.98 10/16/07 (jpm) I changed the expression to: Mid(Mid(X, InStr(X, "=") + 1), 1, InStr(X, " ")) and this gives me an output of 2 i need to include the whole number of 22000.98. and also this number varies in length
  13. truitt20

    Query Issue

    I am looking to write it as an expression in the Field name. So the result for FTSE/JSE Tp40 Put k=22000.98 10/16/07 (jpm) would be 22000.98
  14. truitt20

    Query Issue

    I have a simple crosstab query in Access. In column "Security" is a list of securities and their strike prices. The strike price always follows the text "k=" and i need to just grab the strike value and put it another field. Unfortunately the numbers of spaces before & after the strike vary...
  15. truitt20

    Dynamic Range in EXCEL

    Perfect! thank you
  16. truitt20

    Dynamic Range in EXCEL

    Ok - I have a problem here. I am trying to create a dynamic defined range using the offset & count functions, but I am not sure how to grab the range I am looking for. I have column C populated with a whole bunch of numbers. Each month we add additional numbers to the column, and I want a...
  17. truitt20

    EXCEL FORMULA QUESTION

    Roel, Thanks for the help. However, this formula is coming up with a #VALUE error. Any other ways to configure this? thanks
  18. truitt20

    EXCEL FORMULA QUESTION

    column A has a range of dates column B has a range of daily returns of the S&P for that specific date column g has a range of daily returns of our fund for that specific date i want to run a correlation on columns B & G for specific dates however, i only want the value of the correlation to be...
  19. truitt20

    EXCEL FORMULA QUESTION

    Skip, Is there a formual that could use the correlation function based on criteria? thanks
  20. truitt20

    EXCEL FORMULA QUESTION

    is it possible to create a formulas like so: =sumif($A3:$A15000,($C$15004),CORREL($B$13609:$B14446,G$13609:G14446)) where i embed a correlation function within the sumif function? thanks

Part and Inventory Search

Back
Top