Пікірлер

• 
  @MrFeelBueno21 сағат бұрын

  so good - genius

• 
  @avinashsharma381622 сағат бұрын

  Brilliant

• 
  @JimmyHighVelocityКүн бұрын

  Hi Leila, came across your video, it was very informative! But Vlookup for me is always a hit n miss 50-50, and I still cant figure out why. I believe it comes down to 2 things, I wonder if anyone else in the comment section can help me with. VLookup range, if the cell is formatted as a text/number/general, does it affect the function - at times changing the cell format makes the Vlookup work properly again. If my data is numbers, e.g. 1 - Apple, 2 - Orange. And I want the vlookup to give me Apples and Oranges. But my data sets are more like 000541, 002400, 032300, where there is a '0' in the front, how do I go about this, because the cell changes to be 541, 2400, 32300

• 
  @muhammadhusseinchanel5458Күн бұрын

  pak reques bisa ditambah untuk data wali. terimakasih

• 
  @s.y.daniel2137Күн бұрын

  thanks, just what I needed today ! Thought it was simple to look up a matrix to return the header. with MS 365, is there an easier way to do?

• 
  @CACTUS48Күн бұрын

  Search: SYSDM.CPL - ADVANCE Tab is interesting...

• 
  @alessandrosori732Күн бұрын

  Can I use the whole formula but with sortby instead of using sort? It returns an error to me :(

• 
  @mohammadhadian3720Күн бұрын

  dragers

• 
  @CHIEFUK1Күн бұрын

  Thank God i find this channel

• 
  @FahadKazi-ke4ycКүн бұрын

  Hi Leila, Just like SUMPRODUCT, the last way of accomplishing this task you mentioned is beyond my current grasping capability. I am wondering if you could also add the INDEX(C22:F31,MATCH(H22,B22:B31,0),MATCH(1,(I20=C20:F20)*(I21=C21:F21),0)) as a viable forth method of accomplishing this. This would work because INDEX is forcing it to become array. If it was only match by itself then you would have to make it an array (which in excel is ctrl+shift+enter and in google sheets is encapsulating the formula within ARRAYFORMULA()). Hope this helps.

• 
  @barbaramccool8933Күн бұрын

  Thank you so much for your breakdown! I was wondering, what did you use to demo the mobile actions, highlighting where to click? I'm trying to write an internal work reference and that software would work great for demo'ing processes on different applications.

• 
  @myfuture1164Күн бұрын

  Every time I watch your videos you blow my mind. Thank you Liela!!!

• 
  @axillian2245Күн бұрын

  Hi, got a question as I'm finding it hard to find anywhere at all. So I have a row of check boxes that equal to 100% if all are ticked. But I need one row that quals to 100% in the percentage box if say, only 2 check boxes are selected, out of say 13 options! Does that make sense? Any ideas on this? atm I'm using the Countif(___________,TRUE)/COUNTA(____________). Any help from anyone would be great!!!

• 
  @PharmalinaPharmacyКүн бұрын

  All the tips are really useful

• 
  @shinybitКүн бұрын

  Excel ecosystem is finally catching up to command-line scripting (Linux etc...) which allowed us to do this decades ago.

• 
  @JHatLpoolКүн бұрын

  Nice, clear demonstration. Thanks !

• 
  @ashishds7882Күн бұрын

  Thanks . this helped

• 
  @wpryan02358Күн бұрын

  looks like keyboard shortcuts don't work in the form... at least the ctrl+shift+: doesn't insert the current time...

• 
  @CatskeepКүн бұрын

  Thank You,, you save my day...

• 
  @sanjaikumar-rv3xzКүн бұрын

  Hi mam I have doubt can I get your personal contact number for me to clarify doubt

• 
  @prakyathkulal8731Күн бұрын

  Files are getting corrupted for me

• 
  @inaction2024Күн бұрын

  Wouldn’t it be quicker to ask ChatGPT to do the whole task, not just asking for the Reg Expression code?

• 
  @michaeladejiyan587Күн бұрын

  I want the auto mail to be assigning a serial number to responder as they fill the form Then when i clear response, the serial number should reset from 1

• 
  @anilkumarnvs8121Күн бұрын

  You made me fell confident and independently handle my worksheet. thank you for the Amazing content

• 
  @LeilaGharaniКүн бұрын

  You're so welcome!

• 
  @fokkenhotz1Күн бұрын

  very good subject and alsoooo, on devices that originally ran 8.0 to 8.1 to 10 ,: 1.) its recommended disabling sleep or hyberrnate toggles on the start button options, as i sat on the mouse and scooted and it turned OFF from sleep mode and had last mode on and some how it wont come out of sleep mode the pc's made uncrashable 2011- 2016 all makes sought out and ms and .goog attack them 3rd party to render keep offline true and so have fun its a learner user exp. neverending story ❤ great channel i corroborate u celebrate u keep on rocking mama

