Recent content by truitt20

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...

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

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

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.

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

YA!!! Working now!! Thanks so much!

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...

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.

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

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]...

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

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

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

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...

Perfect! thank you