Search results

Hello team, Are macros enough for automating reports? Please advise me. GN0001

Team, I have recorded a macro (whenever I create a macro, my Excel workbook doesn't behave as normal and I am in trouble). -When I want to open my Excel workbook, my Excel workbook starts as a read only, how can I fix it? -I hid Personal.xls file, when I want to record a new macro, it says...

Hello team, I am working on a spreadsheet. The cells values are text, as soon as I copy the cell, it changes to number and drops the leading zeros. I have to change the cell again to text by going to format dialog box and I have to do it several times, until I get the values saved as a text in...

Hello all, I need the values of Category1 and Category2 and Category3 be placed in once column Test1, Test2, Test3 in second column I mean I need any entry in column c has category and test mapped to it. Any idea? Please open the attachment. Regards, GN

Hello team, Is it possible to combine the data inside of lots of Excel Spreadsheets? Please advise me. How about VBA code? Thanks, GGGGGNNNNN ------------------------------------------------------------------------------- Mod Edit: Question moved to VBA section

Hello all, If we have values such as this: Statistic Value(hours) 25th Percentile 1.88 75th Percentile 5.68 90th percentile 10.37 Does that mean that 75% of values are equal to 5.68 or less than 5.68 and 90% less than 10.37 or...

Hello team, This is my function; I put my function in a cell: =IF(OR(LEFT(F2,3)=$V$2, LEFT(F2,3)=$V$3, LEFT(F2,3)=$V$4, LEFT(F2,33)=$V$5, LEFT(F2,3)=$V$6),"GG","ME") It gives me error. Unless I do Left function first and then on the next cell, I should use OR function on the result of Left...

Hello team, I have started working for a company. They have a workbook; and each time, I come to close it: It gives a message as: -Check online for a solution and restart the program -Restart the program The workbook is a shared workbook. I disabled all add-ins and I saved it as Excel-book...

Hello team, My pivot table doesn't refresh. My coworker's does. What is the problem? I know there are rows in the source data, but it is not shown in my pivot table. Regards, GN

Hello team, I am going to filter the entries of a column. I don't want to go by unselecting all the entries and then going through the filter and select those ones which I need. I can type in the name in the search box of a filter. then I select the first entries in the list. Now, how can I...

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

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

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

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

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

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

I have a VBA code to trim the value in the cell: Function ToNum(X as Variant) As String Dim A as String A=Trim(str(x)) ToNum = A End Function I inserted this code on the code sheet of sheet 1 and I also inserted a module and write the code there. I can't see the code in the Macro Dialog...

Hello team, I have put a sumproduct function to summarize the data. How can I put the data/ ranges in the spread sheet to bring every thing. This is my range: Name Project Name Date Value SumProducts returns George A First Week...

If we have two arrays such as {1,2,3,4} and another array as this {4,5,6,1} If we are going to compare these two arrays, is this how the arrays are compared against each other? 1 is bumped against 4, 5, 6, 1 Then 2 is bumped against 4,5,6,7 Then 3 is bumped against 4,5,6,7 Please advise me...

Hello all, I am doing a conditional formatting on a column and I want to use this option: Use formula to determine which cells to format, this option doesn't work at all, (The other option: format only cells that contain works partially!). Can anybody help me on this, please? Thanks, GN0001

Hello All, I have two lists, I need to match these two lists through their texts? is this possible? If one part of text is found in another text , we need to take these two cells as matching values. The reason for doing this is the first list is mapping to some ids and the second list is...

Hello Team, I am using VLookUp function and each time I have to change the source data. but when I plug in the new data (copy the new data into the sheet from which VLOOKUP function brings back the value), the VLookUp doesn't show the result and I have to re-enter the funtion to be able to pick...

Hello team, I have to paste lots of rows to another workbook, the first workbook is a time sheet. it has columns as: project name, sub project, days of the week and date (which is the first week of April). If a project Manager has worked on a project on Monday, Tuesday and Wednesday (days are...