for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers

GlennR Mar 2020 12:53pm, 4 Mar 2020 47,951 posts	Quote Pin GlennR I can imagine.
um Mar 2020 12:56pm, 4 Mar 2020 1,813 posts	Quote Pin um Monitors are quite cheap Greg! Would be lost without mine. But I have tried Glenn's clipboard thing, and it works easily. Multiple cell selections as well. You can turn it off and on (clipboard icon in home page), so it only consumes real estate while you want to use it. Any previous copies (even with the display off) are still there.
um Mar 2020 12:58pm, 4 Mar 2020 1,814 posts	Quote Pin um And more - playing with it, I 've found you can move it round the screen as a 'sub window', so you can position it or dynamially move it to the least interesting part of the spreadsheet / screen.
GregP Mar 2020 8:06am, 14 Mar 2020 118,825 posts	Quote Pin GregP This made me smile, and slightly nostalgic. medium.com
Lizzie W Mar 2020 8:14am, 14 Mar 2020 22,469 posts	Quote Pin Lizzie W // I am not sure if we need this, but too scared to delete.
Markymarkmark Mar 2020 8:30am, 14 Mar 2020 10,857 posts	Quote Pin Markymarkmark //I am not sure why this works but it fixes the problem.
FRU (KeepTheFaith) Apr 2020 10:41am, 27 Apr 2020 12,594 posts	Quote Pin FRU (KeepTheFaith) Hi - I need your brains I have a challenge... I am working on a new call report... so I have the complete 7 days data which shows all calls and where they end... I have a column that shows time and date of call, and what I need to do is - Show calls ONLY 8:30am to 5pm on Monday to Friday only I am confused I can do this a few ways, but very long winded, and a colleague set up a framework that will work but man it is long winded too! So... brains of Fetchland can I - make a formula to just count IF the call was Monday to Friday 8:30am - 5pm OR - I have to create a lookup to work from the date and then show Monday to Friday - I have to move the time only to another coloumn - I have to then use another formula to pull out 8:30am to 5pm only I can email the data as it is not personal in any way just numbers and wont cross any breaches of security
GlennR Apr 2020 10:58am, 27 Apr 2020 49,381 posts	Quote Pin GlennR You should be able to do a single formula to do the check. Something on the lines of =IF(AND(TIME (blah blah), DAY(blah blah)),x,y) Sorry for the blahs, I’m not in front of a computer.
um Apr 2020 11:06am, 27 Apr 2020 2,218 posts	Quote Pin um blah blah blah ... Assuming date in A1 and time in B1 (FIND(TEXT(A1,"ddd"),"MonTueWedThurFri") will tell you if the date is mon-fri (B1>0.34)*(B7<0.729167) will tell you if between 8:30 and 17:30 (you may need to check the decimal for absolute precision on equals those times) Combine into one if statement for a one col check
FRU (KeepTheFaith) Apr 2020 11:07am, 27 Apr 2020 12,596 posts	Quote Pin FRU (KeepTheFaith) That's what I think too.. I might go back to basics with that - as ever the thing that the expert has created I now cant follow:-) Cant get my head round what he is trying to do.. thanks for that Any other suggestions very welcome