• 
  @rishadrishu5979Күн бұрын

  Thank you mam

• 
  @reulfahКүн бұрын

  Amazing as alwaysz thank you Leila! ❤

• 
  @LeilaGharaniКүн бұрын

  Glad you like it!

• 
  @mahmoudmahgoub8Күн бұрын

  thanks leila, i can not find REGEX function!!!, should i install it or do anything? and how? thanks Leila

• 
  @leanneattwood80032 күн бұрын

  Hi there, when I am sharing a live Excel it is only capturing my screen and not the tool bar ribbon... please help how do I increase the capture area ?

• 
  @petroswheels2 күн бұрын

  Is there any way to assign negative points to answers? It would greatly help with building out a scorecard.

• 
  @dymesmimi2 күн бұрын

  Thank you so much 😭

• 
  @Waterfall3242 күн бұрын

  Hi Leila, I found your tutorials very helpful. In my situation, I have scenario #3 - I have about 20 tabs in the same spreadsheet and the columns are identical (the data obviously not). Of course, I can mechanically transfer all 20 tabs to one but it takes a lot of time. Is there an easier way to create pivot from numerous tabs?

• 
  @SaadKidwai2 күн бұрын

  Thank you

• 
  @NoumanAttari-uz9ox2 күн бұрын

  found exactly what i was looking for. Gr8 stuff

• 
  @LeilaGharaniКүн бұрын

  Happy to hear that!

• 
  @Habibi_Editz4u2 күн бұрын

  👏👏👏👏

• 
  @idreesbahrain90932 күн бұрын

  Madam Leila Help me plz my ukhty i have an inventory sheet in excel, sheet no. 1 is product list, sheet no. 2 is opening stock, sheet no. 3 is Incoming product, sheet no. 4 is sales product it means outcomin product , i want to know how to write the price you entered according to the date i bought the load together with the price its unchanged at the other price i started writing in the beginning Help plz my sister

• 
  @richardc81292 күн бұрын

  It appears all of these shortcuts are for 365. For those of us who use the non-365 versions of Excel (OFFICE), what version would include all of these features??? Thanks.

• 
  @mirzadlakic32992 күн бұрын

  yes it happend to me

• 
  @Markchill22 күн бұрын

  Thank you Know I can read my eBay history

• 
  @Souravjanarajiv2 күн бұрын

  Is it possible to use that formula without tablet sumifs

• 
  @farhanashraf89622 күн бұрын

  Thank you for this. It really helped.

• 
  @monologuesofaconsultant2 күн бұрын

  I love you 3000!

• 
  @luisavelandia30142 күн бұрын

  Great video. How can I share a to do list to external users? Please.

• 
  @paullaviano47932 күн бұрын

  Hi Leila, Nice video, just a note you CAN tell it to extract email addresses, you can use name manager :)

• 
  @LSl02 күн бұрын

  Su- u--uper! Thaaaaank you!!! 🙏🌸🥰

• 
  @DGerharts2 күн бұрын

  THANK YOU AS ALWAYS LEILA

• 
  @user-fn3hr7ht8l2 күн бұрын

  Hello I can't find that feature in my excel...? My excel is of latest version...? Where can i find that Analyze data....?

• 
  @eradotcom3 күн бұрын

  Love it, thanks Leila👍👍

• 
  @gs48473 күн бұрын

  Is it possible in onenote to have different accounts/spaces. For example one for my job, one for personal life? I.e. completely separate.

• 
  @swedeman733 күн бұрын

  Great job. So simple. You are excellent.