Абсолютно не понимаю язык то ли английский то ли американский но логику понял. Из сырой таблицы создаём умную из умной сводную. Дальше анализ по параметрам. Графики и т.д.
Ticket create date : 05/01/2024 09:30 AM, Ticket closing date: 07/01/2024 12:30 PM, I want the total duration but after 09 pm to 09 am i dont want to count the hours, whats the excel formula. please help.
Hey this dashboard is mind blowing but i'm not able to get that scroll bar linking with that offset function that how does the values are being changing with every scroll down and the corresponding values are changing simultaneously. i tried plenty of times but it's not showing like there in your tutorial. Could you please help me
good presentation. one suggestion if you could move the cursor little bit slow so that the viewer can understand what exactly you are doing, hope you will take care of this for future.
the pRT OF THE VIDEO where offset fn is used , mine is not working its showing #VALUE! . also the rank fn is not working with me i inserted # but its showing error. can anyone help me fix it .
Your dashboards are very fun to watch and really creative. Thanks for the time and effort putting this in for us to see. Curious, is there a reason you did not use data model and then power pivot when creating the relationships between the tables instead of using vlookup? Thanks
Thank you so much! I was trying to keep it as simple, and as lots of learners are not very familiar with Power Query and Power Pivot, I used vlookup instead
As a new learner, its easy to follow what you did. I curious also for the power query and power pivot. Do you have a separate tutorial for this? Appreciate much.❤
Much love from India I am not able to afford tution fees because I am single person and your tutorial is far amazing when i show this to my friend they just shocked great work and always uploads that type videos
Excellent tutorial. I have prepared a similar dashboard, but without product RANK. I'm unable to use this formula. I'm getting error. Can you please help.
Please try =RANK(Y3, Y3:Y45) this formula for better understanding, only it will not be dynamic, if the product range changes, it will required you to adjust the RANK formula range too accordingly. I used =RANK(Y3#, Y3#) to make it dynamic. I hope this will help!
I am using office 365. That's why it was showing error to you, because # formula will not work in your case, so use the recommended formula in my earlier comment.
Nice, Thanks for your video. This is the first time I see someone using Pivot and it confused me a little in the beginning but I was able to get very steep you took and the reason you know, I like reasoning why people do what they do. You've just got a new subscriber. Btw, I can see that you're really passionate about what you do and that your willpower is great. I hope you keep doing what you're doing 'cause you rock man. Have a nice day n_n
Good morning sorry to disturb your time permission to ask, can the power bi dashboard be used in visualizing toddler nutrition analysis at posyandu? thanks 🙏🙏🙏
Thank you for your kind words! It is a pleasure to hear that you enjoyed the video. To add the Developer tab in Excel 2016, go to the "File" tab, select "Options," choose "Customize Ribbon," and check the box next to "Developer."
I Stuck on the Video at 18:57 Second when you used offset and then applied Rank formula, In your Formula bar showing Rank(Y3#,Y3#)? I applied rank formula and then i Selected the Month Slicer but when i select the Feb values are showing error in the range selected. Please Help.
@@LeanExcelSolutions Hi, No doubt it's a very fantastic dashboard I loved it but as a new learner I found it a little fast and requested you to please make a little slow video and explain the things on where we should go in which ribbon and what to select. I am stopping the video taking it backwards and looking again and again where the curser is going and what you are selecting or writing. Please, it will be very helpful for billions of new learners like me... Thank you for considering my request 😊👍
Was that graphical representations of data's and files were like building structures reflectable everywhere by networks like cosmic going vertical energy structures ? How can they know where's the up and down in space ? We're they making strings or spiritual achievement reports?
I am getting zero values in offset formula in product wise calculation. I tried in both formulas IFERROR(OFFSET($Q$2,1,0,COUNT($S:$S)),0) OFFSET($Q$2,1,0,COUNT($S:$S)) Version in 2019
The OFFSET function you're using seems to be structured correctly. If you are using the sample data shared & following the correct steps, it should work correctly. If, however, you are using a different dataset & you are receiving zero values, it may be due to data setup or other factors. Please verify that Column S contains actual data and that the values are in numerical format. Should it not work, can you please share a screenshot or file with me so that I can have a look at it and advise you on the problem, since without looking at the data I can't tell what's wrong.
18:53 you are doing the rank function with Y3#. This'#' thing is not working in my excel. My version of excel is Office 16 and I am working in Windows 10. Kindly advice.
@@LeanExcelSolutions Thank you, it is working. But, however it was also working with =RANK(Y3,$Y$3:$Y$46). is this alright or shall we follow your method?
Yes, you can use this too, but if the range changes, you may have to extend it every time. so better to use "=IFERROR(RANK(Y3:Y1000,Y3:Y1000),"")" & it will not give you an error while filtering or data range changes
@Lean Excel Solutions yes. I understood that. Thank you. However I am unable to do the scroll part of product graph. After product 10, all are coming as value#. However I had to skip it. BTW is there any solution for it? I mean I have followed the same steps
I never knew I could get such a dashboard using excel.. thank you very much I have learned alot watching this video. I am currenly stucked at 17:50.. after filling the offset function, it does not fill down automatically. it just populates the V3.. what am I getting wrong? Anyone please
It's an incredible explanation. My question is about creating the RANK formula. When I make the Product and UOM pivot table, the values overlap and I can't have the table with one row. Can you help me please.
Thank you for your appreciation. It is not clear to me if this will solve the rank function error, but I believe that it will 1. Choose the classic PivotTable layout by right-clicking within the pivot, clicking on Pivot Options, and then selecting Display & check the Classic PivotTable Layout option 2. Use "=RANK(Y3, Y3:Y1000)" instead of "=RANK(Y3#, Y3#)" if you are not using office 365 I hope this will be helpful to you. Thanks!
@@LeanExcelSolutions Dear madam i tried alot to make that scroll bar but never get successeed..... the option you r going through the same i go but it shows error in value. can i send you data via email so that you can check please.. kindly note it is official data, its just a learning data, most this i understand only scroll bar option is not working by me however i copy u completetly,, pleaae help me
@@LeanExcelSolutionsI facing an error in offset function as I was trying to filter to check if it is working fine I am facing error of value can you pls help me with this
Thanks for sharing this video, The Formula Offset doesn't work in office 2019. Can i have a solution to this problem or equivalent to this formula??? Thanks agin
Interesting video. Thanks a lot, I've learnt enough from this video. Am I permitted to work on this dataset and add to my portfolio? If yet, how do I reference the dataset?
Offset formula is not working for me. Where I am getting error after height value as value#. Can you please provide logic to avoid error after specific height.
Thank you can we get the video explans color desingn and dashboards with Icons in PPT or Excel please recourding us another video to understanding the way of making that... We wll waiting for you
This is great, but the bit where you create the visuals is just a bit too fast - Hard to follow and some stuff (changing corner radius) is glossed over.
Any one can help me how did arriving this table through the pivot table.. am also tried based on the video but i couldn't.. Pivot Table in Row - Product, UOM, & in Values - Selling Values and quantity
Hi I have a different data. basically I have list of customers and each customers might have more than one product. how do you think I should create the data so I can make the dashboards like you?
when i am using offset it is by default applying to only 1 cell , in your video the height your are selecting you are getting the number of rows, help me with that
Hi, you might be using older version of Excel where offset function will not work as I demonstrated in video. You can use Name manager to define the name & use it for graph. I have demonstrated it in other videos, you can refer them.
why did we use make offsets and not directly the range? There are some concepts that are extremely confusing. Like why did you subtract 9, I think you should give reasons along with it, it would be better for someone who has just started with excel. Like I didn't understand why was there zeros in the scroll bar. When you are using a function, I think you should explain why are you using it and what's the need of that. As someone who started to learn, i think the video was too quick
No able to understand from 18:40 to 19:02, Rank function is not clear to understand. How was it calculated? And 21:00 to 21:16 how they are calculated? Product and Sum of total selling value
I used # operator, which is available in office 365 to select the dynamic range. If you are using other excel version, you can use "=IFERROR(RANK(Y3:Y1000,Y3:Y1000),"")" instead of "=Rank(Y3#,Y3#)".
Hi, please watch my sales distribution dashboard in excel video, where I used pivot table itself to rank & filter top products. I hope that will work for you! 😊
It takes 43.52 years for competence of excel in order to produce such a 43 min 52 sec video. Amazing!
😲 Good one!
Thanks alot. I prepared d same dashboard with d help of this video.. 3 cheers for u guys. Plz reduce d back music volume..
Thanks for all this but please try to avoid using this heavy background music
Thanks!
Yes sure, it was mistake.
August way to explain !!!!
@@LeanExcelSolutions ur video is very useful infct i share ur channel with my friends
Thank you so much!
Абсолютно не понимаю язык то ли английский то ли американский но логику понял. Из сырой таблицы создаём умную из умной сводную. Дальше анализ по параметрам. Графики и т.д.
Ticket create date : 05/01/2024 09:30 AM, Ticket closing date: 07/01/2024 12:30 PM, I want the total duration but after 09 pm to 09 am i dont want to count the hours, whats the excel formula. please help.
Did you get the formula?
Wow this is first Enterprise Level Dashboard Reporting it's really awesome experience...
Thank you so much :)
Well done for me, just watching your vdo I able to create one. Big thank
Thanks
Wow
Hey this dashboard is mind blowing but i'm not able to get that scroll bar linking with that offset function that how does the values are being changing with every scroll down and the corresponding values are changing simultaneously. i tried plenty of times but it's not showing like there in your tutorial. Could you please help me
Fast explain.plz do slowly
Sure
good presentation. one suggestion if you could move the cursor little bit slow so that the viewer can understand what exactly you are doing, hope you will take care of this for future.
Thank you for suggesting, will take care of that!
Amazing job and stunning Dashboard, I got lots of new skills through your tutorial video, Thank you VERY MUCH! 😊 🌹
Great to hear!
Thanks for the video. I can’t get the scroll bar to work (20:40). I use Office 365. Any help will be greatly appreciated!
Can you please provide sheet in microsoft excel for business budget monthly or annually plz?
I will pay it.
Thanks.. bro.. oya vidiyatama heduwa.. Dynamic type dash board ekak hadana heti ... puluwannam daanna..😍
the pRT OF THE VIDEO where offset fn is used , mine is not working its showing #VALUE! . also the rank fn is not working with me i inserted # but its showing error. can anyone help me fix it .
Your dashboards are very fun to watch and really creative. Thanks for the time and effort putting this in for us to see. Curious, is there a reason you did not use data model and then power pivot when creating the relationships between the tables instead of using vlookup? Thanks
Thank you so much!
I was trying to keep it as simple, and as lots of learners are not very familiar with Power Query and Power Pivot, I used vlookup instead
As a new learner, its easy to follow what you did. I curious also for the power query and power pivot. Do you have a separate tutorial for this? Appreciate much.❤
Thanks,
yeah it is there. You can look for the customer analytics dashboard on the channel.
@@LeanExcelSolutionsKindly share us some sample dashboards, so that we can watch and prepare. Very curious to prepare after seeing your presentation.
Where can we download this Dashboard for training ? Please let me know your feed-back
enjoyed watching it, elevated me to be an excel enthusiast...
Cant get through the offset function. keeps on giving #value! when i scroll the bar :(
Can you explain to me about "=Rank(Y3#,Y3#)" how's it work?
I like this video ❤❤❤
Thank you 😊
Very well-organized dashboard ! Great work
Thanks a lot!
2019 USA IBM COMPUTER
1
0
such an insightful video, but the file practice is not available to be downloaded, can you please recheck the provided link? thank you in advance
Hi, thanks for the feedback.
After you comment, I checked it & realise the website is down. We will resolve the issue soon.
there is a mistake in formula calculated Profit % It should be as below
Profit % = Profit / sales value
not dividing / Buying Value
Yes, I realised it after uploading the video!
its was amazing very helpful for sharing your knowledge
Glad to hear that 🙂
thank u for this awesome dash board wanna ask u question
isn't profit% equals (total profit/ total sales value)%?
please help me with this
Yes you are right 👍
Actually it was a mistake while explaining
The 22:10 second Onwards is too fast to follow
Yes, the same was demonstrated in the previous visual & it was just repeating.
But you can change the playback speed to watch it at a slower pace.😊
@@LeanExcelSolutions thanks, overall a great video, i learnt a lot from it
Much love from India I am not able to afford tution fees because I am single person and your tutorial is far amazing when i show this to my friend they just shocked great work and always uploads that type videos
Thank you so much:)
JUST FANTASTIC !!!
MY head is blowing 🤯
Thanks a lot!
I just finished working on this project with the help of your video. Thanks a lot.😊
Happy to hear that 😊
Everything perfectly except music its announcing as Arabic following we can't foukse in English speech thank you
Yes, I also realized after uploading!
Whenever I am using the slicer, I am still getting the issue "#value|'", offset is not working in my case, can you guide me
I'm facing the sane issue, can u please guide
I love the video, very informative however the music is a bit distracting IMO, Please re upload without.
Thank you for this awesome tutorial and most compelling dashboard, I just finished my project !!! :)
Great, congratulations 🎉
Happy to hear that
Excellent tutorial. I have prepared a similar dashboard, but without product RANK. I'm unable to use this formula. I'm getting error. Can you please help.
Please try =RANK(Y3, Y3:Y45) this formula for better understanding, only it will not be dynamic, if the product range changes, it will required you to adjust the RANK formula range too accordingly.
I used =RANK(Y3#, Y3#) to make it dynamic.
I hope this will help!
@@LeanExcelSolutions thank you. Am I ask which version you were using? I used MS Excel 2019.
I am using office 365.
That's why it was showing error to you, because # formula will not work in your case, so use the recommended formula in my earlier comment.
Nice, Thanks for your video. This is the first time I see someone using Pivot and it confused me a little in the beginning but I was able to get very steep you took and the reason you know, I like reasoning why people do what they do. You've just got a new subscriber. Btw, I can see that you're really passionate about what you do and that your willpower is great. I hope you keep doing what you're doing 'cause you rock man. Have a nice day n_n
Thank you so much for your kind words. Really appreciate!
Thank you this amazing tutorial, Please i try to download the data file but some columns were missing, columns like date, Quantity in input data sheet
Hi, Thank you for reaching out. I checked it. The file is ok, having all required columns.
I Love your Dashboard espicially with background :)
Thank you! 😊
Before this video i considered myself as a not bad excel user)) Thanks a lot, implemented a lot from your dashboard 🥰
😊 Great 👍
It was all good till I got to the scroll bar. It went downhill from there. Nice video.
Thank you for the feedback 😊
Good morning sorry to disturb your time permission to ask, can the power bi dashboard be used in visualizing toddler nutrition analysis at posyandu? thanks 🙏🙏🙏
A display of masterclass by Lean excel solutions. Thank you for sharing this, It will help me and others. A lot to learn.
Happy to hear that 😊
Great Video, Its really fun to watch your videos. I was just curious about how can I add developer tab into my excel 2016?
Thank you for your kind words! It is a pleasure to hear that you enjoyed the video.
To add the Developer tab in Excel 2016, go to the "File" tab, select "Options," choose "Customize Ribbon," and check the box next to "Developer."
@@LeanExcelSolutions Thank you 😊
Thank you for your video. I really like the content, but find the background music too loud and distracting.
Yes it is. Sorry about that
hello ,
sorry again but i want some answers about excel expert ! i can't creat new product
thanks !
It seems to me you are very passionate on what you do, thank you for sharing your knowledge!
Thank you so much :)
I Stuck on the Video at 18:57 Second when you used offset and then applied Rank formula, In your Formula bar showing Rank(Y3#,Y3#)? I applied rank formula and then i Selected the Month Slicer but when i select the Feb values are showing error in the range selected. Please Help.
You created a Stunning dashboard. Great learning experience throughout the video. Thanks for sharing this knowledge with us.
Thank you so much!
@@LeanExcelSolutions Hi, No doubt it's a very fantastic dashboard I loved it but as a new learner I found it a little fast and requested you to please make a little slow video and explain the things on where we should go in which ribbon and what to select.
I am stopping the video taking it backwards and looking again and again where the curser is going and what you are selecting or writing.
Please, it will be very helpful for billions of new learners like me... Thank you for considering my request 😊👍
Where is the data set, please help
The link is the description to download it
The offset function getting error value# in the cells when adjust in slice,plz help me
me too pleasee helpppp
Wonderful!,can i have the data
Thank you, link to download the data is in description!
in the monthly sales visual, the data is not getting updated with the checkbox
Hi, I checked it. It's working
Was that graphical representations of data's and files were like building structures reflectable everywhere by networks like cosmic going vertical energy structures ? How can they know where's the up and down in space ? We're they making strings or spiritual achievement reports?
I am getting zero values in offset formula in product wise calculation. I tried in both formulas
IFERROR(OFFSET($Q$2,1,0,COUNT($S:$S)),0)
OFFSET($Q$2,1,0,COUNT($S:$S))
Version in 2019
The OFFSET function you're using seems to be structured correctly. If you are using the sample data shared & following the correct steps, it should work correctly. If, however, you are using a different dataset & you are receiving zero values, it may be due to data setup or other factors. Please verify that Column S contains actual data and that the values are in numerical format.
Should it not work, can you please share a screenshot or file with me so that I can have a look at it and advise you on the problem, since without looking at the data I can't tell what's wrong.
18:53 you are doing the rank function with Y3#. This'#' thing is not working in my excel. My version of excel is Office 16 and I am working in Windows 10. Kindly advice.
Please use "=IFERROR(RANK(Y3:Y1000,Y3:Y1000),"")" instead of "=Rank(Y3#,Y3#)".
This will work in you case
@@LeanExcelSolutions Thank you, it is working. But, however it was also working with =RANK(Y3,$Y$3:$Y$46). is this alright or shall we follow your method?
Yes, you can use this too, but if the range changes, you may have to extend it every time. so better to use "=IFERROR(RANK(Y3:Y1000,Y3:Y1000),"")" & it will not give you an error while filtering or data range changes
@Lean Excel Solutions yes. I understood that. Thank you. However I am unable to do the scroll part of product graph. After product 10, all are coming as value#. However I had to skip it. BTW is there any solution for it? I mean I have followed the same steps
Thanks a lot for the amazing learning experience!!
My pleasure 😊
new subscriber here! thank you for sharing ideas!
Thank you
I never knew I could get such a dashboard using excel.. thank you very much I have learned alot watching this video. I am currenly stucked at 17:50.. after filling the offset function, it does not fill down automatically. it just populates the V3.. what am I getting wrong? Anyone please
The offset formula on my excel didn't work, even though its correct formula, but when i tried in other computer excel it works 😢. Why why. 😢
Thank you for your amazing effort!!! Awesome dashboard
Thank you for the appreciation 😊
SO NICE MAM IF ANY HR DEPARTMENT DASHBOARD I WANT TO LEARN
Coming soon 😊
Mam how many years you have dashboard experience
It's an incredible explanation.
My question is about creating the RANK formula.
When I make the Product and UOM pivot table, the values overlap and I can't have the table with one row.
Can you help me please.
Thank you for your appreciation.
It is not clear to me if this will solve the rank function error, but I believe that it will
1. Choose the classic PivotTable layout by right-clicking within the pivot, clicking on Pivot Options, and then selecting Display & check the Classic PivotTable Layout option
2. Use "=RANK(Y3, Y3:Y1000)" instead of "=RANK(Y3#, Y3#)" if you are not using office 365
I hope this will be helpful to you. Thanks!
@@LeanExcelSolutions Dear madam i tried alot to make that scroll bar but never get successeed..... the option you r going through the same i go but it shows error in value. can i send you data via email so that you can check please.. kindly note it is official data, its just a learning data, most this i understand only scroll bar option is not working by me however i copy u completetly,, pleaae help me
@@LeanExcelSolutions I tried using this "=RANK(Y3, Y3:Y1000)" instead of "=RANK(Y3#, Y3#)" 'm getting error #Value!
@@vetrip7153I have got it thanks
@@LeanExcelSolutionsI facing an error in offset function as I was trying to filter to check if it is working fine I am facing error of value can you pls help me with this
tremendo lo que se puede hacer y tan rapido.
Thanks for sharing this video, The Formula Offset doesn't work in office 2019.
Can i have a solution to this problem or equivalent to this formula???
Thanks agin
W😮W This is Amazing!🔥
Thank you 👍
This is next level creating dashboards, amazing!
Thank you for sharing
Happy to hear that!
Thank you 😊
Interesting video. Thanks a lot, I've learnt enough from this video.
Am I permitted to work on this dataset and add to my portfolio?
If yet, how do I reference the dataset?
Yes, you can The dataset link is in the description.
Offset formula is not working for me. Where I am getting error after height value as value#. Can you please provide logic to avoid error after specific height.
I thought it is possible in Power-Bi
that's great innovation
Thanks!
Indeed! Excel is incredibly capable of creating stunning dashboards with its features and functionality.
while creating tree map chart, you said that it will not update with the slicers but it is getting updated.
🤔I think, I said that the tree map can not be inserted with Pivot table.
Profit %= Total Profit/Total selling Value, Am I wrong?
Hi, you are correct. Now I noticed that, I mistakenly selected the buying value instead of the selling value.
Thanks!
@@LeanExcelSolutions thank you for clearing the confusion, I'm learning a lot, really grateful for the tutorial, keep it up
Thank you can we get the video explans color desingn and dashboards with Icons in PPT or Excel please recourding us another video to understanding the way of making that...
We wll waiting for you
Amazing works and learnable too, thank you for the video, you wont get it from school.
Thank you so much
This is great, but the bit where you create the visuals is just a bit too fast - Hard to follow and some stuff (changing corner radius) is glossed over.
Noo facil muerto computadora truno sordo muy entre
Any one can help me how did arriving this table through the pivot table.. am also tried based on the video but i couldn't.. Pivot Table in Row - Product, UOM, & in Values - Selling Values and quantity
Unfortunately, I do not understand what you are asking, but please use a classic pivot table. Hope it will help.
Hi I have a different data. basically I have list of customers and each customers might have more than one product. how do you think I should create the data so I can make the dashboards like you?
CAN ANYBODY PLEASE HELP ME IN UNDERSTANDING 18:46 (RANK FORMULA), WHAT FORMULA WAS RETURN THERE
help I am unable to do the scroll part of product graph. After product 10,no more value coming. thank u
Wow you are so creative. I didn't even know Excel could do that. I was mesmerized watching you build this....
Thanks 👍
not very beginner friendly
Yes, it assumes that the person will have atleast intermediate skill to design such dashboard!
Hi, i create column Product but when filter month it's below for issue "#Value!".
I'm not so sure at the rank - product, how could you get the top 10 product only? It looks like you choose 10 products but they are not top selling?
I just placed mine. Learning is Exciting.!
Wonderful!
Thank you so much. It is very very useful. I love your way of transferring knowledge.
Thank you for the appreciation!
when i am using offset it is by default applying to only 1 cell , in your video the height your are selecting you are getting the number of rows, help me with that
Hi, you might be using older version of Excel where offset function will not work as I demonstrated in video. You can use Name manager to define the name & use it for graph.
I have demonstrated it in other videos, you can refer them.
@@LeanExcelSolutions I am using Excel 2019. Could you please share me the link of those other videos which you are describing
@@LeanExcelSolutions WHICH VERSION OF EXCEL YOU ARE USING ?
I am using Office 365 subscription
@@LeanExcelSolutions could you please provide a link to those other videos to have scrolling chart , You have so many videos I got confused
thank you. you gave me inspiration.
I'm so glad!
Very useful content, thank you for sharing
Sopheak - Cambodia
Most welcome, thanks 👍
This video is for who knows already about dashboards, not for the beginners.
Yes, that's right, I explained it assuming viewers have at least intermediate skills in designing dashboards of this type.
Any video for the beginners?
Good day, just want to ask if how did you align the text box on 33 minutes and 15 secs of the video?
I NEED SOME HELP: I CANT SEPERATE THE PICOT TABLE FOR Sum of TOTAL SELLING VALUE, I DDONT HAVE DEVELOPER TAB TO CREATE CHECK BOXES
Please if you send me formula when you add in Input data sheet and extract from Master data.
why did we use make offsets and not directly the range? There are some concepts that are extremely confusing. Like why did you subtract 9, I think you should give reasons along with it, it would be better for someone who has just started with excel. Like I didn't understand why was there zeros in the scroll bar. When you are using a function, I think you should explain why are you using it and what's the need of that. As someone who started to learn, i think the video was too quick
No able to understand from 18:40 to 19:02, Rank function is not clear to understand. How was it calculated? And 21:00 to 21:16 how they are calculated? Product and Sum of total selling value
I used # operator, which is available in office 365 to select the dynamic range.
If you are using other excel version, you can use "=IFERROR(RANK(Y3:Y1000,Y3:Y1000),"")" instead of "=Rank(Y3#,Y3#)".
Thanks for your effort..... Intresting... Learn alot...
Glad to hear that 😊
RANK(AK3#,AK3#) Not work in excel 2019 it show error how do solve it
Please use "=IFERROR(RANK(Y3:Y1000,Y3:Y1000),"")" instead of "=Rank(Y3#,Y3#)".
This will work in you case
Great video but PLEASE kill the music.. its driving me mad
Thank, will take care of the music next time
Hi, please watch my sales distribution dashboard in excel video, where I used pivot table itself to rank & filter top products. I hope that will work for you! 😊
That pivot table data and files segregation into that 4 box at the right side reminds me of the 4 's of the Earth areas.
Im trying to download the link for the data file foe practice, but am struggling to locate it. Can you help
Click on the link provided in the description & you will find a button to download the practice file.
Amazing content thanks but background music is irritating
Thanks for your appreciation & Yes, I also realised the music is irritating but after uploading the video, so didn't change it!