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

    SUMIF not working

    https://www.dropbox.com/s/xhmujsa3t1pn352/sumif.xlsx here is a sample file. Regards.
  2. I

    SUMIF not working

    my current formula on column D which is copied down to D12 since I have 12 unique occurrences C1:C12: =SUMIF(A$1:A$150,C1,B$1:B$150)
  3. I

    SUMIF not working

    I have encountered this problem before and after hustling with it for while, I decided to redo the data. I have 2 columns of data. column "A" with text, recurring in several instances A1:A150. column b has time in hrs:mins for the same range. The sumif therefore, on column "D" is to calculate...
  4. I

    copy cells with formulas and paste values

    Excellent. works like a charm!!! Thanks alot! -Injinia
  5. I

    copy cells with formulas and paste values

    Ninja, I have dates, index & simple sum formulas in these cells. I can't figure out what else might be different in my sheets This is what I have now: Sub TransferData() Dim LastRow As Integer 'Where is the last cell with data?(Data Archive) LastRow = Worksheets("Sheet...
  6. I

    copy cells with formulas and paste values

    Hi Luke, The sheet names are exactly the same. I do have 2 merged cells. Does that affect the functionality of the macro? When I run the macro now I get this error message: "unable to get the paste special property of the range class"
  7. I

    copy cells with formulas and paste values

    Hi, I am now reviewing this issue again... This macro gives me the following warning; "compile error syntax error". When I take away the last part of the macro ie (PasteSpecial xlPasteValues), it works fine. What could be wrong? I need to past the values only.. -Injinia
  8. I

    Dynamic Chart with Check boxes to change the x axis

    Here it is again https://www.dropbox.com/s/4ikdsjjzkob9y7y/Changing%20axis.xlsx
  9. I

    Dynamic Chart with Check boxes to change the x axis

    Hi ashl, It is possible to do what you want without VBA. I used Sreekhosh's file(hope he doesn't mind) to add your dynamic x-axis. Check out the file below, will this do? https://www.dropbox.com/s/4ikdsjjzkob9y7y/Changing%20axis.xlsx Regards, Injinia
  10. I

    Weekday Averages

    Hi, Thanks Faseeh, I have the days and dates in separate columns, so days Monday - Sunday are in their own column and not "Mon, September 10 2012". I tried to use the same formula to no avail... Should I have something different? -Injinia
  11. I

    Weekday Averages

    Hi, I have a range of data with with the first column(column A) being Days of the week ie Su-Sa. I would like to get the averages of the other INDIVIDUAL columns(not all of them collectively) of data if the week's day is only between Monday-Friday. Cheers Injinia
  12. I

    combo box calendar.

    EXCELLENT! Thanks -Injinia
  13. I

    combo box calendar.

    Hui, This works exactly as I would like. However, in 30 day months, the last cell is th first day of the following month. It doesn't really bother me but I am wondering would it be possible to only have the exact number of days for every month. kaushik03 thanks for your input as well. -Injinia
  14. I

    combo box calendar.

    Hi, I would like to assistance in building up the following: I have a table with column "date" which I currently fill manually for the days of the month. Which means 31 empty cells. I would like to have a combo box, with only months ie August 2012 - August 2014, such that when I pick the...
  15. I

    Legend placement

    Thanks, I am now further enlightened. -Injinia
  16. I

    Legend placement

    Hi, Is it possible to have the legend in a chart completely outside the chart area or have it as an element of its own next to the chart? -Injinia
  17. I

    conditional formatting for deadlines

    hi, I have a list of items each with a different deadline, thus a new deadline for every row. I have a separate column for when the item is done. so column C = deadline and column D = date done How would I go about setting a conditional format for this data such that - if the done date is...
  18. I

    Count and Sum

    Awesome. Thanks Hui! -Injinia
  19. I

    Count and Sum

    Hi, In the attached file, I would like to have a formula in cell AA that does the following: checks the grey cell for the mark x and sums the 12 preceding months before that point. So like in north, sum would be 1.2011 - 12.2011 South, sum would be 3.2011 - 2.2011 East, sum would be...
  20. I

    SumIF??

    Thanks Luke!!
  21. I

    SumIF??

    Hi, How would I write a formula for the following SUMIF($F$4:$AC$4;"is not equal to x";F5:AC5)? -Injinia
  22. I

    Macro / Formula to update master file

    Hi SirJB7, Thanks for the code, however it copies the new data always to column J in the master file. Ideally, it should check for the next empty column and paste the data there since I will update the master file every month. A little more help with that. Cheers, Injinia
  23. I

    Macro / Formula to update master file

    Hi, Here is the sample file. https://www.dropbox.com/sh/18lfwijgkdmsco4/KPjUwdU3Ts I did not include numbers / figures in the sample file. The idea is that the data on the update file would be copied to the Master file for the corresponding month by running a macro. Regards, Injinia
  24. I

    Macro to update monthly data

    Apologies Sir JB7 & Chandoorians, Will avoid doing so in the future. -Injinia
  25. I

    Macro to update monthly data

    Hi, I would need help for a file with data under different regions but similar categories, as follows Column B: Region name (50 regions), and more to be added sometime. Column C: Category name (36 identical categories per region) The data runs from Jan 2011 - Dec ("xxxx"), right now I...
Back
Top