Greg Truby
MrExcel MVP
- Joined
- Jun 19, 2002
- Messages
- 10,030
Username still intact, I see, Greg...
Perhaps Richard read Emma's tea leaves?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Jealousy
- Thread starter Expiry
- Start date
Perhaps Richard read Emma's tea leaves?
Excel Facts
Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
Richard Schollar
MrExcel MVP
- Joined
- Apr 19, 2005
- Messages
- 23,707
I don't have the courage to 'fess up to Tracy if somebody ratted on me about the username change - however utterly hilarious it would be...
Sigh.
Greg Truby
MrExcel MVP
- Joined
- Jun 19, 2002
- Messages
- 10,030
Aye, cain't fault ya there laddie. Rory's sig is too true. I used too much chlorine once. Tracy said the Geneva convention didn't cover pool boys...
Richard Schollar
MrExcel MVP
- Joined
- Apr 19, 2005
- Messages
- 23,707
Aye, cain't fault ya there laddie. Rory's sig is too true. I used too much chlorine once. Tracy said the Geneva convention didn't cover pool boys...
Oorang
Well-known Member
- Joined
- Mar 4, 2005
- Messages
- 2,071
Yes and if you knew exactly why the user thought that, you'd know a great deal more about the universe indeed.
mole999
Well-known Member
- Joined
- Oct 23, 2004
- Messages
- 10,524
- Office Version
- 2019
- 2016
- 2013
- Platform
- Windows
Pondering, has anyone deliberately written something overtly long winded and obtuse in a response just to see the reaction, the ultimate dire VBA macro as such, as we have explored Up, we need to explore Down also
Richard Schollar
MrExcel MVP
- Joined
- Apr 19, 2005
- Messages
- 23,707
Greg Truby
MrExcel MVP
- Joined
- Jun 19, 2002
- Messages
- 10,030
No, Richard's correct. I *have* done that.
Some member posted a needlessly complex solution so I went overboard and either wrote a routine or outlined a procedure that basically went from New York to Boston by way of Chicago, Seattle, Los Angeles, Dallas & Miami. 
I just can't recall a phrase that would help me find it on a search... 
Last edited:
mole999
Well-known Member
- Joined
- Oct 23, 2004
- Messages
- 10,524
- Office Version
- 2019
- 2016
- 2013
- Platform
- Windows
Tell me there was an easier way
Two of these in AK and AL, referecing different cells
You have to start somewhere for Time And Relative Dimensions In Space
I guess Rolf would say, Can You See What It Is Yet
The aim was to discover the Terminal Velocity between two Map locations, with a reducing time frame. Its alright, I have already laughed at me, feel free to join in
Two of these in AK and AL, referecing different cells
Code:
=ABS(AI2-W2)
Code:
=SQRT(POWER(AK2,2)+(POWER(AL2,2)))
Code:
=IF(BG2>0,SUM((BH2)/SUM((MINUTE(BG2)*60)+SECOND(BG2)))*2.2369,SUM((BH2)/SUM((MINUTE(BF2)*60)+SECOND(BF2)))*2.2369)You have to start somewhere for Time And Relative Dimensions In Space
I guess Rolf would say, Can You See What It Is Yet
The aim was to discover the Terminal Velocity between two Map locations, with a reducing time frame. Its alright, I have already laughed at me, feel free to join in
