Пікірлер

• 
  @BeaverMonkey2 күн бұрын

  I didn't know this formula even existed!

• 
  @OfficeMystic2 күн бұрын

  It makes my other video look ridiculous.

• 
  @umwarihappy71856 күн бұрын

  👍👍❤️

• 
  @jrmike52918 күн бұрын

  Thank you men, it worked 😊

• 
  @TheQueb13 күн бұрын

  Worked perfectly! Is there a way to have it skip cells with no data?

• 
  @OfficeMystic10 күн бұрын

  Thanks for the question! I will have to make an updated video with a better formula. Follow the same steps, but use this formula instead: =FILTER(TOCOL(Data, 1), TOCOL(Data, 1) <> "") I have Excel 365, just in case you have a different version. I am returning to this channel now that I finished my degree. If you have any other questions, let me know.

• 
  @kathleenballantinewatson463418 күн бұрын

  Finally an answer I've been looking for two days. Thank you

• 
  @UtuDudas24 күн бұрын

  I have a strange situation in my excel, where I need to select the array for the lookup value, and the single value in the lookup array. I wonder why

• 
  @Indrastemcart25 күн бұрын

  if january and 2011 there, how to show in only one column ? thankyou

• 
  @luisenca1127 күн бұрын

  I was looking for this for quite a while. Great help!

• 
  @noshintasnimkhan345427 күн бұрын

  I don't have any special menu on find and replace

• 
  @marinasilva868928 күн бұрын

  Thanks mate, just what I needed!

• 
  @orangecountyhouseАй бұрын

  trying to do it on Google sheets and getting error message "array argument to xlook up are of a different size".

• 
  @praeniddАй бұрын

  thank you, this helped me removed almost all unwated blank pages

• 
  @Joda-es5xdАй бұрын

  Great video, wanted to know the difference of this approach to Boolean ? I deal with large data sets snd andand and more guidance on the approach. Thanks

• 
  @natsuudesu5069Ай бұрын

  This is what you call it "worth it",

• 
  @natsuudesu5069Ай бұрын

  Really thank you, master of word

• 
  @zeromeansnadaАй бұрын

  I needed to know how to do an XLOOKUP across two sheets and two conditions and watched countless videos that took forever to give the most complicated way to do XLOOKUP. I've now learned there are multiple ways to write these formulas that still follow the same general rules. The difference is you can go super complicated OR you can do it this way by Office Mystic. By far the most straight-forward explanation. A short video that gets straight to the point and easy to understand. WOW!! Thank you and Subscribed.

• 
  @elizabethacerra2598Ай бұрын

  Such a clear video and something I really needed. At my job we use Google Sheets, and excel is very slow on my computer. This formula returns an error in sheets "Array arguments to XLOOKUP are of different size." Any idea how to fix this?

• 
  @RAMESH_WARANАй бұрын

  Maaannn! straight to the point.

• 
  @evamariagarcia662 ай бұрын

  I followed exactly your instructions, it finds the section break and when I click on remove all it does absolutely nothing. I tried deleting them manually and nothing. There must be another way.

• 
  @evamariagarcia662 ай бұрын

  Ok, finally was able to delete the section break. I was working with tables and changing the text wrapping to none in table properties, allowed me to delete the section break.

• 
  @felicetapaganao38732 ай бұрын

  great tutorial. Thank you!!!

• 
  @kelemvor33332 ай бұрын

  Problem with this is it removes any other formatting that might already be in place.

• 
  @tbaxley23782 ай бұрын

  Thank you that worked! Saved me so much time.

• 
  @sidghosalkar82912 ай бұрын

  This video help me a lot and saved my time👍thanks

• 
  @crystalarchuleta63292 ай бұрын

  Thank you!! This was what I was looking for!

• 
  @drnileshmagar38622 ай бұрын

  Thank you so much its done.....

• 
  @lianchingyap50232 ай бұрын

  Thanks!!!

