The Thread Of Randomness

This is the place to talk about anything not related to Transport Tycoon itself.

Moderator: General Forums Moderators

User avatar
Dave
Moderator
Moderator
Posts: 17243
Joined: 26 Dec 2005 20:19
Location: North London

Re: The Thread Of Randomness

Post by Dave »

Tottenham is once again on fire. This time a warehouse, not the high street. So...
Official TT-Dave Fan Club

Dave's Screenshot Thread! - Albion: A fictional Britain
Flickr


Why be a song when you can be a symphony? r is a...
User avatar
Chrill
Moderator
Moderator
Posts: 15974
Joined: 18 Dec 2004 17:35
Location: Stockholm, Sweden
Contact:

Re: The Thread Of Randomness

Post by Chrill »

I needs Excel help

Or Google Spreadsheets actually but it's all the same, more or less. Here's what I want to do:

1) Find the highest value of two numbers. This is easy, I will just use =MAX(cell XY on page 1, cell XY on page 2) because I am comparing a number on two different pages of a spreadsheet.
2) AND THIS IS THE ONE I CANNOT FIGURE OUT. I want to return the number from above, as well as attaching which page I get the value from.

So for example:

Page 1, field B3 might say 1.3.
Page 2, field B3 might say 1.6.
I want to create a formula that will say 1.6, and next to that (in a new field, with conditional formatting, whatever), I want it to state Page 2 or something else that distinguishes where it found the higher of the two values.

Anyone? :mrgreen:
Image
My Scenarios:
Archipiélago Hermoso (Latest Release: Version 3.2)
Turnpike Falls (Latest Release: Version 0.91)
User avatar
Pacific RailRoad
Engineer
Engineer
Posts: 61
Joined: 16 Feb 2017 12:09
Location: Middle Of Nowhere

Re: The Thread Of Randomness

Post by Pacific RailRoad »

Hello people of "The Thread Of Randomness" , I've come in peace! no one point a gun at me please.
__==Chop Chop , That's all Lads , Go home now if you don't have plan to replay==__
My youtube (Locomotions videos shenanigans) : https://www.youtube.com/channel/UCrsVWb ... e97MVmrSkg
Image
Transportman
Tycoon
Tycoon
Posts: 2781
Joined: 22 Feb 2011 18:34

Re: The Thread Of Randomness

Post by Transportman »

Chrill wrote:I needs Excel help

Or Google Spreadsheets actually but it's all the same, more or less. Here's what I want to do:

1) Find the highest value of two numbers. This is easy, I will just use =MAX(cell XY on page 1, cell XY on page 2) because I am comparing a number on two different pages of a spreadsheet.
2) AND THIS IS THE ONE I CANNOT FIGURE OUT. I want to return the number from above, as well as attaching which page I get the value from.

So for example:

Page 1, field B3 might say 1.3.
Page 2, field B3 might say 1.6.
I want to create a formula that will say 1.6, and next to that (in a new field, with conditional formatting, whatever), I want it to state Page 2 or something else that distinguishes where it found the higher of the two values.

