Пікірлер

• 
  @JobaerAhmed-fd9hg8 сағат бұрын

  Thank you so much. It’s just awesome! 🙂

• 
  @esiahidayah9531Күн бұрын

  dengan rumus yang sama, di excel saya menampilkan eror, tidak berfungsi. ada yang bisa menjelaskan?

• 
  @sikhoji83192 күн бұрын

  tnx

• 
  @StanleyWalter-hj2kg2 күн бұрын

  Just FYI. For this to work you need to save your Excel file as a macro-enabled file! Otherwise this won't work.

• 
  @glydell74473 күн бұрын

  HI! IS THERE A WAY TO ADD SCREENTIP TO THE SHAPE THAT HAS ASSIGNED MACROS ALREADY?

• 
  @kromeface49764 күн бұрын

  I'm glad Bane took the time to show us this, very thoughtful of him.

• 
  @gpatni20094 күн бұрын

  macro file not available or disable, please guide

• 
  @dandan71914 күн бұрын

  How can you keep undo button with macro

• 
  @osoriomatucurane95114 күн бұрын

  Awesome tutorial on querying a dataset with multiple criteria. I now realize that slicing and filtering are interchangeable in Excel, subsetting the dataset based on a criteria. Slicing is more effective for categorical fields, while filtering is more flexible allowing more logic operators (less than, great than, not igual, and, or,..., contains, between). Here is the interesting fact with alternative data analysis tools. With R and Python, slicing and filtering are approached differently. Now back to Filters in Excel, and inspired by another Teach Excel tutorial on filtering dates based on period, how intricate or hard could be to have a helper column (periods) with categories (this month, last month, this year, last year and YTD) and then insert a slicer. I mean approching the selection of period based on slicer, instead of a drop down list selection, filter(), helper setting with start, ends and vlookup().

• 
  @Melki4 күн бұрын

  Terima kasih.

• 
  @JamesDurrett5 күн бұрын

  I get a RunTime Error 9 Subscript out of range error with this code. Cant seem to make it work. My work still have Excel 2007 so...

• 
  @rahulpatil33095 күн бұрын

  Alt +enter

• 
  @Imtiaz-Hussain-Vighio5 күн бұрын

  Bro! your voice is irritating its all base not sound lol

• 
  @slipmod74437 күн бұрын

  LOVE THIS! THANK YOU SO MUCH!

• 
  @khurrumsandhu7 күн бұрын

  after the video, I subscribed

• 
  @qww7608 күн бұрын

  Excellent explanation. Thank you :)

• 
  @Rogue_Console8 күн бұрын

  Thank you for this.

• 
  @securityinvestigator20958 күн бұрын

  What if I want the max value in the list for a product and not the value in the end of the list

• 
  @preechachomphoonimit35149 күн бұрын

  2024 here! helped me a lot 😅

• 
  @explite9 күн бұрын

  Thank you

• 
  @rf820910 күн бұрын

  Thanks you, helped me a lot 🙏 !!

• 
  @mariateresabuenavista856011 күн бұрын

  Very helpful, just when I needed it. Many thanks!

• 
  @sanchiamortimer11 күн бұрын

  brilliant - thank you for explaining this so clearly.. all the other videos make it so complicated

• 
  @emilypattr12 күн бұрын

  This worked perfectly! I see that you don’t do much in power query, but do you know how to do this in power query? My dataset is too big to have the formula in excel.

• 
  @daronholmes219913 күн бұрын

  is there a way to do this for excel on macbook? I have tried installing this way but it does not work on my mac. It worked when i did it on a windows computer and it worked which is why i'm asking if there is another way to get it to work on macbook..

• 
  @aeryncoble481114 күн бұрын

  A lot of assumptions and pre-work to follow along making this less useful than advertised.

• 
  @jessierobinson148915 күн бұрын

  PERFECT! Thank you.

• 
  @shriharibhat665515 күн бұрын

  Thank You for the informative video. I would just like to know how we can transfer range of values. I tried inserting the range in the inverted commas, but it is taking only value of the 1'st mentioned cell. If anyone could please help me with it would be great help. Thanks Anyways :)

• 
  @justinemiano470115 күн бұрын

  Very helpful video! Exactly what I needed. On a separate note, how can we automatically clear the dates if the data are deleted? When I delete the row of data corresponding to the dates, the dates don't disappear automatically, so I have to delete them individually. Could you make a video about this? Thank you!

• 
  @hero-hf5pu17 күн бұрын

  best video

• 
  @nickhayes755117 күн бұрын

  Brilliant video. I swear I have learnt more from Google and KZread than school ever taught me :)

• 
  @nobody-eu7kd17 күн бұрын

  This is most wrost video ever....we can easily extract using text after and text before.

• 
  @kishorburiuly231618 күн бұрын

  Please sir provide me

• 
  @ashasony80618 күн бұрын

  Thank you for the helpful video

• 
  @NadiaAtsarina18 күн бұрын

  makasih banyak Om !

• 
  @telimawokoma45618 күн бұрын

  Thank you

• 
  @JAYSONFERANIL18 күн бұрын

  how about specific date?

• 
  @HaivyGraceBalili18 күн бұрын

  what are the difference between aggregate and subtotal? seems look the same function as you illustrated.

• 
  @teenu678219 күн бұрын

  Thank you , saved me bunch of time expanding those

• 
  @osoriomatucurane951119 күн бұрын

  Awesome tutorial, how to get the formula fully dynamic, by replacing the *G10* with a fórmula to return 1, 2, 3, ......

• 
  @adityasaha273820 күн бұрын

  Thanks after 14 years!! It helps❤

• 
  @asomya8720 күн бұрын

  It was interesting! Just started learning VBA for data analytics. Thank you!

• 
  @MrAsad00720 күн бұрын

  table la eppadi =SEQUENCE(COUNTA(C:C)-1) varamattuthu

• 
  @kemaltalen979120 күн бұрын

  Thank you for this video! This was exactly what I was looking for. Have you found a workaround for the slicer timeline not having the feature for 'disable resizing and moving'?

• 
  @_Mrbuttersworth22 күн бұрын

  This literally saved me at least an hour of work manually sifting through sheets. You are a life saver!

• 
  @tacticaltortle887422 күн бұрын

  IT WAS THAT EASY???

• 
  @jeffanderson674023 күн бұрын

  Does all of the data import as text?

• 
  @bigpapa11299824 күн бұрын

  This code is great thank you. Do you by any chance know how to monitor a Cell that is linked to a dropdown control value? I have a dropdown that is populating a cell with the number of the choice. but this is not currently updating in the Table. The value changes in the table but it does not cause the event to fire off. There are other cells that take a manual input. when that occurs the msgbox fires off.

• 
  @rudycarv219724 күн бұрын

  I had this issue today, I was trying to get a value by doing Vlookup but it was not returning price $ value I was looking. Because the code I was searching was stored as number so we had to put ' in front on the number to be stored as Text. Now how would I to add ' in front of a number in over 300 rows?

• 
  @sumardjo24 күн бұрын

  Thanks to sample file I Have follow to video with your sample file thanks very much