Search results

Hello Hui, What is the output of these Controls going to be used for? This technology can be used for so many subjects, for example, end user can select the entries and pull members for a state or for a specific city. Slicers can work; but I really like learning how to build synched combo...

Hello Hui, I have two List boxes; I want the end user select a state from a list box and only the cities for that state to show in the second list box. To map correct cities for correct states, I had to repeat name of states. ---------------------------------------------------- Hui: I have...

I will do it soon. Regards, GN0001

==================== If I want to create two synchronized combo boxes in Excel, can this be done by macros? GN0001

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

You can see the output in sheet2. I don't know how to use VBA code. Please send functions. Regards, GN

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

Yes, I saw that is addressed before. Thanks for it. 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

How about using DateValue function? GGGGGNNNNN

------------------------------------------------- Hello Narayan, Does it have the same definition in Excel? Thanks, GGGGGNNNNN

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, I did exactly the same thing. Two sheets are giving errors. It seems it has improved up to 80%. Regards, GGGGGNNNNN

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 Nebu, My problem continued with my workbook. For example, when I refresh the pivot table after I change the source data, the data doesn't get refreshed. Can you think of other causes generating this problem? Some of the rows become hidden after I refresh the data; and I can't unhide them...

The names are random and I come back to you with a sample book. Thanks GN0001

My problem is resolved. Bless you! GN0001

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 Nebu, Thanks for the answer, I want to select several items in a pivot table filter. Advance filter becomes inactive/ dim when I click on one of the cells in Pivot table. Thanks for the answer. GN0001

If I need only George, Brenda, James and Ely to be selected, how can I proceed? Regards, GN0001

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 found the solution. Pivot table filter sometimes retains old data in its filter, even if we have deleted the row. We need to go to Pivot Table option and go to data tab and put to none the drop down menu for "Number of items for retain per field". Thanks for all, GN