Видео

Thanks

I can't believe that a 14 year old video is helping me.

life saver

If you have carriage returns instead of commas, this worked for me in Excel for the Web =IFERROR(SUM(TEXTSPLIT(SUBSTITUTE(A1,CHAR(10),","),",")+0),0)

omg thank you!!! I love u

So..109 is a secret code? Where do I get these numbers from?

This is the way

Any idea what the performance is with SCAN? SCAN(0,A1:A10,LAMBDA(a,b,a+b))?

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!

Do I need to keep this line of code in the Excel indefinietely or can I just apply this once and remove it (to keep the Excel as XLSX, basically)

Terima kasih.

Works perfectly!!!! 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.

The only problem is the cell stays filled even when the value changes to higher

This just saved me so much time. Thank you for posting this!

Thank you!

Thank you exactly what i was looking for

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

It's been 6 years. is there a function or something else to do it without a macro (and not manually : )

(มหา)

โก๋กลัวตำรวจใช่ป่ะ

โก๋ไม่มีไรสบายดีเพื่อน

เอาหมด

So helpful thank you!

it display @NAME? and I am using microsoft 365 subscription

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?

But how to number them AFTER the filter is applied? I only get errors.

Awesome

Awesome👍

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!

Thank you sir!

ive done this a bunch on windows but still cannot figure out how to do it on Mac

Thanks very much for your help

Too complex a solution for a rather simple requirement!

Hi,Bill can you please suggest doing,how to rename worksheets of multiple files in a folder at once using VBA. Please respond.Thank you

Its code supported to excel 2007

THANK YOU

If I email this file to someone, will the connected data remain?

life saver, thanks for this content

Any ideas on to how highlight the column(s) "header" that has a filter applied? I don't need to see the values. I want to be able to quickly see visually (font or fill in a different color) when I scroll across the columns, that a column has a filter applied. Seeing a "tiny" filter icon on large spreadsheets that also may have been zoomed (ie 85%) is difficult.

TYSM!!!!!!!!!!!!

Thank you 💙 Can you please provide me the Power Query link version.

thank so much sir

Thanks fot this video and solution, I used to solved some similar problem. I was wondering if there is a solution for the same but in VBA? since in my case I need to identify this but for for thounsands of numbers and with formulas it takes some time and begins with "Calculating" message. Thanks Bill for MrExcel Forum where was the first place in internet that I geban to learn Excel several years ago.

in VBA, for the immidiate code, when I press ENTER, it just creates a line space. What can I do?

wow searching through hours of garbage videos and online explanations and no one knew how to do this. You are the man.

Thanks man. This is great!