-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
Announcements
MrExcel Message Board FAQ & Help
FAQ, Rules & Guidelines, General Board Help
Question Forums
Excel Questions
All Excel/VBA questions - formulas, macros, pivot tables, general help, etc.
Please post to this forum in English only.
Do not post questions about other spreadsheet programs (e.g. Google Sheets) in this forum.
Do not post questions about other spreadsheet programs (e.g. Google Sheets) in this forum.
- Threads
- 1033685
- Messages
- 5.2M
Questions in Other Languages
Ask any Excel questions in your native language (questions in languages other than English only, please).
- Threads
- 1657
- Messages
- 7.1K
Power BI
Business Intelligence Tools: Power Pivot, Power View, Power Query, DAX Formulas
- Threads
- 6824
- Messages
- 28K
Microsoft Access
Questions about Access.
- Threads
- 32733
- Messages
- 148.3K
General Discussion & Other Applications
This forum is for discussion about any application & for questions about applications other than Excel or Access.
This is also the place to ask about other spreadsheet programs (e.g. Google Sheets), book suggestions, or other websites.
This is also the place to ask about other spreadsheet programs (e.g. Google Sheets), book suggestions, or other websites.
- Threads
- 7307
- Messages
- 29K
MrExcel Products
MrExcel's Products: Books, CDs, Podcasts
Discuss topics related to Holy Macro! Products: Learn Excel from MrExcel, VBA and Macros for Microsoft Excel,Holy Macro! It's 2500 VBA Examples CD, Guerilla Data Analysis Using Microsoft Excel and Excel Knowledge Base CD and the MrExcel Podcasts.
- Threads
- 574
- Messages
- 2K
Other Forums
About This Board
Discussion of policies, bug reports, how to use it, XL2BB questions, etc.
- Threads
- 2537
- Messages
- 14.2K
Excel Articles
Discussions about existing Excel Articles published in the forum. You can not start a new thread here. To contribute an article, click Excel Articles in the Top Nav Bar and then use the orange button on the right: Add Excel Article....
- Threads
- 33
- Messages
- 188
Excel LAMBDA Functions
Have you written a useful LAMBDA function that might be useful to others? Post it in the forum. The community can vote for their favorites and we'll suggest to the Excel developers ideas that could be added to the core Excel functions.
* Required to be an active member who has more than 50 posts to submit functions.
* Required to be an active member who has more than 50 posts to submit functions.
- Threads
- 10
- Messages
- 19
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
- Threads
- 2118
- Messages
- 2.1K
Hall of Fame Winners
An announce-only forum to spotlight classic message board solutions.
- Threads
- 14
- Messages
- 17
Test Here
Use this forum to test your signature, learn bbcode, smilies, etc.
Threads in this forum are automatically deleted after no replies for seven (7) days
Threads in this forum are automatically deleted after no replies for seven (7) days
- Threads
- 1
- Messages
- 1
Subscribe on YouTube
Watch MrExcel Video
Forum statistics
Share this page
Some videos you may like
This Week's Hot Topics
-
How to sum values of the year till 31/12 and reset to 0 on 1/1 for years running totals?
- Started by LRATOZ
- Replies: 38
Howdy, I have been recording rainfall data since 15/11/2015. I used to have mutiple sheets for each year but I've learned that it makes more sense... -
Auto filter between a range of dates
- Started by K1600
- Replies: 37
I am trying to apply a filter to a data set which is with an excel formatted table (Table8) but the first bit I need to do is only show data where... -
Formula to Display Sheet Name of Worksheet that Contains Max Value Across Multiple Sheets in Workbook
- Started by erino
- Replies: 36
I have created a workbook that is comparing my business transactions from year to year. Each year is represented by a worksheet (2020, 2019, 2018... -
date formula to determine amount of vacation weeks
- Started by bh24524
- Replies: 32
I am looking for help on a formula that will look up a given seniority date contained in cell C11. The formula would be in D11. I want it to... -
Inserting IF formula in complex index/match formula to get results until certain date
- Started by SteveNL86
- Replies: 28
Dear reader, I'm using this formula... -
Nesting INDEX MATCH into SUMIFS
- Started by lost_in_the_sauce
- Replies: 26
I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...