• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by GN0001

  1. G

    Are Macros enough for automating reports in Microsoft Excel?

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

    Are Macros enough for automating reports in Microsoft Excel?

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

    Are Macros enough for automating reports in Microsoft Excel?

    I will do it soon. Regards, GN0001
  4. G

    Are Macros enough for automating reports in Microsoft Excel?

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

    Are Macros enough for automating reports in Microsoft Excel?

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

    Start.xlsb file

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

    Cell changes from text to number

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

    How can we fill out the values:

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

    How can we fill out the values:

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

    Combine 3000 Excel Spreadsheets

    Yes, I saw that is addressed before. Thanks for it. GN
  11. G

    Combine 3000 Excel Spreadsheets

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

    Highlight dates and using ? change from 9/9/2015 to 09/09/2015

    How about using DateValue function? GGGGGNNNNN
  13. G

    Percentile

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

    Percentile

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

    I put the whole function in one cell

    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...
See more
Back
Top