-
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
- 1036801
- Messages
- 5.2M
Questions in Other Languages
Ask any Excel questions in your native language (questions in languages other than English only, please).
- Threads
- 1662
- Messages
- 7.1K
Power BI
Business Intelligence Tools: Power Pivot, Power View, Power Query, DAX Formulas
- Threads
- 6916
- Messages
- 28.3K
Microsoft Access
Questions about Access.
- Threads
- 32761
- Messages
- 148.5K
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
- 7338
- Messages
- 29.1K
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
- 2544
- Messages
- 14.3K
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
- 35
- Messages
- 197
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
- 15
- Messages
- 37
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
- Threads
- 2122
- 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
- 2
- Messages
- 6
Subscribe on YouTube
Watch MrExcel Video
Forum statistics
Share this page
Some videos you may like
This Week's Hot Topics
-
Try to use Index and Match Function
- Started by Darren Smith
- Replies: 35
Trying to use index match function this code all looks right? But will not enter the value into the correct cell on the Destination sheet... -
INDEX MATCH to return column header based on empty value in row
- Started by NikToo
- Replies: 28
I feel I'm almost there with this but not quite getting it right. I have a list of product numbers, dates across the columns, and a number in the... -
Please help before the Wife kills me
- Started by Greg92
- Replies: 32
A month of trying but I can't solve this so please help me!!! I have a sheet for sports trading, within this sheet I have prices for the first 3... -
Scan 8 adjacent cells
- Started by methody
- Replies: 26
Hi I have a range with 200 cells -20 row and 10 columns. Each cell is either blank or has a unique number in the cell. Moving across each row... -
SUMIFS help if there is a + sign
- Started by K0st4din
- Replies: 35
Hello, everyone, I ask for your help to correct the formula, because I have a condition that is a little different and that's where my problem... -
Formula =R[-1]C-RC[-1] by vba subtracting gives error
- Started by MKLAQ
- Replies: 24
hello experts I need help about this formula I have this data but when I run it gives me error I try modified but I...
We've detected that you are using an adblocker.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back