trickery.net  

Go Back   trickery.net > General > Discussion

Reply
 
Thread Tools
Old 28-Apr-2016, 14:53   #181
Inertiaman
Join Date: Oct 2003
Posts: 39,934
Inertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond repute
Close it! Scratch it! Got it!

Muchos gracias.
__________________
Quote:
Originally Posted by Karmic
what you say doesn't count for shit because you rely on quotes from websites that are obviously biased
Inertiaman is offline  
Reply With Quote
Old 28-Apr-2016, 14:54   #182
NWA
Fish Schnapps
NWA's Avatar
Join Date: Oct 2003
Location: Harrow
Posts: 14,279
NWA has a reputation beyond reputeNWA has a reputation beyond reputeNWA has a reputation beyond reputeNWA has a reputation beyond reputeNWA has a reputation beyond reputeNWA has a reputation beyond reputeNWA has a reputation beyond reputeNWA has a reputation beyond reputeNWA has a reputation beyond reputeNWA has a reputation beyond reputeNWA has a reputation beyond repute
i.e. you want no record left where there are/were multiples - you are looking for values that were only ever unique?

https://support.office.com/en-us/art..._unique_values

This might work? Not sure, though not tried to do this myself.
__________________
Home is where the bandwidth is.

Quote:
Originally Posted by CryBaby
If Rooney kicks a ball at the World Cup then I will eat my underpants
NWA is offline  
Send a message via ICQ to NWA Send a message via MSN to NWA
Reply With Quote
Old 28-Apr-2016, 14:55   #183
Inertiaman
Join Date: Oct 2003
Posts: 39,934
Inertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond repute
Yeah after some faff - filtering sorted the concatenated values.
__________________
Quote:
Originally Posted by Karmic
what you say doesn't count for shit because you rely on quotes from websites that are obviously biased
Inertiaman is offline  
Reply With Quote
Old 19-Jul-2017, 16:39   #184
The Big Kahuna
**** off Lester
The Big Kahuna's Avatar
Join Date: Oct 2003
Location: Chesterfield
Posts: 18,606
The Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond repute
Right, I want to add a notes field to a cell, or the cells in a column in Excel. Something like clicking on a cell and having it pop out a big notes field. We use Office 2013 and Excel online. It's just to keep a quick record of shit that we need to do in IT.
__________________
If a Les Paul falls out of a tree in the forest, and nobody is there to hear it, does it still sound overpriced?
The Big Kahuna is offline  
 Niq-Scott 
Reply With Quote
Old 19-Jul-2017, 16:45   #185
Inertiaman
Join Date: Oct 2003
Posts: 39,934
Inertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond repute
Don't use comments in cells, they scale really badly if the notes are lengthy. a column is the least shit way of doing that. Out of interest, do you use Office365 and if so which tier?
__________________
Quote:
Originally Posted by Karmic
what you say doesn't count for shit because you rely on quotes from websites that are obviously biased
Inertiaman is offline  
Reply With Quote
Old 19-Jul-2017, 16:47   #186
The Big Kahuna
**** off Lester
The Big Kahuna's Avatar
Join Date: Oct 2003
Location: Chesterfield
Posts: 18,606
The Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond repute
"yes" and "what do you mean by tier?"
__________________
If a Les Paul falls out of a tree in the forest, and nobody is there to hear it, does it still sound overpriced?
The Big Kahuna is offline  
 Niq-Scott 
Reply With Quote
Old 19-Jul-2017, 16:53   #187
The Big Kahuna
**** off Lester
The Big Kahuna's Avatar
Join Date: Oct 2003
Location: Chesterfield
Posts: 18,606
The Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond repute
Unless you mean Business Premium, in which case, it's that one.
__________________
If a Les Paul falls out of a tree in the forest, and nobody is there to hear it, does it still sound overpriced?
The Big Kahuna is offline  
 Niq-Scott 
Reply With Quote
Old 19-Jul-2017, 17:39   #188
Inertiaman
Join Date: Oct 2003
Posts: 39,934
Inertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond repute
Because this sort of thing can be quite neatly handled and shared with with forms/access/sharepoint.
__________________
Quote:
Originally Posted by Karmic
what you say doesn't count for shit because you rely on quotes from websites that are obviously biased
Inertiaman is offline  
Reply With Quote
Old 19-Jul-2017, 17:47   #189
The Big Kahuna
**** off Lester
The Big Kahuna's Avatar
Join Date: Oct 2003
Location: Chesterfield
Posts: 18,606
The Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond repute
It was just something quick and simple for me & the other dude to to make a list of shit we have to do, and assign priority, assign to one or the other or both of us, and enter a simple one word status. Just wanted a short field for notes, but didn't just want to type into a cell.
__________________
If a Les Paul falls out of a tree in the forest, and nobody is there to hear it, does it still sound overpriced?
The Big Kahuna is offline  
 Niq-Scott 