Anyone? :mrgreen:
If you would have a page with the max per page and the page name, you could do a VLOOKUP on that with the max value you actually have. Otherwise you could write some extremely convoluted mess of nested IF-statements, IF(MAXVALUE=MAX(Page1);Page1;IF(MAXVALUE-MAX(Page2);Page2;...
Coder of the Dutch Trackset | Development support for the Dutch Trainset | Coder of the 2cc TrainsInNML
welshdragon
Tycoon
Tycoon
Posts: 2148
Joined: 27 Jul 2007 15:45
Location: Sunny Wales, Boyo!
Contact:

Re: The Thread Of Randomness

Post by welshdragon »

I'll just leave this here.
Image
I'M BACK!


Sent from my iPhone using Tapatalk
Semi-Retired TT-Forums Member.
These days I'm:
[list][*]A Local Transport Representative for Bus Users Cymru
[*]Social Media Advisxer for Bus Users Cymru
[*]Volunteer and Fundraiser for Guide Dogs[/list]
flickr | twitter | YouTube | Facebook | Steam

I used to be an idiot called tycoonmarkj.
User avatar
Pacific RailRoad
Engineer
Engineer
Posts: 61
Joined: 16 Feb 2017 12:09
Location: Middle Of Nowhere

Re: The Thread Of Randomness

Post by Pacific RailRoad »

Enjoy ...



__==Chop Chop , That's all Lads , Go home now if you don't have plan to replay==__
My youtube (Locomotions videos shenanigans) : https://www.youtube.com/channel/UCrsVWb ... e97MVmrSkg
Image
User avatar
Chrill
Moderator
Moderator
Posts: 15974
Joined: 18 Dec 2004 17:35
Location: Stockholm, Sweden
Contact:

Re: The Thread Of Randomness

Post by Chrill »

Designated Survivor.

DO ANY OF Y'ALL WATCH IT.
Image
My Scenarios:
Archipiélago Hermoso (Latest Release: Version 3.2)
Turnpike Falls (Latest Release: Version 0.91)
Transportman
Tycoon
Tycoon
Posts: 2781
Joined: 22 Feb 2011 18:34

Re: The Thread Of Randomness

Post by Transportman »

Chrill wrote:Designated Survivor.

DO ANY OF Y'ALL WATCH IT.
No, but I do intend to do that if I have some time when I have caught up on some other series (House of Cards, the Marvel shows).
Coder of the Dutch Trackset | Development support for the Dutch Trainset | Coder of the 2cc TrainsInNML
User avatar
Chrill
Moderator
Moderator
Posts: 15974
Joined: 18 Dec 2004 17:35
Location: Stockholm, Sweden
Contact:

Re: The Thread Of Randomness

Post by Chrill »

Yes. Well watch it. Season 2 just premiered, and it promises to be as good as season 1. Season 1 of Designated Survivor easily ranks in my top 5 best ever seasons of any TV show.
Image
My Scenarios:
Archipiélago Hermoso (Latest Release: Version 3.2)
Turnpike Falls (Latest Release: Version 0.91)
User avatar
Chrill
Moderator
Moderator
Posts: 15974
Joined: 18 Dec 2004 17:35
Location: Stockholm, Sweden
Contact:

Re: The Thread Of Randomness

Post by Chrill »

My new hobby:

Hiphop groups reacting to heavy metal:
https://youtu.be/RLsYHpaKfXY
Image
My Scenarios:
Archipiélago Hermoso (Latest Release: Version 3.2)
Turnpike Falls (Latest Release: Version 0.91)
User avatar
Redirect Left
Tycoon
Tycoon
Posts: 7238
Joined: 22 Jan 2005 19:31
Location: Wakefield, West Yorkshire

Re: The Thread Of Randomness

Post by Redirect Left »

Forgot to pay the internet bill. Got to use mobile data tethered to my PC until Friday.

Painful.
Image
Need some good tested AI? - Unofficial AI Tester, list of good stuff & thread is here.
User avatar
orudge
Administrator
Administrator
Posts: 25134
Joined: 26 Jan 2001 20:18
Skype: orudge
Location: Banchory, UK
Contact:

Re: The Thread Of Randomness

Post by orudge »

I get the feeling we may have had this conversation before, but is there a reason your broadband payments aren't made by direct debit? As far as I'm aware a fair number of ISPs don't offer payment by any means other than direct debit.
User avatar
Redirect Left
Tycoon
Tycoon
Posts: 7238
Joined: 22 Jan 2005 19:31
Location: Wakefield, West Yorkshire

Re: The Thread Of Randomness

Post by Redirect Left »

I've had bad experiences with DDs, excess payments or payments being duplicated. Another reason is you have more sway with support when you've not paid yet. They're a lot more eager to please when they haven't got their money yet.

Sky & Virgin are the only ISPs i've been with, and both allow you to pay online (or over the phone) as & when.
Image
Need some good tested AI? - Unofficial AI Tester, list of good stuff & thread is here.
User avatar
Chrill
Moderator
Moderator
Posts: 15974
Joined: 18 Dec 2004 17:35
Location: Stockholm, Sweden
Contact:

Re: The Thread Of Randomness

Post by Chrill »

Well, today at work we're all dressed up for Halloween. I went for the scariest costume I could think of.
Attachments
Snapchat-1508992692.jpg
(406.14 KiB) Not downloaded yet
Image
My Scenarios:
Archipiélago Hermoso (Latest Release: Version 3.2)
Turnpike Falls (Latest Release: Version 0.91)
Transportman
Tycoon
Tycoon
Posts: 2781
Joined: 22 Feb 2011 18:34

Re: The Thread Of Randomness

Post by Transportman »

Chrill wrote:Well, today at work we're all dressed up for Halloween. I went for the scariest costume I could think of.
I always go as myself, that's scary enough.
Coder of the Dutch Trackset | Development support for the Dutch Trainset | Coder of the 2cc TrainsInNML
TheDOSManiac
Engineer
Engineer
Posts: 3
Joined: 28 Oct 2017 08:06
Skype: No.
Location: District 12

Re: The Thread Of Randomness

Post by TheDOSManiac »

:bow: :mrgreen: :arrow: :evil: 8)

Is that random enough?
User avatar
SkeedR
Tycoon
Tycoon
Posts: 2264
Joined: 11 Jul 2004 14:55
Location: West Midlands
Contact:

Re: The Thread Of Randomness

Post by SkeedR »

TheDOSManiac wrote::bow::mrgreen::arrow::evil:8)

Is that random enough?
The point of the topic isn't to be random, it is to collect posts that would otherwise stand alone as their own topic into a mega-thread about all sorts of topics.

I still can't get my head around how this thread has grown. I wasn't even trying to create something that would become a staple...
Last known as: Weirdy
User avatar
Zakos
Tycoon
Tycoon
Posts: 3977
Joined: 15 Mar 2012 02:48
Location: in my mum's car
Contact:

Re: The Thread Of Randomness

Post by Zakos »

You underestimate the popularity of a pseudo-Facebook feed. I'm more than happy to dump my junk thoughts on here.
User avatar
TimeLapse1357
Traffic Manager
Traffic Manager
Posts: 132
Joined: 10 Mar 2015 07:13
Location: Southern California

Re: The Thread Of Randomness

Post by TimeLapse1357 »

back in the ancient times before the internet, when every one used dialup modems and call forwarding, there were BBS's. And most of them had a "sub" for miscellaneous or random stuff. That sub would always be one of the most active.
User avatar
YNM
Tycoon
Tycoon
Posts: 3570
Joined: 22 Mar 2012 11:10
Location: West Java

Re: The Thread Of Randomness

Post by YNM »

YNM = yoursNotMine - Don't get it ?
「ヨーッスノットマイン」もと申します。
Post Reply

Return to “Off-Topic”

Who is online

Users browsing this forum: Amazon [Bot], Bing [Bot] and 9 guests