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

    Inserting a signature into Excel worksheet

    I am working with Excel 2007. I have created a worksheet which requires a signature to be embedded at the appropriate place. I can insert a signature in .jpg or .bmp format into a spare area of the worksheet but I then have two problems.. 1. When I move the image to the area where the...
  2. T

    Reference to an external cell from within the text in a text cell

    I have a text box in one worksheet of a workbook which contains the following "For the year ending 31 March 2014 , the company was entitled to exemption ..... etc etc" I already have a cell in the worksheet which contains the phrase "year ending 31 March 2014". Is it possible to insert in the...
  3. T

    Pickup fixed values corresponding to variables in a growing table

    I tried to thank Narayan for his references to tutorials in my previous question but it would appear that my two attempts did not work. I hope that this one does and that someone can offer help in providing expressions in the attached spreadsheet.
  4. T

    The latest values in a block of data

    I have a potential block of data say from B5 to N10. - see attached spreadsheet Currently , there is data in B5 to I10 with Row 5 containing the date but the data block grows with time. What would be the formula to put in cells P6 to P10 which will extract the contents of the latest column of...
  5. T

    Information from a block of data

    I have a potential block of data say from B1 to AA10. Currently , there is data in B1 to Z10 with Row 1 containing the date but the data block grows with time. What would be the formula to determine the contents of the last column of each row i.e the contents of Z2, Z3 , Z4........ Z10 ? In...
  6. T

    Inserting a date in a cell from a displayed calendar

    I have tried searching the web for this answer but everything seems too complicated. I had one hit on a YouTube demo but it was too quick to follow and did not give any monologue. I have a column of cells (20 -24 different dates) into which will be added a date from week to week. Format should...
  7. T

    COUNTIF "*" appears to be counting blank cells !

    I have produced an Excel Workbook which has various macros within it – developed with the help of people on this superb website. However , I have noticed a quirk which I cannot understand and therefore cannot correct ! HELP PLEASE ! The workbook is a leaderboard system for my golfclub which...
  8. T

    Switching Print Preview on and off in VBA

    Apologies if this subject has been dealt with before. It appears to me that the website does not have a search facility. Am I wrong ? I have wanted to produce a macro within a spreadsheet which prints out the sheet without using the print preview which is ticked as a default. Having used the...
  9. T

    INDEX /MATCH WITH MULTIPLE RESULTS

    Index / Match with multiple results I have been struggling with this for some time and would appreciate some help. I have been trying to use the Index / Match combination but realise that , because there is more than one line of results for any person’s name , I need to be putting a formula...
  10. T

    Password for the website

    I am not sure whether this is the place for this question or not , but I could not find an answer elsewhere. How can I change my password for this website ?
  11. T

    Using INDEX and MATCH but creating a message to indicate absence

    This is my first use of this website and when I found it I thought how good it was. Here is my problem. I have been using INDEX & MATCH but struggling to get the syntax for the following scenario. Simplifying will enable my problem to be explained better. I have a list of names in an Excel...
Back
Top