Reply With Quote
Old 19-Jul-2017, 17:50   #190
Inertiaman
Join Date: Oct 2003
Posts: 39,934
Inertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond reputeInertiaman has a reputation beyond repute
Oh right well forget Excel and use Microsoft Planner. You already have it on your package. It's super awesome, works on desktop, tablet and mobile and is literally made for that requirement.
__________________
Quote:
Originally Posted by Karmic
what you say doesn't count for shit because you rely on quotes from websites that are obviously biased
Inertiaman is offline  
Reply With Quote
Old 19-Jul-2017, 18:04   #191
The Big Kahuna
**** off Lester
The Big Kahuna's Avatar
Join Date: Oct 2003
Location: Chesterfield
Posts: 18,606
The Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond reputeThe Big Kahuna has a reputation beyond repute
Cheers, I'll check it out.
__________________
If a Les Paul falls out of a tree in the forest, and nobody is there to hear it, does it still sound overpriced?
The Big Kahuna is offline  
 Niq-Scott 
Reply With Quote
Old 16-Mar-2018, 12:46   #192
Lungboy
Roboplegic Wrongcock
Lungboy's Avatar
Join Date: Oct 2003
Posts: 15,800
Lungboy has a reputation beyond reputeLungboy has a reputation beyond reputeLungboy has a reputation beyond reputeLungboy has a reputation beyond reputeLungboy has a reputation beyond reputeLungboy has a reputation beyond reputeLungboy has a reputation beyond reputeLungboy has a reputation beyond reputeLungboy has a reputation beyond reputeLungboy has a reputation beyond reputeLungboy has a reputation beyond repute
Can excel calculate the area under a curve when the y axis is using reversed values? I'm using =(C2+C3)/2*(B3-B2) but that's giving me - values and I'm not convinced by the numbers.

e: also, how do you "fix" excel's inability to turn minusing a minus into a positive? I've forgotten.
__________________
Please use my link for ordering Giffgaff simcards!

Last edited by Lungboy; 16-Mar-2018 at 13:19.
Lungboy is offline   Reply With Quote
Old 16-Mar-2018, 17:31   #193
NWA
Fish Schnapps
NWA's Avatar
Join Date: Oct 2003
Location: Harrow
Posts: 14,279
NWA has a reputation beyond reputeNWA has a reputation beyond reputeNWA has a reputation beyond reputeNWA has a reputation beyond reputeNWA has a reputation beyond reputeNWA has a reputation beyond reputeNWA has a reputation beyond reputeNWA has a reputation beyond reputeNWA has a reputation beyond reputeNWA has a reputation beyond reputeNWA has a reputation beyond repute
I think liberal and excessive use of brackets fixes the minusing a minus
__________________
Home is where the bandwidth is.

Quote:
Originally Posted by CryBaby
If Rooney kicks a ball at the World Cup then I will eat my underpants
NWA is offline  
Send a message via ICQ to NWA Send a message via MSN to NWA
Reply With Quote
Old 18-Mar-2018, 21:26   #194
Q-Target
AKA QuebecTango
Q-Target's Avatar
Join Date: Oct 2003
Location: Not Brighton
Posts: 36,946
Q-Target has a reputation beyond reputeQ-Target has a reputation beyond reputeQ-Target has a reputation beyond reputeQ-Target has a reputation beyond reputeQ-Target has a reputation beyond reputeQ-Target has a reputation beyond reputeQ-Target has a reputation beyond reputeQ-Target has a reputation beyond reputeQ-Target has a reputation beyond reputeQ-Target has a reputation beyond reputeQ-Target has a reputation beyond repute
The ABS() function returns a positive result regardless of whether it is positive or negative. It gives the distance from zero. That?
Q-Target is offline  
Reply With Quote
Reply

Go Back   trickery.net > General > Discussion

Tags
excel solutions

Similar Threads
Thread Thread Starter Forum Replies Last Post
The Perpetual Thread of Rant! Bilb Discussion 24329 17-Oct-2018 17:41
The Perpetual Thread of Praise! ReichSteadyCrew Discussion 13745 02-Oct-2018 12:08
Perpetual thread of "An interesting/bizarre thing I saw today" Q-Target Discussion 32 17-Aug-2008 23:44
Thread for n00b questions with simple answers Q-Target Software & Security 33 23-Dec-2007 12:35
BF2 FAQ / Questions Thread? andy Battlefield Series 9 14-Jun-2005 20:24

Users Viewing Thread: 1 (0 members and 1 guests)
 

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:01.


Powered by vBulletin® Version 3.7.0 Release Candidate 3
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2003 - 2013, trickery.net