วีดีโอ

It's Happening!!! Picky Girl Travels the World wants to talk to ME!!! I am sooo EXCITED and TICKLED!!!

thanks

Hello, In a pivot table (having collapsed rows), for a particular column (showing percentage values) I have applied traffic lights which are available in conditional formatting. Here slicers are also created by selecting pivot cells/data. Now when we are selecting an/any option from slicers, the traffic lights are showing incorrect colors for respective percentage values. We have tried multiple ways to fix it but yet they all fail. Please help if somebody knows on the same. Thanks, Hitesh.

Thank you so much sir

Thank you so much😀😀

Thank you sir. You're a great teacher

thank u sir

THANK YOU SO MUCH. APPRICIATED

Thanks 👍👍👍

❤❤❤

Thank you so much for the clear explanation. This helped me so very much!

Thank you! Easy to follow and gave me exactly the info I needed.

You did it the other way instead of what the tittle said... You Replaced "blank" values with "0" (easy to do) 🤣 Your tittle said, "How to replace "0" with blank cells". Everyone looking at your tittle will think you managed to replace cells with "0" on it with "blank" cells (not using the filter command). 🤦‍♂🤣 Correct your tittle to "How to replace "Blank" or any values with "0" or missing values in pivot table". I dare you to find a way to replace cells values with "0" on it with "blank" cells without using the filter command nor deleting values from the original data table...

thank you very useful

thank you

Thank you I was trying to automate a process of creating and sharing filtered tables that are unlinked to data source this was very useful.

I did this formula exactly like this for my excel file and it gave me 0 every time. I have no idea what I’m doing wrong.

Why is it not possible on Excel online? Is there a way to overcome the problem on excel online (Mac)?

Thank you thank you thank you so much🙏🏻🙏🏻🙏🏻

Thank you for the Information

Thank you!

Excellent Tutorial 👍👍

Thanks a lot man

OMG you are soooo EEEEEHHHHHHH MAZING. u really helped me and my 49 children escape the ohio rizzler. 😂😂😂😂😂😂🤣🤣🤣🤣🤣🤣🤣🤣👌👌thanks again Allan Sam you destroyed the video and i also enjoyed the coffee.

Thank you. This was very helpful. Can you explain how you make a histogram of this information when there are multiple rows and columns. Thank you.

This helped me a lot n my project.. Thank you

Tutto sbagliato, Nella Città 3 non da una distanza e le formule sono state inserite male, inserire nella cella M12la seguente formula =M2 Le formule nella colonna N vanno riviste: N2 =Index(DistanceBetweenCities,M2,M3) .... N11=Index(DistanceBetweenCities,M11,M12) 🤔

It's not showing in my Excel what should I do

Thanks a lot Sir. Tomorrow is my Excel exam and you explained the topic so nicely that I have started feeling confident now.

Pathetic! explanation

Very nice problem. This can help me minimise kilometers travel in Indian vacation trips.

Thank you so much

Thank you from India, tamilnadu

Sir, if pass mark for evs and computer science is 45 another subject 35 same criteria how to find failed subject

voilas\\\

Thank you for the video, it was very helpful. I have a further question if I may: how does my constrain look, when my data is not the distance but the time I need between the destinations, and I have a time limit for the travel? Maybe also: I have 4 salesman who have to travel all destinations together, each have the same start and same destination.. how would my constrain look this time?

thank you so much for sharing this video ,it helps me to calculate the frequency of windspeed of 2 years hourly data ,it increases my confidence level ,am very thankful to you sir

Kurwa bobr, you are a giness

If you have multiple projects in a country and have the country listed multiple times in a column and if you have the column alphabetized in a descending order, how would you use the count function without double counting?

Ty sir

Very helpful

How will calculate the departure time & arrival time for the total hours

thanks

where is class interval 11-20

Thank you very much God bless you Sir❤❤❤❤❤❤❤

thank u sir

Thank you very much for your detailed explanation.

😊😊l😊###😊## 😊0##

OMG THIS SAVED MEE THANK YOU SO MUCHHHH