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

  1. B

    Return Multiple data from a data set

    Above is a small extract from a large data set, based on the department name selection in A13 I would like to extract all relevant data in the grey area and put into the green section - see in this example I would expect to see 3 lines of data relating to IT. A formula based approved is what I...
  2. B

    IF/AND/OR Statement

    Trying to set up a formula to return the following. A B C Y Y 1 Y N 2 N Y 3 N N 4 What would be the formula be in C1 to return any of the combinations above. Thanks in advance.
  3. B

    Extract Name from text string

    Thank you very much for the solution.
  4. B

    Extract Name from text string

    BILL PAYMENT VIA FASTER PAYMENT TO ABC Ltd REFERENCE UK , MANDATE 333 BILL PAYMENT VIA FASTER PAYMENT TO ACME LLC REFERENCE UK , MANDATE 375 TRANSFER TO A1 PUMPS Ltd REF: 1234 Dear All Above is an extract from a report (3 entries) - but two different text strings. I need to remove the company...
  5. B

    Scroll Bar on an Excel Listing

    Faseeh Thank you very much for the reply and the working example. Regards Badger
  6. B

    Scroll Bar on an Excel Listing

    Dear All I have a spreadsheet that contains 200 Rows for data entry (and several columns) - ideally I only want to show 20 lines at a time. Can a scroll bar embedded into the spreadsheet allow me to do this - if so how can this be achieve. Thanking you in advance.
See more
Back
Top