Excel GetPivotData function | Use GetPivotData Function to Pull Values from Pivot Table

[@ravichauhan3933]

You are the first to come to mind when I'm stuck in Excel because you always have solutions to my problems.

[@Innozant]

Thanks dear.

[@monysain6762]

Sir, words would never do justice to how grateful I am to find your KZbin channel thank you for making such content

[@Innozant]

Thanks Mony..Keep Learning

[@aabdullahhaasnain7033]

You tought me what I searched for. Great man...

[@Innozant]

Thanks dear..Happy Learning ❤️

[@sonamchauhan4969]

Superb explanation, bhut acche se explain kia, kisi ko bhi samajh aa jye 👍🏻

[@Innozant]

Thanks Sonam,Step by step in sequence learn kariye aur practice kariye ,koi query aati hai to telegram id @innozamtofficial par puch sakte hain.Have a wonderful career ahead

[@HaseebMirza-f8y]

I was stuck on this function. Your video helped me out.

[@sunilmasta]

The confident way of teaching makes you different from the crowd

[@Innozant]

Thanks dear

[@ravichauhan3933]

Jha Sir, you are always great "Guru Ji in the world of Excel.

[@Innozant]

Thanks

[@nikhilagarwal9024]

way looking for this from a long time, found many videos explained in shortcuts. This is in detail and extremely helpful

[@Innozant]

Thanks.Keeo learning

[@keshariprasad1992]

Very nice Brother. U r teaching very nicely.

[@Innozant]

Thanks dear

[@pravinkumbhare1750]

Bahot hi badhiya explain Kiya Sir... Thank You..

[@hiteshkekre8514]

too good, this is truly awesome and the way you simplified the formula is commendable

[@Innozant]

Thanks.Keep Learning

[@mahantheshgh151]

Your enlighten and enriched the knowledge of Excel on top,you made us easy working in Excel, Thank you soooo much Teacher forever for your excellent Teaching

[@Innozant]

Thanks dear.Keep learning

[@virendrahardiya2797]

आज फिर कुछ नया सीखा है sir thank you so much sir ❤️💓🥳

[@vishalshelar697]

Best Teaching techniques, The way you are teaching is fabulous, superb..

[@Innozant]

Thanks Vishal ji..Happy Holi

[@amritathakur2036]

Super se bhi upar sir thanks 🙏 from heart 💓 many many thanks 🙏 sir ji

[@Innozant]

Thanks Amrita itne pyarse feedback ke liye..Ydi mere ye videos aapke life me value add kar paa rahe hain to wo mere liye har fees se badhke hai.

[@RohitKumar-cc7zi]

Dear sir, this one is Superb , again big heart thanks a lot. And most of the thing you have a great way of Presentation. I want meet you one to one uf possible in life. Great thanks again

[@Innozant]

Thanks Rohit Ji..Offcourse dear ,Will meet ❤🙏🙏Have a wonderful career ahead

[@E_K18]

Thanks for your knowledge in Videos sir. For your students like me who take break from excel for years, these are your blessings❤

[@Innozant]

😊👍❤️Late nhi hue hai ..Keep exploring ❤️

[@Jishayaful]

Best teaching sir. Thank you for sharing your knowledge with the world.

[@Innozant]

Thanks Jishaya for such a wonderful feedback.Hope these videos add some value in your life.🙂❤️👍

[@arunkumarsinghark3024]

Amazing sir ji thanks continue to 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l

[@hemantgusain1260]

Thanks you sir, your knowledge of excel is unbeatable.

[@Innozant]

Thy Hemant Ji..Hope you are Learning and enhance skills on regular basis.❤️👍

[@sandeepaswal8944]

No Word No Word Sir ji❤😘 New concept new skills today I learned. You are marvelous. You are best mentor. I love it your all videos.

[@Innozant]

Thanks Sandeep..Hope you like Getpivotdata funcation and find it beneficial 👍🙏❤️

[@user-hq5gr9hk1j]

Very well explained

[@Saurabh-Yaduvanshi.]

Mahan Ho Sir Aap

[@powerbiselfstudyguide]

