Пікірлер

• 
  @punnyabrataКүн бұрын

  Amazing!!

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

  Thank you!

• 
  @yashpokhriyal4777Күн бұрын

  Great mam

• 
  @contexturesКүн бұрын

  Thank you, Yash!

• 
  @prekshitmehta44392 күн бұрын

  Thanks alots for helping

• 
  @contextures2 күн бұрын

  You're welcome, Prekshit, and thanks for your comment!

• 
  @_immikey7 күн бұрын

  12years later and this video is still saving hours of work time. Thank you so much!

• 
  @contextures6 күн бұрын

  You're welcome, and thanks for letting me know that the video helped you, after all these years!

• 
  @letusplay03307 күн бұрын

  hi, what if i want to find second largest and second smallest

• 
  @contextures7 күн бұрын

  In a pivot table, you could show the values as Rank, then highlight the cells that have rank 2. In this video, I show pivot table Rank examples. kzread.info/dash/bejne/gn2uraiAac6ymZc.html On a worksheet, you could use the SMALL and LARGE functions, with 2 as the second argument.

• 
  @Informativevlogs01038 күн бұрын

  So quick thanks for the info❤

• 
  @contextures8 күн бұрын

  You're welcome, and thanks for your comment!

• 
  @alisansar77389 күн бұрын

  Thanks for your Good working, I have a query can you please help. I want to view the sale of product like a tree type expend (year than expend months than show in date )

• 
  @contextures8 күн бұрын

  Thanks, and in this video I show how to expand and collapse pivot table fields: kzread.info/dash/bejne/haKhqJOJj8q3nbA.html

• 
  @Syedabidbukhari12 күн бұрын

  Fine very good tool to save the time and laborious job convert to a good mood job.

• 
  @contextures12 күн бұрын

  Thank you, Syed, and I'm glad this video will help you save time!

• 
  @subratadas654113 күн бұрын

  At 1:00, how did you change all the values to East in one go?

• 
  @contextures13 күн бұрын

  With all the Central cells selected, I typed East, then pressed Ctrl+Enter to enter that value in all the selected cells

• 
  @paulettebrown464313 күн бұрын

  THANKYOU!!!

• 
  @contextures13 күн бұрын

  You're welcome, and thanks for your comment!

• 
  @aamirmasood465513 күн бұрын

  Excellent video, was looking for this....and this is a perfect video...thanks alot

• 
  @contextures13 күн бұрын

  You're welcome, Aamir, and thanks for letting me know that the video had what you were looking for!

• 
  @martinvictor502814 күн бұрын

  Thank you so much. Your video was most helpful. Martin from Malaysia

• 
  @contextures14 күн бұрын

  You're welcome, Martin, and thanks for your lovely comment! - Debra from Canada

• 
  @coole72414 күн бұрын

  AMAZING

• 
  @contextures14 күн бұрын

  Thank you!

• 
  @gr128320 күн бұрын

  It didn't work for me

• 
  @sangeetapoojari187420 күн бұрын

  Its useful Video ,Thanks

• 
  @contextures20 күн бұрын

  You're welcome, Sangeeta, and thanks for your comment!

• 
  @jhonartcis829622 күн бұрын

  created more than a decade ago and it still works. even on power query, thanks

• 
  @contextures21 күн бұрын

  You're welcome, Jhon, and thanks for letting me know that it works on power query too!

• 
  @HL-ty4je22 күн бұрын

  This has been very helpful for a complicated report I've been trying to do. Thank you so much!

• 
  @contextures21 күн бұрын

  You're welcome, HL, and thanks for letting me know the video helped with your complicated report!

• 
  @hinaimtiaz786123 күн бұрын

  Thank you so much

• 
  @contextures21 күн бұрын

  You're welcome, Hina, and thanks for your comment!

• 
  @acommonman15523 күн бұрын

  Helpful 🎉

• 
  @contextures23 күн бұрын

  Thank you, and I'm glad the video helped you!

• 
  @barttitulaerexcelbart940028 күн бұрын

  Hi Deborah, great tip. You can also use count and average. But watch out, I always show this to my students, the formula for Average is wrong, it should take the average of the blue cells, not the totals. If all the blue cells are filled, its ok, but if you delete some blue filled cells, you get the wrong answer...😉

• 
  @contextures28 күн бұрын

  Thanks, Bart, and that's a great tip! - Debra

• 
  @sohaibmoussaidelidrissi24329 күн бұрын

  Thank you a lot!

• 
  @contextures29 күн бұрын

  You're welcome, and thank you for your comment!

• 
  @bhattketan8307Ай бұрын

  Great

• 
  @contexturesАй бұрын

  Thank you!

• 
  @crappiesitting9067Ай бұрын

  Thanks you so much, this was very helpful and it worked.

• 
  @contexturesАй бұрын

  You're welcome, and thanks for letting me know that it helped you!

• 
  @PerfectLuxSRLАй бұрын

  after 11 years, you still are a lifesaver. Not even chatgpt helped me enough like you did

• 
  @marketcommitteeuchana5922Ай бұрын

  Very Verty thanks

• 
  @contexturesАй бұрын

  You're welcome, and thank you for your comment!

• 
  @yassersaad757Ай бұрын

  Can you believe I use excel since 1990s & I didn't know this! It used to take time to fit my pivots every time I use them.

• 
  @contexturesАй бұрын

  Thanks, Yasser, and I know what you mean! It can take one minute to create a pivot table, and then 30 minutes to make it look good. I hope this shortcut will help you save time!