Search results

Hello Narayan, I have refreshed the pivot table. Regards, GN

if i have understood it correctly] Have you tried double clicking the item. ------------------------------------------------------------ I start Filter, in search box, I unselect every entry and then I enter 3626694 and it shows 3626694 is the content one of the cells. when I select the item...

Hello team, -I filter a list (which is a pivot table), the column header is identity, I put a filter on identity header and filter on item 3626694. Item 3626694 is displayed in the filter result, when I select 3626694, only blank rows are displayed. Why is not item 3626694 displayed? I...

I will try it and get back to you if there is any further issues. Thanks for your time to reply to this request. GN0001

Hello team, I am working on two Excel workbook and I am trying to copy and paste some stuff from one workbook to another workbook. It doesn't allow me and it says: too many formats. I cleared format and I cleared all, still I can't copy and paste. Even I cleared all the objects, I started a new...

Narayan, What you said on concatenating name and address is correct; I agreed at it from the beginning. I am saying that using countIf to create numbers such as 1,2,... and then concatenating to the lookup name is not a solution. Since George 1 sheet 1 might not be as Geroge 1 in Sheet 2. So...

Hello all, That is what I am trying to say that we can't only use countif for creating unique values out of duplicate values. I have no idea what logic we need to have, I only know that using CountIf along with concatenation can't be enough for creating unique values. As you say there should...

Thanks for he response and you look up function. GN0001

Yes, to get the right match, we need to use concatenate rather than CountIF function. Chandoo shows to create unique values for look up functions when we have duplicated values. To me, this approach can't be correct because of the reason I showed on the loaded workbook. Thanks for all. GN0001

Hello All, We know that we can create unique values when our look up values are duplicated. If we are going to do a look up function and we map George1 in sheet1 to George1 in sheet2, then we have not done a right match. Since the true match of George1 in sheet1 is George2 in sheet2. Any...

It is fixed....! Thankkkk you very much:DD

Hello team, I am enrolled in Chandoo's power pivot course. I was doing my homework, my computer got disconnected and my power pivot option can't be added to my Excel workbook. I can't attach the file to this post. When I go to Microsoft Excel and developer tab to add com add-In. It says: Load...

'=VLOOKUP(1088,CHOOSE({1,2,3},$D$5:$D$17,$B$5:$B$17,$C5:C17),2,0) If we search for the value in Array: $D$5:$D$17 and then return corresponding value from the array: $B$5:$B$17 Then why do we bring up array:$C5:C17? ---------------------------------------------------------------------- What...

How does this array choose function work? =CHOOSE({1,2,3},$D$5:$D$17,$B$5:$B$17,$C5:C17) Thank you for the help, GN0001

Now I want to import the data into Excel from an Excel workbook, I can't. The connection is not set. Thanks. GN0001

Hello Somendra, Thank you so very much for your answer. :) I don't want to bring the data into Power Pivot window with linking to the original data. As I said on my first post: (Please note, I am not trying to import data to Power Pivot window, because in that case, there is a chance a new tab...

Hello Team, I need to copy some data to Power Pivot window. I open Power Pivot window and paste the data from Excel workbook. Now, I want to paste the second set of data to Power Pivot window; should I start a new Power Pivot window? Should I insert a new tab in Power Pivot window? (Please note...

Hello team, In Power Pivot: When we import data from external resources to Power Pivot, if the header column has the unwanted characters, Power Pivot take them off automatically. What happens if the field itself has spaces, invisible characters or unwanted characters? Like when do vlookup if...

Hello Chandoo, Yes, in your video, you show more Excel 2010 and I can see that you have power view in 2010. My Excel 2010 has power pivot by default which I checked, but it doesn't have power view and when I want to download it from the link that you suggest us to download from take us to...

I understand this, but Chandoo's video shows that power view is available to Excel 2010 and the link he tutors us takes us to Microsoft SQL Server 2008 R2 Power Pivot for Microsoft Excel 2010. When I download the file, I can't install it, it interrupts. Thanks GN0001

Hello Chandoo, On your video, you are showing that how to add Power Pivot to Microsoft Excel and along with that, power view comes. I can see in the video (first session), your Microsoft Excel 2010 has power view in addition to Power Pivot. Having said that, It is available to Excel 2010. I...

Hello team, I have enrolled in Power Pivot class with Chandoo. My Microsoft Excl is 2010. In my add-in list, I only have Power Pivot, Power Pivot view option is not there. Based on the instruction of Chandoo, I have downloaded the power pivot view feature. The name of application is being...

Hello Narayan, I have read your response long time ago, I was thinking about it. Thanks a lot for you response. From what you say function can only be entered in a standard code module, they can't be entered in: any Sheet section , in the ThisWorkbook section. Would you confirm this? GN0001

Hello Narayn, I understood why it is not being shown in the list of Macros. What would be the corresponding function on the spreadsheet for this code? I enter as =Str(A1), it gives error message as #Name? I enter as =ToNum(A1), it gives error message as #Name? I appreciate your response. I...