Description:
Microsoft Office Excel newsgroup.
|
|
|
Advanced Sort/ look
|
| |
Good morning everyone,
I am trying to sort a document based on the information in one
particular column, this Colum contains the following alpha numerical
string “F907E231220084”. I need to help in figuring out how to sort
based on the last 4 digits only. I appreciate any and all help. You... more »
|
|
|
Countifs with if and date range
|
| |
I am trying to count the occurrences of "ack" in column D only if column
A is Q1 and column D has "ack". =IF(AND(A4:A232="Q1",D4 : D232="ACK"),COUNTIFS(D4 : D232,"ACK"),"N/A")
Right now it is returning just the result of logical true which is 57,
but D4 to D32 has only 30 occurrences of ACK, the remaining are... more »
|
|
|
Index/Match Lookup with a merged col
|
| |
This should be a fun one...
I have a spread sheet of team scores. col a is the date of the game and
is 6 cells merged up and down. the 6 cells next to it in col b are
names. cols c-o are stats and scores for each name. the dates are not in
order. im trying to find the newest game date and display all 6 columns... more »
|
|
|
Slicers and Calculated Items in Pivot Table
|
| |
I have a Pivot Table/Pivot Chart with slicers. There are 4 slicers
attached. When one slicer is filtered the other slicers will filter(grey
out) accordingly. But I also have some calculated items in Column Label
field. When 1 of these calculated items is selected, the slicers all
lose their filter link to each other. (unavailable items in other... more »
|
|
|
Filtered drop down list
|
| |
Hi Excel experts,
Excel Version: 2010 I need some help please. I need to use a drop down list which is filtered based on a flag. As an example:
The products table has two columns, Product and Active. Product has product names and active has a flag (1 or 0) to activate/deactivate a product. On another worksheet - lets call it order items - I need to use a drop down field in a column which provides all active products as values.... more »
|
|
|
Excel 2007 pivot table using analysis services cube as data source
|
| |
Hi,
I have created a pivot table using excel 2007 with an analysis services
cube being used as the data source. The cube has numerous dimension
tables and four fact tables. When I try to drill down into a value in
the pivot table, the results that are returned contain the Keys to the
dimension tables that reference the actual data but not the actual data... more »
|
|
|
Spell Check Protected WORKBOOK
|
| |
Hi Everyone,
I have found the Macro code to check spelling for one particular
worksheet.
However, I want the macro to check the spelling in all 10 worksheets. This is what I am using now.
Sub SpellCheckIt()
Sheets("Sheet1").Unprotect "Password"
ActiveSheet.CheckSpelling
Sheets("Sheet1").Protect "Password"... more »
|
|
|
Excel Stops Working
|
| |
Random occurrence: In closing excel a pop up comes up saying "Excel has stopped working etc". It then shuts down followed by a restart. Works normal after restart and even shuts down OK---that is, until the next odd ball time. Gone through the Repair procedure without effect. Has this been... more »
|
|
|
