Excel Help

DavPaz · **Joined:** 27th Jun, 2008 **Posts:** 38464

Grim... wrote:

What the fuck was wrong with me before?!

Nothing, but now you're excel-lent

Grim... · **Posted:** Tue Sep 29, 2015 7:41

I have the formula for success!

DavPaz · **Joined:** 27th Jun, 2008 **Posts:** 38464

You're A1

Satsuma · **Joined:** 20th Apr, 2008 **Posts:** 14358

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

Grim... · **Posted:** Thu Nov 05, 2015 11:09

Gah, compact view makes my eyes melt!

Grim... · **Posted:** Thu Nov 05, 2015 11:11

[–]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.

Cras · **Joined:** 30th Mar, 2008 **Posts:** 49232

Ha! Brilliant.

Cras · **Joined:** 30th Mar, 2008 **Posts:** 49232

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.

Mimi · **Joined:** 27th Mar, 2008 **Posts:** 25594

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.

DavPaz · **Joined:** 27th Jun, 2008 **Posts:** 38464

The mac office suite is (subjectively) awful.

Mimi · **Joined:** 27th Mar, 2008 **Posts:** 25594

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).

Kern · **Posted:** Thu Jan 14, 2016 15:29

Today I learnt about =BAHTTEXT(number) which converts numbers to Thai and adds 'baht'. This now replaces =ROMAN(number) as my favourite formula.

Bobbyaro · **Joined:** 18th Apr, 2008 **Posts:** 11843

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)),"")}

Mr Russell · **Joined:** 6th Apr, 2008 **Posts:** 12243

It's a reference to an array of cells instead of a single cell?

Mr Russell · **Joined:** 6th Apr, 2008 **Posts:** 12243

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.

Be Excellent To Each Other

Excel Help

Who is online