Microsoft Excel

136K

Solutions

38K

Contributors

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Share tech news, updates, or what's on your mind.

Sign up to Post

Attention all Article and Mini Video Tutorial Authors

One of our highly valued members and authors - Joe Winograd - has written a small program that any author at Experts Exchange should find highly useful. Links below:

Article: How to download number of Views, Endorsements, Points for Experts Exchange Articles and Videos

Video: How to download number of Views, Endorsements, Points for Experts Exchange Articles and Videos--Demo

Check them out and be sure to endorse one or both if you find it as useful as I have!

Regards, Andrew
2
C++ 11 Fundamentals
LVL 13
C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Great Micro Tutorial Video on how to create Drop Down Menus in Excel

View it here: Create Dropdown menus in Excel 2016

Just published and authored by: Thomas Zucker-Scharff

Enjoy...
0
Once upon a time at a core conference this happened. It is one of those amazing moments when Experts get intrigued by a fun puzzle to solve.

Do you have a favorite question or other piece of content like this?  Would you like to see us facilitate more items like this or have an idea that would make your time here more enjoyable? Let me know by commenting on this post or messaging me.
4
LVL 19

Expert Comment

by:Kyle Santos
TIL: AngelIII is not 'Angel 3' but Angel Eyes.
0
I am using Excel 2016
I am making a material inventory list which will also include the amounts required to produce each of our model types.
.
Column "F" is the current "quantity in stock" of every part in my inventory
Columns H, J, L and N are the amount of that material required to produce each unit type.
On my "asset list" tab I have a completed unit stock list. As each unit is serial numbered I am entering each unit on a separate line. There are columns for each unit type.
I am trying to make so when I enter the number 1 in any of those 4 columns on the "Asset list" that the amount of material required to produce (columns H, J, L and N) will be subtracted from column F (quantity in stock)

EXSPREADSHEET.png
0
LVL 30

Expert Comment

by:Tom Cieslik
Please ask question (not post)  if you need help from our community
0
1
Hello!

Here's the issue: I've got three columns of data: Individual, Amount Sold, Date Sold.

People have multiple sales for each given date.

I want to find each person's best night, i.e. all the sales for each given date combined for that date, and then I'd like to see the max for each individual, so I can show them their best night.

I can do this by creating a new sheet with three columns, one containing every date from 1/1/17 to 12/31/17, the next containing the name of a single person, and the third containing a SUMIF formula, so that I have the sum of each person's sales for each day, and then take the MAX from that column. I am sure, however, that there is a better way. A PivotTable seems to only give me the largest single sale from each individual, instead of the night with the largest sale.

What's the simpler solution here?
0
LVL 28

Expert Comment

by:Andrew Leniart
Hi Cory, welcome to Experts Exchange.

What you have done is made a post here. To get expert help, you need to "Ask a Question" so that more experts are able to see you need help. Click the Big blue button near the top of your screen.

Ask-a-Question.png

The following link explains more about asking for help at Experts Exchange..
http://support.experts-exchange.com/customer/portal/articles/336330
1
LVL 31

Expert Comment

by:Roy Cox
Hi Cory, you need to look at a PivotTable with dates grouped by day
0
what is the maximum number of cells microsoft office 2013 excel application supports
0
LVL 9

Expert Comment

by:James Bilous
1,048,576 rows by 16,384 columns = 17,179,869,184 cells
2
LVL 68

Expert Comment

by:Jim Horn
Microsoft publishes pages on Excel Specifications and Limitations for every new version that answers tons of questions like this.
1
10
Helen Feddema is one of our resident Microsoft Access experts.  She just published two new articles today.  If Access is something you're interested in knowing more about, then follow Helen!
https://www.experts-exchange.com/members/Helen_Feddema.html
2
New member today got a solution today.

After searching the net for help it became apparent that there were professional contributors on your site willing to provide expert advice. The advice given was very fast and first class.

Fred
This was their question that was answered.
https://www.experts-exchange.com/questions/29012797/Create-Dynamic-Range-Via-VBA.html
3

Microsoft Excel

136K

Solutions

38K

Contributors

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.