Hi, I have a question about creating batch folders in file explorer using excel. Are there any way to prevent the system from auto arrange base on alphabet (for example I have 4 names: d a c b, now I want to create batch folders in the exact same order d-a-c-b not a-b-c-d). Thanks
Hi! Great video! Although when I'm following it along, in the bit of the "One or another but never both", my results are different. I get people working in London with a profit greater than 40k in my filtered results. Same formula you used.
Es hat sich für mich absolut rentiert ein weiteres Video zum Thema Filter-Funktion anzuschauen. Du erklärst sehr gut und strukturiert, alle möglichen Aspekte werden beschrieben. Vielen Dank und ich freue mich als neuer Abonnent auf Deine weiteren Beiträge.
Thank you for your help! I’ve tried various methods, including AGGREGATE, SUMIF, SUMPRODUCT, and SUBTOTAL, but I'm still having trouble updating the count correctly. ChatGPT game this formula =SUMPRODUCT(AGGREGATE(3, 5, (Z3:Z396="PLACED")*(SUBTOTAL(103, OFFSET(Z3, ROW(Z3:Z396)-MIN(ROW(Z3:Z396)), 0, 1))), 1)) It didn’t work either. I will do it manually.
Thank you for your reply! Yes, you are right but how can I count specific rows in column D without adjusting its filter, while filters are applied in columns A, B, and C? Column D shows two different row counts unless I filter it manually. I know this isn't a private tutorial, but this would be useful for anyone analysing data. Also, I want to commend you on the excellent courses you’ve provided online. I try to watch them all when I can.
Dear Madam/All, I am working on a table and need to find the total number of rows in a column using a function, such as SUBTOTAL, SUMIF or SUMPRODUCT with the filter applied. However, the functions only work when the filter is not in use. When I apply filters to different columns, the results don’t update accordingly. How can I get the total number of rows with the filter applied? I would greatly appreciate any help or advice on how to get the total number of rows with the filter applied. Thank you!
@@AntoF1 hello, you need to use SUBTOTAL with COUNT or COUNTA. In a cell somewhere type =SUBTOTAL(3,A1:A10) replace my cell refs with a column in the filtered table.
Thank you so much for the in-depth coverage of the FILTER function. You’ve got a new sub! The new feature of data validation automatically picking up the unique list of values is new to me and is indeed a very useful feature.
I've never seen someone explore the filter function in depth! Your explanation is brilliant. I recognized your voice and then I saw your name, you teach on another channel! Thank you very much!
Very clear video. When I use =getpivotdata( to refer to the target cell in a pivot table which is on another sheet of the same excel file. However it only shows the first two syntax i.e., field and pivot table. There are no subsequent [field1, item1], [field2, item2] for me to work with. How to understand this? thanks.
Mam i need multiple filter option but in pivot filter it shows all value very hard to select. For example country one filter second state filter third town filter.
Me encanta tu canal. Su explicación es bastante clara. Muchas Gracias desde Centroamérica. I love your channel. Your explanation is really clear even i'dont speak English, but your British accent is so clear. Tks so much. My favorite fuction is xlookup (buscarX), filter is also one of them
Great video! Filter has replaced most of the other functions I use. Definitely my #1 function! For the part Non - Adjacent Columns, an other way is to use the CHOOSECOLUMN function or create 3 separate filters for each column..
Thanks for the comment. Yes you could replace the first FILTER with CHOOSECOLS, if you have Excel 365. The function isn’t available in any other version :)
Thank you Deb, very clearly explained. I'd like to see more videos on Lambda as I see this as a very useful tool. Maybe in conjunction with Reduce/Scan functions!!!
This is so helpful - as I love excel but hate Word, lol. thank you. I learned lots, and have watched the whole video. But just tried to rewatch some of the later chapters, using the quick links, but nothing over an hour works. Sorry.
Question for you! If I have cells of a specific color that are in bultiple different rows and different columns, will this still work? or does it need to be a nice and neat column like your example in the video?
Great video. to make it even quicker you can separate each part of the name into multiple columns, to allow you to drag and copy, i.e. the main folder name then concatenate all the fields in a different cell. The concatenated cell is the one you select and copy into notepad. Hate retyping when I can copy.