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...
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...
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/
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...
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...
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...
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?
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...
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
'...
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...
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?