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:  MaliA [ Thu Aug 06, 2015 10:27 ]
Post subject:  Re: Excel Help
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.
Author:  Bamba [ Thu Aug 06, 2015 10:29 ]
Post subject:  Re: Excel Help
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.
Author:  Kern [ Thu Aug 06, 2015 10:33 ]
Post subject:  Re: Excel Help
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.
Author:  Grim... [ Thu Aug 06, 2015 10:34 ]
Post subject:  Re: Excel Help
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.
Author:  sdg [ Mon Sep 28, 2015 16:39 ]
Post subject:  Re: Excel Help
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?
Author:  Grim... [ Mon Sep 28, 2015 16:42 ]
Post subject:  Re: Excel Help
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.
Author:  sdg [ Mon Sep 28, 2015 16:49 ]
Post subject:  Re: Excel Help
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.
Author:  sdg [ Mon Sep 28, 2015 16:51 ]
Post subject:  Re: Excel Help
I'm an idiot. Ignore me. I think that worked and now I love you.
Author:  Grim... [ Mon Sep 28, 2015 16:51 ]
Post subject:  Re: Excel Help
What the fuck was wrong with me before?!
Author:  sdg [ Mon Sep 28, 2015 17:01 ]
Post subject:  Re: Excel Help
Grim... wrote:
What the fuck was wrong with me before?!

:kiss:
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.

:D
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/