Excel Help

MaliA · **Posted:** Thu Aug 06, 2015 10:27

Grim... wrote:

Just open a new instance of Excel, either by holding shift down while you open it, or by clicking on it with the middle mouse button (sometimes).

Lovely, thank you.

Bamba · **Joined:** 25th Jul, 2010 **Posts:** 11128

Grim... wrote:

Just open a new instance of Excel, either by holding shift down while you open it, or by clicking on it with the middle mouse button (sometimes).

I can do this just by launching Excel twice from the Start Menu, though I'm on Office 2010 in case that makes a difference.

Kern · **Posted:** Thu Aug 06, 2015 10:33

It's sometimes easy to get confused over whether a sheet is open in the same session or not. I found that some tools won't work across different instances of the program when trying to share data/formuale.

Grim... · **Posted:** Thu Aug 06, 2015 10:34

Bamba wrote:

Grim... wrote:

Just open a new instance of Excel, either by holding shift down while you open it, or by clicking on it with the middle mouse button (sometimes).

I can do this just by launching Excel twice from the Start Menu, though I'm on Office 2010 in case that makes a difference.

It does indeed.

sdg · **Posted:** Mon Sep 28, 2015 16:39

Help please!

I have a sheet with list of products by product code which run on a particular production line. I have another sheet with the full list of products we make on site, with columns of components associated with each product.

How do I sort the second sheet to only show me the products on the first sheet?

Grim... · **Posted:** Mon Sep 28, 2015 16:42

Simplest is probably something like:

Code:

=IF(COUNTIF(Sheet1!A:A,Sheet2!A1)=0,"No","Yes")

Will show you if whatever is in A1 on Sheet 2 exists in the column A of Sheet 1. Then you filter by the Yes/No column.

sdg · **Posted:** Mon Sep 28, 2015 16:49

I'm not sure what's not worked about that but it says yes for the first two rows then says no for all others. I should have 115 matches.

sdg · **Posted:** Mon Sep 28, 2015 16:51

I'm an idiot. Ignore me. I think that worked and now I love you.

Grim... · **Posted:** Mon Sep 28, 2015 16:51

What the fuck was wrong with me before?!

sdg · **Posted:** Mon Sep 28, 2015 17:01

Grim... wrote:

What the fuck was wrong with me before?!

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

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:** 38460

You're A1

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

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:** 25586

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:** 38460

The mac office suite is (subjectively) awful.

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

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