The old Google Groups will be going away soon, but your browser is incompatible with the new version.
microsoft . public . excel . misc
Group info
 Language: English Group categories: Not categorized More group info »
Active older topics
2 new of 2 - Jun 10
4 new of 4 - Jun 10
4 new of 4 - Jun 7
4 new of 4 - Jun 7
3 new of 3 - Jun 7
3 new of 3 - Jun 6
4 new of 4 - Jun 6
2 new of 2 - Jun 6
24 new of 24 - Jun 6
1 new of 1 - Jun 6
Discussions
 View: Topic list, Topic summary Topics 1 - 10 of 258993  Older »
 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 » By applemanxxx  - Jun 17 - 5 new of 5 messages

 Spellchecker anomaly... Checks spelling on a Forms Button text label...? The only place I have experienced this is on this home made puzzle solver worksheet I put together. (Drop Box Link below) Run spell check from tool bar and it offers a solution to the "misspelled" caption on the forms button ConCat AH15. A low priority, of course, but I'm curious. Regards,... more » By lhkit...@comcast.net  - Jun 16 - 7 new of 7 messages

 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 » By cvhar87  - Jun 14 - 3 new of 3 messages

 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 » By JoshBrunz  - Jun 13 - 3 new of 3 messages

 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 » By League  - Jun 13 - 2 new of 2 messages

 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 » By Peter Niepel  - Jun 13 - 3 new of 3 messages

 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 » By Peggy Holzkopf  - Jun 12 - 1 new of 1 message

 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 » By tso  - Jun 11 - 2 new of 2 messages

 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 » By MLD  - Jun 11 - 2 new of 2 messages

 Change text color with an IF statement Please, would like to change the color of text in a cell t driven by an IF statesment in another cell. How is this done? Thank You Wayne Sarasota By WGD  - Jun 10 - 6 new of 6 messages

 1 - 10 of 258993   « Newer | Older »