Hello, I am interested in backtesting setups based on clusters of retracements and extensions that meet near the same price level. This...
This challenge is all for fun. Feel free to participate if you're interested. This challenge came about when I challenged my friends to come...
Here's the file to be sorted, with info on what the final sorted output should look like. Have fun! -- M
Welcome to the First Annual Excel Guru Challenge. Your task, if you decide to accept, is the following: Use formulas (not VBA) to sort a...
u da Excel Man!!!! Very nice solution. You did in one column what I did in 150 columns.
Thanks dB. Pretty nifty. -- MMM
Thanks for the suggestion. I was able to figure out how to do it though a combination of the MATCH, OFFSET, and MIN functions by searching for...
Thanks for the suggestion Bdixon. While your technique works, it requires oneto process each row one at a time to find the desired result....
Thanks KTM. CountIF returns the sum of the rows that meet the criteria, rather than the row itself. It does at least tell you whether such...
The thought occurred to me last night that I might able be able to use the match function to find rows that are from N to say N + delta points...
KTM, Thanks for your suggestion. I actually started doing just as you had suggested. For each row, I transposed the current row through...
Mr. Subliminal, Thanks for your suggested fix. I was hoping to find a solution that does not involve sorting the rows. Ideally, I could...
Just a revision ... I'm searching for the first subsequent row that is N points or more above the current price, and N points or more below the...
Hi, Say you have a day's worth of 5 minute price data in a column in Excel. For this example, say you have 81 data points, although the actual...
Florida income tax rates are lower than in California.
That's good to hear. Could be that your power supply was not providing enough power to drive all the cards in your system. -- M
Ges, You will of course have to physically remove unnecessary cards from your system (ie, sound cards, controller cards, etc.). Removing...
Ges, Did you physically disconnect the components? You may want to try that before you fiddle with the registry or restoring a prior system...
I like your postings MaxMin, even if they may be similar or identical to what others may have already said. Sometimes it takes a while before a...
Ges, Have you tried disconnecting the unnecessary components from your system? It's easy to do, and might solve your problem. -- M
Separate names with a comma.