Anders Sehlstedt
Eskilstuna, Sweden
VIP
Members
Trusted Members
Trusted Members
Forum Posts: 900
Member Since:
December 7, 2016
December 7, 2016
Offline
Frans Visser
Duivendrecht (near Amsterdam) - The Netherlands
VIP
Members
Forum Posts: 346
Member Since:
April 21, 2015
April 21, 2015
Offline
Hi Mohamed,
Can't help you with all three questions, but fixed the last one. @Anders: I think he is looking for formulas and that's why they can't be found in his sheet. The questions are in the sheet.
Mohamed: I splitted the cells back to normal in your columns I and J and put a MIN and MAX (with conditions, don't know how they are called in English, but you'll find them in the cells). That'll do.
There is a trick for your other two questions, I saw recently on Sumit Bansals website (Trump Excel), but can't remember how to do it. Maybe you can look yourself there, or somebody here helps you.
Good luck!
Frans
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Chris Ritcey, Daniel Robertson, Richard Hall, Tony Johlie, Ryan Tyree
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 287
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Molly King
Faraz Rafi
Anthony Blake
Jackb57
Ben Tooke
Kelsey Fennell
Jeffree Bunning
Jackie Memije
John Franzon
Darcie Clayton
Forum Stats:
Groups: 3
Forums: 24
Topics: 6873
Posts: 30124
Member Stats:
Guest Posters: 49
Members: 33673
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —