Pivot Table GETPIVOTDATA Function in Excel & Google Sheets

No video

Pivot Table GETPIVOTDATA Function in Excel & Google Sheets

Рет қаралды 8,768

Learn Google Sheets & Excel Spreadsheets

Күн бұрын

Пікірлер: 24

@lpanebr Жыл бұрын

OMG, this simplifies a lot of complex workarounds! 🤯 Thank you! 👏🏼👏🏼👏🏼

@ExcelGoogleSheets Жыл бұрын

👍

@ivanolivo2936 4 ай бұрын

This video literally saved my life!!!

@kasralotfi 5 ай бұрын

Great video - you are master of breaking down a topics to pieces and building up toward complete solution - rare talent. One question: would it be possible to use GETPIVOTDATA function inside pivot table? For instance in your example, adding another column that woutld calculate % of sales made by each sales person (eg Grace's Sales/Total Sales)? Thanks again

@jonathanlance2166 Жыл бұрын

Thanks. You solved a big problem for me. I was currently doing it manually.

@ExcelGoogleSheets Жыл бұрын

👍

@VIJAY-pd4jt Жыл бұрын

excellent Sir

@selcukmutlu1761 8 ай бұрын

Thanks a lot

@eddiepersa1752 Жыл бұрын

Thanks for this tut as always !!! I have a question: Is there an app for android that connects to a google sheet to save data from the cell phone ? thanks !!!!

@JerryEduardo Жыл бұрын

Very good! Thanks

@ExcelGoogleSheets Жыл бұрын

Thank you!

@vinodkumarPrajapativnd Жыл бұрын

HI thanks for the very helpful video. I have one Question. Is there a way to get values entered by user in google form programmatically without submitting the form?

@ExcelGoogleSheets Жыл бұрын

No.

@temyraverdana6421 Жыл бұрын

Very interesting function. Thanks so much for the great explanation. I have a question: is it possible to group by day of the month even if I don't have data on some days of the month? I would like to have all the days of the month visible in the rows even if I have no data for that day. Thanks and see you next

@ExcelGoogleSheets Жыл бұрын

Not directly in the pivot table, but you could make a pivot table that doesn't have those days visible because there's no data and then make another grid where you list all the days & simply use getpivotdata function to grab the days available.

@temyraverdana6421 Жыл бұрын

@@ExcelGoogleSheets Thanks a lot for useful tip

@Dreamlight000 Жыл бұрын

Hello, This comment may be off topic from this video, but the some of the videos of similar topic were from years ago and wasn't sure if my comment would be seen. I have to say, I love your videos, very clear explanations and professional done. Thanks for making them. Any suggestion on how to replace this method of searching a cell with sentence like title of different words, from a list of specific words in a range to be searched? =IF(ISERROR(FIND("T-Shirt",A2)),IF(ISERROR(FIND("T Shirt",A2)),IF(ISERROR(FIND("Button Up",A2)),IF(ISERROR(FIND("Jumper",A2)),IF(ISERROR(FIND("Sweater",A2)),IF(ISERROR(FIND("Snow Jacket",A2)),IF(ISERROR(FIND("Jeans",A2)),IF(ISERROR(FIND("Jacket",A2)),IF(ISERROR(FIND("Pants",A2)),IF(ISERROR(FIND("Shorts",A2)),IF(ISERROR(FIND("Leggings",A2)),IF(ISERROR(FIND("Dress",A2)),IF(ISERROR(FIND("Blouse",A2)),IF(ISERROR(FIND("Polo",A2)),IF(ISERROR(FIND("Skirt",A2)),"","Skirt"),"Polo"),"Blouse"),"Dress"),"Leggings"),"Shorts"),"Pants"),"Jacket"),"Jeans"),"Snow Jacket"),"Sweater"),"Jumper"),"Button-Up"),"T-Shirt"),"T-Shirt") ~Thanks Mike G

@ExcelGoogleSheets Жыл бұрын

Looks like a VLOOKUP problem. What exactly is this formula doing?

@Dreamlight000 Жыл бұрын

@@ExcelGoogleSheets docs.google.com/spreadsheets/d/1n5b2zyC18ovXsI9YuuowbkTpVPSBoVG1NbOqg036VXQ/edit?usp=sharing

@Dreamlight000 Жыл бұрын

@@ExcelGoogleSheets Shared a link to example.

@Dreamlight000 Жыл бұрын

We have item specifics that get dictated or entered into a cell. The formula pulls out the word/s and they then eventually get added to a template to upload. It works but a pain to edit for a different item specifics. ~Thanks

@Dreamlight000 Жыл бұрын

Nevermind. Found a solution, this formula: =INDEX(SizeR,MATCH(TRUE,ISNUMBER(SEARCH(Size,A2)),0)) Thanks

@vinodkumarPrajapativnd Жыл бұрын

Hi, Now that Google sheet drop-down is updated. I am not able to paste comma separated values in the drop-down list. Is it still possible?