-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Office 365
- Thread starter Michael M
- Start date
Excel Facts
How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Michael M
Well-known Member
- Joined
- Oct 27, 2005
- Messages
- 21,835
- Office Version
- 365
- 2019
- 2013
- 2007
- Platform
- Windows
I undestand there is a version that does not have the developer tab and / or VBA
Michael M
Well-known Member
- Joined
- Oct 27, 2005
- Messages
- 21,835
- Office Version
- 365
- 2019
- 2013
- 2007
- Platform
- Windows
@RoryA
Apparently so.....maybe they only use Excel for doing simple calcs and Word for grocery lists...
I have dealt with a number of "salespeople" that glaze over if you mention VBA or macros.....The big computer retailers especially.
Having said that if your selling computers and your only 16 years old, it's to be expected !!
I have been directed to $3000 laptops because they have great graphics......"what, for Excel ?".....Yeah, I need that !!
Maybe I look stupid, 'cause I'm old !
Apparently so.....maybe they only use Excel for doing simple calcs and Word for grocery lists...
I have dealt with a number of "salespeople" that glaze over if you mention VBA or macros.....The big computer retailers especially.
Having said that if your selling computers and your only 16 years old, it's to be expected !!
I have been directed to $3000 laptops because they have great graphics......"what, for Excel ?".....Yeah, I need that !!
Maybe I look stupid, 'cause I'm old !
MARK858
MrExcel MVP
- Joined
- Nov 12, 2010
- Messages
- 16,167
- Office Version
- 365
- Platform
- Windows
- Mobile
Mine about 2 laptops back was going into a major Electrical/PC outlet. Having a spotty face kid come over and ask if he could help. I asked "What the clock speed was" and he responded with "Do you know where to find it?"
I'm hoping they have improved a bit.
I'm hoping they have improved a bit.
starl
Administrator
- Joined
- Aug 16, 2002
- Messages
- 6,081
- Office Version
- 365
- Platform
- Windows
I prefer to build my own PCs from scratch, though I do buy laptops from manufs. But I choose the (spendy) option where I can choose what I need in it..
When you buy a prebuilt PC, the Office 365 that's installed on it is usually not activated. You activate it yourself, choosing exactly which package you want at that time.
If I remember correctly...
Compare All Microsoft 365 Plans (Formerly Office 365) - Microsoft Store - shows you the different packages (table with checks if you scroll down)
O365 for business (not sure how this applies to home)
Understand subscriptions and licenses in Microsoft 365 for business - explains licensing with subscriptions - a must read! ONE person can install on up to 5 PCs/Macs, 5 tablets and 5 phones. They all share the same account. If you want different accounts, then you are looking at multiple licenses. But with my 1 license, I have legally installed it on 3 pcs, 2 laptops. I think my tablet might be activated, I don't remember.
When you buy a prebuilt PC, the Office 365 that's installed on it is usually not activated. You activate it yourself, choosing exactly which package you want at that time.
If I remember correctly...
Compare All Microsoft 365 Plans (Formerly Office 365) - Microsoft Store - shows you the different packages (table with checks if you scroll down)
O365 for business (not sure how this applies to home)
Understand subscriptions and licenses in Microsoft 365 for business - explains licensing with subscriptions - a must read! ONE person can install on up to 5 PCs/Macs, 5 tablets and 5 phones. They all share the same account. If you want different accounts, then you are looking at multiple licenses. But with my 1 license, I have legally installed it on 3 pcs, 2 laptops. I think my tablet might be activated, I don't remember.
