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

Search results

  1. N

    How to default Excel 2010 to open any excel file when 2010 and 2013 installed

    I have installed Excel 2010 and Excel 2013. Those are working fine. When I try to open any Excel workbook from any location, it opens a blank Excel Workbook with Excel 2010 without opening that workbook. If I open Excel using Start>Microsoft Excel 2010 or Microsoft Excel 2013 and then Ctrl+O, I...
  2. N

    PowerPivot installed but not shown on Tab

    Operating system Windows 7 Microsoft Office 2010 I have installed PowerPivot (32 bit) successfully. PowerPivot for Excel is shown in the list "Interactive Application Add-ins" from File tab>Options>Add-Ins When I have selected COM-Add-ins from Manage list and selected GO, PowerPivot for Excel...
  3. N

    RANDBETWEEN-Creating a Lottery Engine

    Dear Forum Members, I want to create a lottery engine using RANDBETWEEN. I will click on a command button and get a new lottery number within 1001 to 1500 every time. We will have to consider....... 1. Ticket serial from 1001 to 1500 2. 20 gifts will be given 3. No duplicate lottery number...
  4. N

    Individual values in the list under data validation

    Dear Forum members, My data in the sheet1 Dept Product ------ --------- ESL 100 Watt ESL 50 Watt ESL 30 Watt ESL 23 Watt ESL 17 Watt ESL 13 Watt ESL 07 Watt Oil 1 Oil 3 Oil 5 SPT Gasket SPT Spark Plug SPT Valve SPT Nut #1234 SPT Nut #5678 SPT Bolt#1234 SPT Bolt#4567 I want...
  5. N

    Finding out new codes in a sheet those are not existing in another sheet

    I have two sheets. In the sheet COA the values are ----- ----------- Code Description ----- ----------- 1001 AAA 1002 BBB 1003 CCC 1004 DDD 1005 EEE 1006 FFF 1007 GGG 1008 HHH 1009 III 1010 JJJ In the sheet TB the values are (more than 50,000 rows) ----- --------- Code Value...
  6. N

    Data Loading in Combobox on Form from a range of Excel Sheet

    In the column A of Sheet1, I have typed regions ---------- Column-A ---------- Region-1 Region-2 Region-3 Region-4 Region-5 Region-6 I want to load this regions in the combobox1 This combobox I have added on Form1 How can I load this six regions from Sheet1 in the combobox1 on...
  7. N

    How to convert from NUMBER format to TEXT format to accept another software

    I have some data like... Column A 8230053400 8230051100 8220022300 8220023510 I need to upload the values of this column A to my accounting software. Condition-1 this data should be in TEXT format Condition-2 file should be .dbf In the excel sheet, I select the range and format it as...
Back
Top