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

    Frequency of Dates within a certain week

    Hi All, On the Target tab I need to count the number of times dates occur within a week on the Actual tab. Should be a straight forward COUNTIF but I can't seem to get it right so your help would be appreciated. Thanks
  2. S

    Help with Count Formula

    Hi, I have 2 columns, one with the Ext number (e.g 3201) and another with type of telephone. At the moment I had a formula =SUMPRODUCT((Telephony!H10:H145={"Analogue Phones"})+0)to just count the telephones but now some people have put the ext as "broken" instead of putting their ext number in...
  3. S

    Drop Down Lists on Excel 2010 vs 2007

    This is driving me up the wall so any help would be appreciated. Created multiple tabs in Excel 2010 with all drop down lists on one tab. Works fine in 2010 which is used internally. When I e-mailed it externally people using 2007 started complaining that drop downs can't be viewed. I...
  4. S

    How to auto populate a day on entering the date

    Hi, Newbie here having the discovered the site today. Brilliant site and thus have registered and added to favourites and told colleagues about it. The query that made me find the site is: I have a large row of dates in Column C. In column B I want excel to autopopulate the day of the week...
Back
Top