Excellent, Keep it up!

[@ishantsonker5787]

I appreciate ur efforts... Sir.

[@Innozant]

Thanks Ishant Sonakar Sahab 👍❤️🙏

[@ishantsonker5787]

"Sonakar" nhi sonker... ☺ sir....🙏

[@monalisa_ghosh1]

Thnq sir for sharing ur knowledge with us❤️

[@Innozant]

Keep learning and Exploring..Do practice on regular basis

[@dominatorgaming2980]

Very informative video

[@abhisheksinghal7525]

What if we take 2 value fields in pivot and shift the values to rows and want to get data for both value fields

[@arunkumarsinghark3024]

अति सुंदर सर जी धन्यवाद्, getpivotdata formula पर और अधिक videos बनाए सर please please please, 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l

[@surajsinghrajput9321]

Superb sir.👍🔥

[@Innozant]

Thanks Suraj 👍🙏❤️

[@user-te9yg8nl5h]

Sir when I am using getpivot on the bigger data you showed us regarding agent and acctype I am getting a REF! error?

[@merichitrakari]

Thank u sir ❤❤❤❤❤

[@vishalshelar697]

Thanks alot sirji

[@Pro-Tips-Tricks]

Multiple columns text par hai, usko number format main lana in single time process. Possible?

[@balance1772]

Wow! Guru ji

[@saurabh17sharma68]

Great sirji

[@Innozant]

Thanks Saurabh.🙏👍❤️

[@rubayyanitu4300]

How can i use this formula by external excel documents

[@Rejuanhaque]

Mind blowing Sir

[@Innozant]

Thanks Zoie Raem❤️👍

[@mamtamishra7882]

Thank uh sir

[@Innozant]

Thanks Mishra ji

[@jaiarora4473]

U r great sir

[@Innozant]

Thanks Jai.Happy learning

[@MithunSapui]

Thank you Sir

[@pareshparikh7944]

Very good sir

[@Innozant]

Thanks Paresh ❤️🙏

[@dhavalgorasia3068]

hi, I have pivot in another sheet and I'm using getpivot formula to get the values, but I'm getting reference error even though I have added the right reference.

[@puransingh-sx2tk]

Guru g more vedios on pivot table with dashboard plz😂😊 ye dil maange more 👍✌️

[@Innozant]

Koshish jaari hai.👍🙏❤️

[@vipulbeerupadhyay9459]

Sir mera mis ka course complete hai aur mai apka video mis interview cracker bhi dekh rha hu

[@amitsw21]

Thank you,

[@Innozant]

Thanks dear

[@shahidalikhan9503]

Sir not apply automatic get pivot data in my sheet.

[@hemgandhi8087]

Thankx

[@kinghundred]

very useful sir

[@vimaldewangan9309]

Very interesting

[@deepakchauhan4974]

Sir, ye formuale jab mai excute kiya to ho gaya, lekin kya sir is se bas koi do chiz hi hum nikal sakte hai kya, multiple date get kar sakte hai ya nahi, agar kar sakte hia to kaise

[@rahulrakshe1988]

Very nice

[@ANILTV82]

is it possible to Pull values based on both agents & branch?

[@Innozant]

Yes ..why not

[@MithunSapui]

Sir, PIVOT data me agar 2 category rahega, toh getpivot kaise kam karega?

[@MithunSapui]

I mean to say Colum me month v hai year v hai. tab kaise kam karega?

[@Innozant]

Do criteria based field aur item ki value pick krenge

[@amandeepbadgujjar7096]

Hello sir 🙏, sir mujhe formula likha or ase hi jese apne bataya, lekin mujhe #REF error Mila kyu? plz reply 😇.

[@AnshulMarele-gbaa]

How to return row data, not value column(s) data

[@excelsolutions.7167]

Sir agar koi lead I'd August month me reject ho or wo lead I'd is month me approved ho jaye to aisa kon sa formula lagaya ki us lead I'd ka count us month se hat ke is month me add ho jaye

[@Innozant]

Customized formula apne requirements ke base par likhiye.maise kuch specific option nhi h available

