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

    Certain value according to a string text

    Hi, In a database I'm using, column A is the Date. Based on the value the cells from that column I built a formula so that I get the month name: =IF(AND(A3>=41275,A3<=41305),"January",IF(AND(A3>=41306,A3<=41333),"February" etc. The format of the cells in column A has to be changed and...
  2. G

    Compile various data from 2 lists into one [SOLVED]

    Hi, In a file I am working on I have to add 2 information (which is selected from 2 lists) to a given event name (1 text information before the event name and 1 text information after the event name) and display it in a cell. For example: Event name - Christmas 1st information - Schools...
  3. G

    Bold for 1 word in VBA [SOLVED]

    Hey, I have the following code: ElseIf UCase(e.Cells(xee, 5).Value) = "SCHOOLS" Then o.Cells((6 * (j - 1) + q), 6).Formula = "[Sch]: " & e.Cells(xee, 3).Value It does the following thing: when 'Schools' are selected from a drop-down list, '[Sch]:' text is displayed in the sheet that...
  4. G

    Calendar for 2013 - 2020

    Hi, I have received this Excel calendar template file: http://db.tt/eUVa1G60 The requirement would be to modify it in order to add events in the database for at least year 2013 (but it would be perfect to be able to also add for 2014, 2015 and so on) and the calendar (the Overview and each...
Back
Top