• 
  @jeremypimentel38862 ай бұрын

  THANK YOU SO MUCH!!! THESE PAGE NUMBERS WERE GIVING A HEADACHE, GLAD I NOTICED THE MESSY HEADER SECTIONS UGHHH

• 
  @danielrosochacki17612 ай бұрын

  Cool stuff! Thx for this, helped me a lot 😀

• 
  @kimyenchu2 ай бұрын

  Hello, you don't have a video on the FILTER function so I am posting this question here. I have an employee leave tracker spreadsheet where I want to filter for the employees who are off a particular month. I have 2 date columns: Start Date and End Date. I have a dashboard that shows the leave booking by month. I can filter for the employees who have booked their leave for a particular month, BUT if the duration of the leave stretches to the next month or the month after I cannot show them when I change to the next month because I am filtering on the Start Date only. How can I filter so that the employee shows in all the months where they will be absent? I think I have to incorporate the End Date into it, but I have not got it to work so far.

• 
  @fliptop1572 ай бұрын

  Thanks! Have a use case at work, and this fits the bill!

• 
  @calystah092 ай бұрын

  How does it know it's days and not years? I need to add 5 years to a date and not sure how!

• 
  @KerimSpahic2 ай бұрын

  how do i get out of this view

• 
  @AnferAlan3 ай бұрын

  I have problems with this formula, what happens if I have 2 instances of the result and I want to see them as you would do, for example if you have 2 records in June 2010, how can I visualize them, because I know that it will find it, but it will only return the value of the first one I really appreciate the hep

• 
  @JayJay-sk3iu3 ай бұрын

  You are a genius!!! I’ve spent so much time trying to figure this out and your video helped me get it done in seconds. THANK YOU!

• 
  @Uvaz783 ай бұрын

  Briliant!! Very clear instructions !!👏

• 
  @teddzagan51783 ай бұрын

  Thanks dude!

• 
  @mr.constitution3 ай бұрын

  Thank you so much! I was literally close to a mental breakdown because I couldn't figure out why my space bar wasn't working! What an idiotic feature of Word!

• 
  @trendy_nails3 ай бұрын

  Thank you!

• 
  @MelBaena3 ай бұрын

  So helpful, thank you!!

• 
  @juancarlospaz40714 ай бұрын

  How do I have it return multiple records that meet that condition and add them up. It returns only the first record that meets the criteria, but there are more that need to be added into one. Thank you!

• 
  @turoochoa25464 ай бұрын

  First time seeing one of your videos..... Well deserved LIKE, and sub!

• 
  @avramidisjeremy4 ай бұрын

  so good, so easy!

• 
  @musasizie4 ай бұрын

  Thanks a lot man

• 
  @paulfarley13964 ай бұрын

  Literally been working on this for over an hour and you solve it in 30 seconds. thanks so much.

• 
  @user-ty2nr5zr8i4 ай бұрын

  How would you do this if you had multiple columns of data?

• 
  @sandeepkumar2704 ай бұрын

  THANKS A LOT VERY USEFUL

• 
  @robertbrodarick96074 ай бұрын

  When I've typed in the formula it seems to provide a 1 to 1 feedback column to column it's row dependent. What am I missing? I'm trying to rule out new open orders against existing open orders on a spreadsheet at work. I was using ISNA VLOOKUP before, but XMATCH seems more promising.

• 
  @cletonsimaoguirrugo7604 ай бұрын

  Microsoft products are so retarded in terms of interaction design......my cellphone is more interactive than Microsoft....... Microsoft 11 is a big step

• 
  @brianross39834 ай бұрын

  Do you see any issues with this formulae as it doesn't return a value. All references are correct =XLOOKUP(A7&B7,'Asia Pacific Master'!B:B&'Asia Pacific Master'!C:C,'Asia Pacific Master'!E:E,"-",0,1)

• 
  @user-pr1os5lb7t4 ай бұрын

  Thanks!!!!!!!