• 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

    Need formula help! If/Sum/SumIf.

    Hello Everyone, I am trying to create a formula that gives me the following: "Where this date appears in column D, sum the values within columns E-G of the same row" (rough example below). How would I do this? D E F G 2/7/2013 4...
  2. S

    Excel 2013 "400" Macro Error Help Needed

    Hello, I am using the following Macro in Excel 2013 and receiving an error message that simply says "400" and prevents the macro from adjusting my margins appropriately. Does someone know what is causing the problem? Thanks in advance for the help! Sub Column_Widths() Dim i As Integer Dim...
  3. S

    Can't Make Column 300 Pixels Wide [SOLVED]

    Step 5 from the following page instructs me to make the column exactly 300 pixels wide. Unfortunately, there appears to be a width limit of 255 pixels. Am I doing something wrong? P.S. - I am using Excel 2010. http://chandoo.org/wp/2013/04/01/unlock-angy-formulas-excel-game/
  4. S

    PowerPivot - Contradictory Duplicate Values Error

    When I try to link my linked tables together in PowerPivot, I get the following message: "The relationship cannot be created because each column contains duplicate values. Select at least one column that contains only unique values." This is frustrating because it seems to directly contradict...
  5. S

    Trouble with If Then Macro and Alignment Macro

    Hello, I am trying to do two things: -make cells L3 to L183 appear blank if the given value is "N" -make cells G3 to G183 Left Justified How would I add that to the following macro? **NOTE: All of these cells already have formulas to give me this information, but I still need to alter the...
  6. S

    Should I be using vlookup?

    I already am using the following formula in Column B: =IF(ISERROR(VLOOKUP([@[RelRec From My List]],SherrysIVXlist,1,0)),[@[RelRec From My List]],"") If this formula gives me a value in Column B, I want to take all of those given values and have them populate in a comma separated list. How...
  7. S

    Vlookup/If Problem

    I am trying to reach the 2 following results: If a value appears in this table and in the other table, remove it. If a value appears in this table, but not in the other table, don't remove it. How should I write these formulas?
  8. S

    Borders Missing After Updating to Office2010

    I just updated to Office2010. I have a few tables in Excel that are supposed to have "All Borders", but the border on the bottom of the entered data is not showing up. All of the data has "All Borders" appearing properly, just not the bottom row. I have done everything I can think of. Does...
  9. S

    Macro Error Help Needed

    Hello, I am trying to use the following macro to simultaneously format a bunch of tabs and running into problems. Can anybody tell me what is going wrong? Thanks in advance for your help! Sub Column_Widths() ' ' Column_Widths Macro ' ' select the sheets I want &#39...
  10. S

    Way to Lock Column Widths?

    Is there a way to "Lock" the width of specific columns?
  11. S

    Please Help: Compile error: Invalid outside procedure

    I don't know much about vba and am having trouble with this macro. What am I doing wrong? Any help is appreciated. ActiveWorkbook.Worksheets("767 DE 1-2 Current Del").Sort.SortFields.Clear Sub PtP_Data() ' ' PtP Data Macro ' ' Columns("C:C").Select...
  12. S

    Too Many Conditional Formats...

    I inherited a massive file with tons of sheets and formulas. Each sheet has over 30 conditional formats. Is there any way to remove a cluster of the conditional formats (but not all of them) at one time?
Back
Top