Пікірлер

• 
  @shivlisona80492 күн бұрын

  Thanks a lot❤❤❤

• 
  @awezkhan36623 күн бұрын

  Not working

• 
  @koushikchatterjee16604 күн бұрын

  Very complex video. 😢. Make it simple.

• 
  @FAISALBUTT-k4d4 күн бұрын

  Hi this is very use full but if we need to check overlapping of time date wise

• 
  @lythienghuo28764 күн бұрын

  If list 1 double item ,so how we doing

• 
  @manasranjannag12695 күн бұрын

  Thank you

• 
  @ShamaKhanna7 күн бұрын

  Sir I can't done =Filter(Table1,Table1 Birthday>=Today) Please guide

• 
  @hiei42797 күн бұрын

  You have to use the formula like this filter(Table 1, F4: F (however many cells you have in your list)>=E1. Hope this helps :)

• 
  @dinahany2338 күн бұрын

  helpful thank u so much

• 
  @briantran30008 күн бұрын

  What happens when the list has duplicate names? Will the result be messed up.

• 
  @pratickdas654411 күн бұрын

  THANK YOU. DONE

• 
  @TNMani-ro1tu11 күн бұрын

  Thanks for clarification

• 
  @ailtonbiji502412 күн бұрын

  great use... thanks

• 
  @tigerlils391012 күн бұрын

  Wow than u so much this is great. What if we had two criteria instead of just one?

• 
  @mrinalrevoo843013 күн бұрын

  Filter function is not in my excel

• 
  @Aghubhai17 күн бұрын

  I could have been better if you say out time or in time instead of d4 c3

• 
  @HODLHAHA18 күн бұрын

  How do we get the formula to subtract 30 minutes for lunch if over 6 hours are worked?

• 
  @pratickdas654419 күн бұрын

  thank you so much sir

• 
  @erlindaaliciaolivaressierr400420 күн бұрын

  please! why add +1???? :(

• 
  @genpittam567521 күн бұрын

  Thank you so much! best and easiest video!

• 
  @m.mukhtiarali606325 күн бұрын

  it is so much easy. i really liked it.

• 
  @fts80026 күн бұрын

  Thank you for such a wonderful, complete, incredibly helpful solution to my problem!

• 
  @danielosorio21726 күн бұрын

  Excellent step-by-step detailed explanation. Thank you! First time in your channel and looking forward to your content.

• 
  @priteshhazare130126 күн бұрын

  love from singapore

• 
  @rakishoard28 күн бұрын

  Thank you for making this video, was able to make my own birthday tracker because of you! Thanks again!

• 
  @TCN-pi2sz28 күн бұрын

  Thank you, this is so useful

• 
  @rahulchaudhari325428 күн бұрын

  Sir, Thank you for the formula, best and easy way to calculate the working hrs.

• 
  @stefania1475029 күн бұрын

  Very clear explanation. The best video tutorial on index and match so far. Thank you!

• 
  @madhusudhanthapaАй бұрын

  How to total

• 
  @erinusman378Ай бұрын

  but what if they have a break when midnight shift? 😢

• 
  @user-pp8tw8ee1gАй бұрын

  3:49

• 
  @power-reconcileАй бұрын

  This is helpful! Thanks for sharing!

• 
  @HussamQaziАй бұрын

  Hi. I a number that I need to find in a column. which is clubbed amount of 2 numbers or more in another table. How I can find that numbers? Like I want to find what numbers are adding up to make $3000. is there any way?

• 
  @HussamQaziАй бұрын

  Hi. I a number that I need to find in a column. which is clubbed amount of 2 numbers or more in another table. How I can find that numbers? Like I want to find what numbers are adding up to make $3000. is there any way?

• 
  @bertvantol9669Ай бұрын

  Just one dream .... How to color Saturdat and Sunday just from current moth ..???

• 
  @user-si8gf8xy7sАй бұрын

  So 15 is rounded to the nearest number, not sure how to put it

• 
  @gregrichards1660Ай бұрын

  Phew! tight well done 5 min INDEXMATCH...✔✔👍👍ty

• 
  @RamatoulieBaldeh-pq8cnАй бұрын

  Good add more

• 
  @user-up8nw9dr3eАй бұрын

  Not connect WhatsApp

• 
  @ambersiddiqueamber3082Ай бұрын

  very easy to understand. But request to pls clear the issue for "LEAP YEAR".

• 
  @leahamoresАй бұрын

  I think, there was something wrong when I did mine.

• 
  @775shahrukhАй бұрын

  you could use 1 dimensitonal index match...=INDEX(D4:D13,MATCH(K4,C4:C13,0)) ....for math...no need to write match formula 2 times

• 
  @nahlamoheb4706Ай бұрын

  Hero!

• 
  @DilKiZubaanShayariАй бұрын

  Wrong calculation

• 
  @melvinwilliams7977Ай бұрын

  Greetings teknisha- when using the formula to record current year , all the months reflect the month as jan(1) rather than the actual month. I'm using Microsoft 365 currently- please advis

• 
  @drivekandjАй бұрын

  Same here.

• 
  @elpiruleroАй бұрын

  Thank you!

• 
  @TValexTavАй бұрын

  Thank you, your information was very helpful, although I encountered some difficulties with titles containing multiple words (which I resolved by inserting underscores "_" between the words).

• 
  @souravgupta1769Ай бұрын

  Can it was done through x lookup

• 
  @EricPardoАй бұрын

  Thanks so much!!!

• 
  @sundeepsundeep836Ай бұрын

  thank you

• 
  @richardkwan2840Ай бұрын

  Can you please searchable dropdown list that works for version 2019 or older