Be Excellent To Each Other https://www.beexcellenttoeachother.com/forum/ |
|
Excel Help https://www.beexcellenttoeachother.com/forum/viewtopic.php?f=3&t=9857 |
Page 2 of 2 |
Author: | DavPaz [ Tue Sep 29, 2015 7:37 ] |
Post subject: | Re: Excel Help |
Grim... wrote: What the fuck was wrong with me before?! Nothing, but now you're excel-lent |
Author: | Grim... [ Tue Sep 29, 2015 7:41 ] |
Post subject: | Re: Excel Help |
I have the formula for success! |
Author: | DavPaz [ Tue Sep 29, 2015 9:45 ] |
Post subject: | Re: Excel Help |
You're A1 |
Author: | Satsuma [ Thu Nov 05, 2015 10:49 ] |
Post subject: | Re: Excel Help |
I'll just hung this in here as it has the word Excel in the thread title. I don't know if anyone saw or is even remotely interested in this but the Microsoft Excel team did an AMA on Reddit. https://www.reddit.com/r/IAmA/comments/ ... g/.compact |
Author: | Grim... [ Thu Nov 05, 2015 11:09 ] |
Post subject: | Re: Excel Help |
Gah, compact view makes my eyes melt! |
Author: | Grim... [ Thu Nov 05, 2015 11:11 ] |
Post subject: | Re: Excel Help |
[–]mdcsd 119 points 15 hours ago Do you guys ever fight with the Word or PowerPoint guys? [–]MicrosoftExcelTeam [S] 822 points 15 hours ago Sometimes but they tend to be verbose and have no data to support their position. |
Author: | Cras [ Thu Nov 05, 2015 11:25 ] |
Post subject: | Re: Excel Help |
Ha! Brilliant. |
Author: | Cras [ Thu Nov 05, 2015 11:28 ] |
Post subject: | Re: Excel Help |
Quote: What does your accounting department think of your work?
MicrosoftExcelTeam[S] 714 points 16 hours ago Our finance guys are big users of Excel and periodically come by to show us the cool stuff they've done. - Howie genuinecve 1004 points 15 hours ago Is that like being a parent and having your kid show you a finger painting and acting like it was done by Van Gogh? ThouArtNaught 544 points 14 hours ago I like to believe they print out their spreadsheets and stick them on the office fridge. |
Author: | Mimi [ Thu Nov 05, 2015 12:17 ] |
Post subject: | Re: Excel Help |
Hahaha! That's brill. Incidentally, I moved up to Excel 2016 and it is lovely. I think I had 2013 at work, but only (Mac) 2008 at home, and 2008 was evil. I hated using it. 2016 is pretty pretty. |
Author: | DavPaz [ Thu Nov 05, 2015 12:53 ] |
Post subject: | Re: Excel Help |
The mac office suite is (subjectively) awful. |
Author: | Mimi [ Thu Nov 05, 2015 13:04 ] |
Post subject: | Re: Excel Help |
Well, I guess that depends on the version you are using. The Office 2016 suite I have now is Mac, and I think it's much nicer than the 2013(? - Russell?) that we have at work (PC version). |
Author: | Kern [ Thu Jan 14, 2016 15:29 ] |
Post subject: | Re: Excel Help |
Today I learnt about =BAHTTEXT(number) which converts numbers to Thai and adds 'baht'. This now replaces =ROMAN(number) as my favourite formula. |
Author: | Bobbyaro [ Mon Jan 09, 2017 15:17 ] |
Post subject: | Re: Excel Help |
What does the {4;5} do in this formula? {=IF(C8="Job complete",(D8+E8)-SUM(VLOOKUP(B8&" - Job assigned/passed",$A$1:$E$70,{4;5},0)),"")} |
Author: | Mr Russell [ Mon Jan 09, 2017 15:18 ] |
Post subject: | Re: Excel Help |
It's a reference to an array of cells instead of a single cell? |
Author: | Mr Russell [ Mon Jan 09, 2017 15:20 ] |
Post subject: | Re: Excel Help |
Because it's supposed to be the column number in the range containing the return value you want, I guess you are wanting two values back as part of this array formula, and so it is returning two columns back. |
Page 2 of 2 | All times are UTC [ DST ] |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |