Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Link to last entry
Thanks for clearing that up. I pasted it from the Google link and it works fine now. Just a tip if anyone else reads this - when I pasted it in, it didn't seem to want to be entered as an array formula, so I just deleted one of the brackets and replaced it, then pressed ctrl -shift-enter and it worked. Thanks again. Max Wrote: Believe the site/place where you're posting to or reading posts from unfortunately removes all the "greater than", "less than" or "not equal to" symbols from posts, including from within formulas, that's the trouble .. .... MAX((A1:A65535"") ... There's a missing "not equal to" sign between the A65535 and the double quotes "" in the above part Just insert the missing piece in the formula, and it'll work fine .. You could also try also viewing, and copy and paste JE's formula direct from this google link: http://tinyurl.com/8gysf -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik atyahoodotcom ---- -- dthomas |
#2
|
|||
|
|||
You're welcome !
Glad to hear you got it up. -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "dthomas" wrote in message ... Thanks for clearing that up. I pasted it from the Google link and it works fine now. Just a tip if anyone else reads this - when I pasted it in, it didn't seem to want to be entered as an array formula, so I just deleted one of the brackets and replaced it, then pressed ctrl -shift-enter and it worked. Thanks again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
removing automatic link | Excel Discussion (Misc queries) | |||
Link to last entry | New Users to Excel | |||
limit text entry in a range of cells | Excel Discussion (Misc queries) | |||
Link Link Link | Charts and Charting in Excel | |||
Breaking the link | New Users to Excel |