[@shaikh9394]

sir jo last mai aap ne getpivotdata laga kr just datfield select ki to sb information agai thi but meny jb kiya koi information nahi arhi hai please btai kia problem ho skti hai

[@Innozant]

Ek baar phirse video dekhke apply kriye kuch galati kr re honge

[@tonightdiary86]

wow dynamicallty of pivot table

[@successmaharjan2906]

Thank u

[@kavita8390]

Excellent video… I have one silly question, while applying formula which key are you pressing to deactivate/ hold for a while and navigate to data fields.

[@Innozant]

Hahahaha..Kavita before = just give space to deactivate it for a while then again remove space from there to activate our formula .♥️♥️♥️😀happy Learning

[@ajaykumar-hu3py]

kindly make video about power pivot

[@Innozant]

Aayega dear..have patience..abhi to excel khatam kr lein pehle 👍❤️🙏

[@tejpalsain1507]

Thanks sir.

[@Innozant]

Thanks Tejpal Ji👍🙏❤️

[@vipulbeerupadhyay9459]

Mis job ke liye kaise aply kre

[@nitinrautela5561]

Sir koi power query aur Powerpivot ki series bana do bhut demand hai ajkl uski

[@Innozant]

Aayega dear..❤️👍

[@MohdTaufiqKassim]

Hello Mr. Dinnozant : You have make Statement of V-Look and GetPivotdata yrself u have have not teach us how u make this both statement I have not understand yr solution ?? pls expedite ?? Regards M.Taufiq Karachi Pakistan

[@lkumar2727]

Power pivot par video banaiye.

[@Innozant]

Pehle Pivot to khatam Ho Jaye 🙏👍❤️

[@GauravSharma-iu5mr]

Best yr

[@omkumarsharma2242]

Kaise kar leteho..good

[@gauravbhatia7987]

Thnq sir

[@arunkumarsinghark3024]

हम आपसे कैसे संपर्क करे l कृपया आप मदद करे और जानकारी दे l

[@vishalpal4396]

Sir mujhe ek interview ki sheet bhejni h apko kaise bhuje?

[@Innozant]

@innozantofficial telegram id

[@vishalpal4396]

@@Innozant sent

[@chayankumar8061]

sir i am pleased

[@Innozant]

❤️🙏

[@knowledge-withfriend2686]

Nice

[@Innozant]

Thanks Dear 🙏👍❤️

[@arunkumarsinghark3024]

Sir, मेरी कुछ Excel Queries है ऑफिस से, कृपया मार्गदर्शन करे l, Queries solve करने मे please help me sir, आपसे बहुत उम्मीद लगा है, दिल मत todiyega l🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l

[@kunarmodi]

09:44🤣🤣🤣

[@s.surenderrao3854]

Dear Sir, please give a solution on calculation of "growth rate" on consecutive years/ months

[@Innozant]

Ok.Rao Sahab will make a seprate video for the same.

[@FranceTurkiye]

I wish wish the video was in English as its title.

[@Innozant]

😊❤️

[@sagardeshwal7612]

Sir please make a video on invoice matching concept For example if an invoice no is ABC/2019-20/015 and another invoice is 15. In substance they both are same but how we can match each other by using formula

[@Innozant]

Acha Kisi video example me add kr denge 👍❤️🙏

[@SanjayKumar-uw9kn]

🙏

[@Innozant]

Thanks Sanjay Ji👍❤️🙏

[@sagararora8040]

present sir

[@Innozant]

Good 👍❤️🙏

[@ashu1303tilwar1991]

I am getting excel learning from HARDY SANDHU

[@Innozant]

❤️👍

[@MohdTaufiqKassim]

Mr. Dinozant I am yr permanet Student ?? Karachi Pakistan M.Taufiq

[@Innozant]

👍🙏

[@arnavaj3392]

kuch b nhi bhut kuch h isme

[@bishtlokesh1297]

You begun to hard work too much for excel users

[@Innozant]

Thanks Lokesh for your support and valuable comment.👍🙏❤️

[@bishtlokesh1297]

It's my duty