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.

[@aabdullahhaasnain7033]

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

[@Innozant]

Thanks dear..Happy Learning ❤️

[@HaseebMirza-f8y]

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

[@monysain6762]

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

[@Innozant]

Thanks Mony..Keep Learning

[@virendrahardiya2797]

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

[@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

[@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

[@pravinkumbhare1750]

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

[@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.

[@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

[@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

[@arunkumarsinghark3024]

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

[@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

[@vishalshelar697]

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

[@Innozant]

Thanks Vishal ji..Happy Holi

[@arunkumarsinghark3024]

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

[@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.🙂❤️👍

[@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 ❤️

[@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

[@monalisa_ghosh1]

Thnq sir for sharing ur knowledge with us❤️

[@Innozant]

Keep learning and Exploring..Do practice on regular basis

[@ishantsonker5787]

I appreciate ur efforts... Sir.

[@Innozant]

Thanks Ishant Sonakar Sahab 👍❤️🙏

[@ishantsonker5787]

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

[@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

[@powerbiselfstudyguide]

Excellent, Keep it up!

[@surajsinghrajput9321]

Superb sir.👍🔥

[@Innozant]

Thanks Suraj 👍🙏❤️

[@dominatorgaming2980]

Very informative video

[@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

[@balance1772]

Wow! Guru ji

[@puransingh-sx2tk]

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

[@Innozant]

Koshish jaari hai.👍🙏❤️

[@rubayyanitu4300]

How can i use this formula by external excel documents

[@Pro-Tips-Tricks]

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

[@mamtamishra7882]

Thank uh sir

[@Innozant]

Thanks Mishra ji

[@shahidalikhan9503]

Sir not apply automatic get pivot data in my sheet.

[@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.

[@MithunSapui]

Thank you Sir

[@saurabh17sharma68]

Great sirji

[@Innozant]

Thanks Saurabh.🙏👍❤️

[@jaiarora4473]

U r great sir

[@Innozant]

Thanks Jai.Happy learning

[@Rejuanhaque]

Mind blowing Sir

[@Innozant]

Thanks Zoie Raem❤️👍

[@kinghundred]

very useful sir

[@vipulbeerupadhyay9459]

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

[@pareshparikh7944]

Very good sir

[@Innozant]

Thanks Paresh ❤️🙏

[@amitsw21]

Thank you,

[@Innozant]

Thanks dear

[@vimaldewangan9309]

Very interesting

[@hemgandhi8087]

Thankx

[@rahulrakshe1988]

Very nice

[@AnshulMarele-gbaa]

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

[@ANILTV82]

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

[@Innozant]

Yes ..why not

[@ajaykumar-hu3py]

kindly make video about power pivot

[@Innozant]

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

[@successmaharjan2906]

Thank u

[@tonightdiary86]

wow dynamicallty of pivot table

[@tejpalsain1507]

Thanks sir.

[@Innozant]

Thanks Tejpal Ji👍🙏❤️

[@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

[@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

[@nitinrautela5561]

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

[@Innozant]

Aayega dear..❤️👍

[@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

[@GauravSharma-iu5mr]

Best yr

[@gauravbhatia7987]

Thnq sir

[@lkumar2727]

Power pivot par video banaiye.

[@Innozant]

Pehle Pivot to khatam Ho Jaye 🙏👍❤️

[@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

[@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

[@vipulbeerupadhyay9459]

Mis job ke liye kaise aply kre

[@chayankumar8061]

sir
i am pleased

[@Innozant]

❤️🙏

[@omkumarsharma2242]

Kaise kar leteho..good

[@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

[@FranceTurkiye]

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

[@Innozant]

😊❤️

[@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.

[@vishalpal4396]

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

[@Innozant]

@innozantofficial telegram id

[@vishalpal4396]

@@Innozant sent

[@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 👍❤️🙏

[@knowledge-withfriend2686]

Nice

[@Innozant]

Thanks Dear 🙏👍❤️

[@arunkumarsinghark3024]

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

[@amandeepbadgujjar7096]

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

[@arunkumarsinghark3024]

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

[@kunarmodi]

09:44🤣🤣🤣

[@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