If you use Excel 40 hours a week (and those are the weeks you are on vacation), welcome to the MrExcel channel. Home to 2,400 free Excel tutorials. Bill "MrExcel" Jelen is the author of 67 books about Excel and host of MrExcel.com. I love hearing your Excel questions. Post a comment on any video and I can help. I love solving data problems in Excel. I am an Excel MVP since 2005. I write about Excel in Strategic Finance magazine. I've made 80 guest appearances on Leo Laporte's TechTV show. BBA '87 from Notre Dame, but I love all college football from the Big 10, Big 12, SEC, and ACC. I am a scouting member of Florida Citrus Sports. Rocket launch photographer. Subscribe and ring the bell to know the latest features in Excel.
For 24x7 help on Excel, post an XL2BB of your workbook in a new thread at www.mrexcel.com/board/forums/excel-questions.10/ The awesome community of Excel enthusiasts answer over 100,000 questions a year, for free.
Hi, I have followed 1488 and 1489 to create my daily logs for one month. I also have an extra sheet at the end for the end of month statistics called EOM. So on the EOM I have managed to get the consolidated information for day 1 of the month. The problem is that I cannot just drag that cell across so that it will inform me of each day's stats for the month. This is because it won't move the number 1 it just copies the number 1 and then I have to change the number to number 2 and then 3 and so on. This is very time-consuming. Do you know of a way that I can drag the cell so that it automatically changes the number from 1 to 2 and then 3 etc? This is driving me crazy. If you could help you would be bringing back a little sanity. TIA :)
F$%^%^&* Awesome!!!!! Why is the helper column necessary? I would think that excel could the unique values without the helper column, otherwise it fails the description of the function. Either, reconciliation is easier now
Hi Sir, I'm trying to use this method however after I save my work the photo was disappear on my cells and shows only #unknown!. How to fix it to be use as permanent in cell. thanks😟
Hi, I tried the aggregate function but after writing =aggregate, the drop down menu with the list of functions didn't appear, so I couldn't do it. I am using Excel on a Mac. Does that make a difference? Thanks.
I am getting the access denied error for some, not all CSV files in a directory. I modified the M code after the initial query was built to make use of a filepath parameter that I change when I want to load from different CSV files, all of which have the same format, but data for different date ranges. The macOS permissions are the same and it looks like after Excel loads them it adds the com.apple.quarantine attribute to them. I am at a loss as to what to do and would greatly appreciate any assistance. I tried running the one line of VBA code for the folder containing the CSV files, even though some were already accessible, but that did not help,with the files I am getting the access denied error for.
Wow. This is actually pretty incredible. I will try to play with it a bit to see how well it suits my needs. I really wish I knew how to build stuff like this just out of curiosity.
I have a different problem. If you know the answer, I'd appreciate your help. When I have an excel sheet open, I can click and drag to highlight several cells. Down at the bottom, right of the sheet it will say "Count" (the number of cells I highlighted) and "SUM" the sum of all the cells I highlighted. My problem is my eyes aren't as good as they used to be and the SUM isn't big enough/dark enough for me to see. Is there a way to change the font size, or at least make it darker, so I'll have an easier time? Thanks!
I am using Version 16.86 (24060916) with license purchased already, but on Macos don't have power query get data from folder, on Window they do have, how can I find this fixed, although using the method in video but still the same please share if you guys have the same issue :(((
I have the newest version of excel on an Apple MacBook and cannot figure out how to automatically add 2 decimal points. there is no advanced settings anymore
I don't usually submit comments to videos that I watch. I tried to find your email address, Mr. Excel, alas... Anyways, after failing all of your suggestions I finally figured out my specific issue of a line extending over 4 blank cells below my table. My table range needed correcting. I had originally included two cells to the right I thought I'd want to include in my table. Resetting my table range corrected the issue. I'm sorry if I am suggesting anything you covered that I might have missed.
I have been searching for this solution for years. I've been cheating by just using Google Sheets to do it, as it can do a fill series automagically even on filtered data. But Excel is not so easy. Thanks
If cell A1 has the number we're looking for in cell C3, which has a list of numbers separated by commas and/or spaces, how would we find it using a Regex? For example, if cell A1 has the number 1 and cell C3 has 1,5, 11, 18, then how do we find 1 and not 11 and 18? Something like find 1 (reference A1) when the characters before and after it are not numbers?
This. Thank you for this - it is amazing! I am stuck on the very last part, though. When combining my Excel files, I get a "[DataFormat.Error] File contains corrupted data." error message for every file. There are no passwords, and the folder/files are saved on my desktop. The files open properly when opening in Excel as usual. All of the headers are all the same and each files is formatted the same. Do you have any thoughts on this? Cheers!