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

    Charting

    Hello, How can we conditionally choose data for charting? I mean for a certain value, a chart will be made for a range of cells, for another value the chart will be for another range of cells, but appears in place of the first chart. I hope I am clear.
  2. A

    Find Button

    Hi, Could you please help me program a find button in excel 2010 step by step?
  3. A

    Cell copy

    In A1 I have a formatted text ( underlined, coloured ... ), in B1, I have this formula (=A1), but the result is just the text without formatting. How can I get the text with all the formatting in B1?
  4. A

    IF(OR

    The =IF(OR ... formula accepts only 64 threads. Is there any way to double that number?
  5. A

    Chart Conditional formating

    How can we conditional format charts so that the columns change colours according to given values or ranges?
  6. A

    Imaging

    Hi all, Please look at this file: https://skydrive.live.com/redir?resid=D2EB358351CED728!113 When you click anywhere on the text, an image of it pops out. How is this done?
  7. A

    hide worksheets

    Hi all, I have a workbook of several worksheets. I have a worksheet at the beginning with an index to all the other worksheets with hyperlinks. When I click on a hyperlink, the related worksheet opens. Now I want to hide all the worksheets. I did this. But when I click on the hyperlinks in the...
  8. A

    blog view

    hello all my browser showcs chandoo blog like mobile style. Can it be changed to the original PC view?
  9. A

    sort data differently

    3USD 4USD 5USD 6USD BOOK EARRING NECKLACE BELT BELT BOOK FLASH MEM BOOK I want to sort this data like this: BOOK EARRING NECKLACE BELT FLASH MEM 3USD 4USD 5USD 6USD...
  10. A

    autofilter buttons

    Hi all, I have a worksheet that have about 5000 entries. These have to be filtered according to different criteria. Now, I need to have a cover page with buttons. Each button is named after one of the filtering criteria. When this button is clicked, filter is applied and the result is shown in...
  11. A

    extract numbers

    How can we extract numbers from cells that contain both text and numbers and put the numbers in separate cell?
  12. A

    put records in order

    Ihave alist of items in alphabetical order. I need to put new records in order automatically when i add them at the end of the list.
  13. A

    Cross reference issue

    I have a table of 20 rows and 6 columns (A1:F1) Headings: A1 (NAMES ) , (B1:F1) PROFESSION1 to PROFESSION5. The names are then distributed in the table according to nationality. I need to create another table from the original one in which I want the A column showing all the names, and instead...
  14. A

    hyperlinks

    Hello all, I have a nasty problem which annoys me a lot. When I try to open hyperlinks in excel 2010 I get this message: The operation has been cancelled due to restrictions in effect on this computer >>> Has anyone got a solution for this problem, please?
  15. A

    counta crosswise!

    Hi all, what formula to use to count the cells that are not empty in a row?
  16. A

    headings

    Hello everbody, I'd like to create rounded-corner headings in my worksheet because they are more eye attractors. Can any one help me do this?
  17. A

    formula register

    Hi all, Is there a way to automatically copy every formula I put in my workbook into a seperate sheet in order to keep track of all formulas?
  18. A

    worksheet display

    Hi all, Is it possible to display two worksheets from the same workbook at the same time so that we view the changes in one worksheet when we enter data in the other? How can this be done?
  19. A

    interactive sales chart

    Hi all Have you seen Chandoo's interactive sales chart? It is fascinating. i want to make one, but I did not get it right. Here is the worksheet I want to make the interactive chart for. Can anyone help me, please? http://www.4shared.com/file/191HytlH/My_School_data.html
  20. A

    data filtering

    Hi all Sometimes we need to filter data according to different criteria. My question is how to have the number of the resulting data in a separate cell ( in the heading row for example )?
  21. A

    worksheet size

    Hi, In a multi-worksheet workbook, is there any way to know the size of each worksheet in MB?
  22. A

    empty rows

    Hi all, I have a list from which I take some values using "If(and " formula. The values I get have empty rows between them (naturally). What formul can I use to eliminate these empty rows and have all the vlues in sequencce in a fresh list?
  23. A

    Conditional Fotmatting based on several columns!

    Hi all, I have this spreadsheet: A1:U20 I want to conditionally format the cells in column A when the cells in column ( I ) OR the cells in column ( M ) OR the cells in column ( Q ) or the cells in column ( U ) are less than 60. Can you please help me write a suitable formula? Thanks
  24. A

    save closed files

    Hi all, I have a large excel (.xlsx) file. It won't open . Can I save it to another format although it is closed and won't open so that it can be opened? It is 48 MB large. Thanks all.
  25. A

    extracting data in a raw

    Hi all, I have a worksheet A1:F10 which contains data text and numerals. In A15 I may choose any value from A1 to A10 I want a formula that displays the values that are in the same raw as the value I choose from A I hope my explanation is understood. All help is highly appreciated
Back
Top