Windows Secrets
Windows Secrets Lounge
Formula to Determine Accumulated Total
Running macro disrupts links on option buttons
How to annotate values in a cell?
Display "(Multiple Items)" in a pivot table report filter
Pressing "Tab" to move cursor to the right
Search, avoiding extra data
Sort not quite working...
Protect part of a worksheet - which checkboxes to allow all users to sort?
Combine Worksheets?
Unigue match
How do you remove table styles in Excel 2010?
Adding the active worksheet name to a formula
Need an idiot's guide on to putting a pivot table on my blogger site
Detecting an Autofilter on a worksheet.
@if question for Excel 2007
moving multiple charts to power points slides
Excel 2003 String Formula
Excel 2010 - show (PivotTable) report filter pages
ADD SEQUENTIAL DATE EVERY 10th CELL
Two-variable table brings the same value if I create a copy of the tab
Stumped by INDIRECT and an external 3D reference
Excel 2010 Mark as Final
Excel 2007 vs 2003 email macro
If Then Looping Macro
Formula to display year based on the financial year
New Window with freeze pane/pain (Excel 2003)
Macro to Change Pivot Table's CurrentPage
problem using excel w/macros over vpn
How can I email a range from a sheet ?
FTP Problem on New PC
Sum of calculation AND worksheet name that it appears on.
Worksheet Hidden / Unhidden Status
Help with formulas?
Document Maps in Excel 2007 - How do you create/edit?
Microsoft Works 9 Delete Personal Templates
Pivot vs Filter - strange results
VBA to delete data in last row of dynamic range
Workbooks with reciprocal links crash
Name of tab in sheet
combo stacked-column & clustered-column
Getting VB Modules to macro list - Excel 2010
Email a worksheet from Excel 2010
Minimum, excluding zeros
Excel - Solver to obtain compounding interest and future value?
Open Worksheet in Toolbar
Is this an If function?
Conditional Summing
How to autosave a template?
Insufficient Resources
Need Help with a Index~Large~Row nested function
Maxed out in nesting "if" statements
How to copy a cell's data to another cell on a time change? (2010)
Sorting on Pivot Table
Export Selection as CSV
Ifiserror problem
Unable to print proportional diagrams in Excel
Excel 2007 - Pivot table problems
Graphs no longer displaying
Finding first blank cell
Need Help With String Concatenation
Excel 2010 Data Consolidation Error
Numlock turns off/on when macro is run
Formula to compute averages with criteria
Identifying Min and Max values using array formulas
Macro Thick Box Border
Find missing values
Conditional Formatting Using VBA
Adding a line to a stacked bar chart
Displaying Excel Files Side-by-Side with Windows 7 / Office 2010
showing a zero in a cell
Why insufficient resources message?
Formatting dates; multiple dates in a single cell
Automation of a particular task in Excel 2010
Table sort
Creating a USMC PFT Spreadsheet in excel. Need help with VLookup formula.
Moving legends
Excel: massive files for small content
Combining If... Vlookup... Offset... in a formula
Data Validation-Accepting First & Last Names
Vlookup?
Excel 2010: how to force X-axis dates to be categories
Creating an Excel spreadsheet from a dot matrix printout
search & populate a workbook
Two workbook having same format (templates)
Save as .dbf(dBase) in Excel 2010
Excel's =frequency function
One for the books - formatting and printing
If Statement Values and Changing Cell Colors Problem
Need to create linked sheets that can be set up as a master template
Excel - Hide Personal.xlsb?
Assign Excel Macros to Alt-Key Shortcuts?
Highlighting Cell based on highlighted cells to the right
Remove trailing zero; percentage
O2010 - Color themes vs. old color palettes
Need some help adjusting some VBA code
Missing tabs in Excel 2007
array formula question
Looking for a formula
Conditional formatting using worksheet change event
Want to clear cells on open
Drop-down menu using conditional formatting
combo box output value
If find .xls update links else and update link from .xlsx
Number of checkboxes messes format
Excel 2010 Crashes
Excel hyperlink problem after sorting
moving minumum
lookup with ranges
Formatting number as text issue - Excel 2010
Open excel workbook save each worksheet as csv with tab name
Template Cash Purchase VS Rental (Compter Equipment)
Viewing Multiple Spreadsheets
Language problem with VBA
Excel 2007 startup file won't load anymore
Pictures Move in Excel 2007 when printing
Rent cv Purchase Template
Hyperlinking between sheets
Formula in Excel 2003 not working
VBA equivalent of CTRL+HOME
Step through macro having different results to running macro
Using Vlookup to look up a value
Create connection and Export data excel to Oracle db
Excel 2003 Multiple Line Entries
Macro to extract specific Column Headings & Data
Restoring a Formula
Excel 2010
How to copy an Excel Spreadsheet and keep everything adjusted
Clearing excess formatting in a workseheet
Data show Filter for Multiple Criteria
reset a pivot value to a specific number
match & extract
Solving some Excel Start Up and Permissions Problems
Setting Named Ranges
Can I add a "filtered by" literal to a cell?
Cannot get My Places bar in Excel 2007
formula/code for counting (New Request)
Search on multiple strings - Excel 2010
Calculating elapsed time in hours - Excel 2010
formula/code for counting
Macro code for Closing a File
Excel Deleting Doubles
Strip out punctuation - Excel 2003
Excel, help with selection data
Keep the starting 0's
Excel and Time Handling
Excel customizations. Where it is stored?
Compress a block of data on one sheet to appear in another...
[Word/Excel] Create Object
open outlook via excel macro and download excel attachments on criteria
Hyperlinking
Excel Maccro
Need to hire an Excel expert
Alpha Spilt of Surnames
Letters to individual cells
Excel 2010 Find Question
Graphing problem
Mystery in conditional formatting
Excel 2010: New column in spreadsheet doesn't associate with data
Find row and column values that match another
Colour cell on a particular date
Formatting cell to date does not work
Excel 2010 - paste special in visible cells only
Macro for expanding filtered list; non-contiguous columns; chart
Copy-paste visible cells only and back process. How?
Office file validation problems
Macro question/issue with filtered list
Range, INDEX lookup (?); selecting dates, time/rooms for project meetings
Recalculate a portion of a worksheet
Purpose of double quotes in a formula?
variable subtraction
Alt-Key Shortcuts for Excel Macros?
Excel 2010 column width changes
VBA Functions recalculating when calculation is manual
Excel solver
Grouped Active Objects Fail - Excel 2003 -> later Excel
refining work time
Testing for Data Filters in a macro
Macro requirement
Range lookup (sort of)
Excel 2007 doesn't quit
Date to Text in Format yyyy-mm-dd
Tracking work hours
Excel 2007 - date formatting won't "stick"
Excel 2010 - Pivot Table problem
extra set of () to clarify
Excel checkbook with running Balance - leave blank balance on blank rows
copy word files data to excel
Multiple Modules (2003)
how to format a cell so user can select from a list or add to a list
Excel 2007 Developer Reference - font size to small to be useable
desktop shortcut for workbook
Is there a simple way to generate dates based of of todays date but 18 year
Sort Multiple Worksheets Simultaneously
Are event macros triggerable only by certain kinds of actions (2003)
multiple conditions in Conditional format
Doing a DataBase thing where I pull the info, but I want to limit query.
VBA to set y-axis min and max via values in worskheet cells?
Compile error Expected Array
Moving Comments Boxes
Year wrong when formatting cell
Inserting cells without affecting formulas
Number of records to add/delete in XL macro
Macro to find text in Excel (2002)
Multiple charts
Convert string to date
Master.xlsm get reference from both .xls and xlsx
Master work book get reference from both .xls and xlsx
Excel Open Box
Unprotect check box
Custom View settings
Conditional summatioon - using SUMIF I think
Click on first tab comes up with Windows Menu
removing hyperlinks from a sheet
Formula to populate names in a Report
Vlookup
% discount
Time Conversion
File bloat in Excel 2010 w/ pictures
Line Chart Blended w/ Area Chart for Highlighting
How to auto-populate contents page?
hyperlink w/ INDIRECT or similar?
auto-hide the same rows over many sheets
How do Data Tables do what they do? (NOT asking how to use them)
Macro Problem
Excel 2010 - Locking VBA Project
Count rows by colour
Copy Multiple excel file to one master
Update, don't Update
auto fill cell in Excel
Printing and wrap text; a grump
Formula to count if in seperate columns
Using the OFFSET and COUNT functions
formula problem
Excel 2007 Data Connection to .xls - Won't import last column
Series Reference If Null In Chart
fonts size
formatting data after importing
Missing Sheet Tabs
Can someone please help with dates in IF statements?
Tracking changes problem in Excel 2007
Sumproduct (I think)
consolidating multiple data ranges by using PivotTables
Sumproduct I think
Working with "ranges" within Excel
Get yr, mos, days returns
Trying to calculate polynomial trendline coefficients
Looking for macro that will auto-fill cells in a range
Saving as csv with quotation marks around values
Just want to insert a column after "Area" cell
Poor Visibility of Selected Cells in Excel 2007 / Windows 7
How to determine investment value with IRR?
Link to another sheet
Refreshing pivot charts
Finding duplicate values
Problem with responding to "Save As" dialog box
Excel 2010 Remove both rows of duplicates
get string return if MAX returns 0
Delete Rows Based on Dates, etc.
Excel calculation order
Return date value based on the results of another cell that returns a MAX
Creating bulk hyperlinks in Excel
Excel 2003 time-series charts: pre-1900 values?
Locating the column position of data in 1 array from another array
Marine Corps PFT spreadsheet (need help with run time calculations)
Macro For Deleting Rows When Certain Number/Text Appears In Certain Cell
Caculating Weighted Average Excel 2010
Keyboard shortcut to Unhide Columns
Help needed with nested IF statement - Excel 2000
Need to remove the spaces or rather alt 0160 from cells
Exporting CSV file using Excel 2007
Excel 2010 - Adding items to a dropdown list
Random numbers
Macro to retain data
Copying sheets to a new workbook 2007
Need macro to delete unwanted data
VB or macro needed to grab N rows from a CSV file and move to a new file.
Pivot chart formatting options lost upon data refresh (Excel 2002 SP3)
Restrict value of cell to Yes or No but must be Yes if a lookup value is Ye
Formula to Extract Data
Excel 2010: Need to increase width between two columns
Test for empty clipboard ?
Reference Formulas for Data on Other Worksheets
Shortcut key to get to last cell with text
need help with query table problem
Merging multiple Excel files
change look of cell when changes are made
Sum for multiple Conditions; EXCEL 2003
Need help with a formula for multiple conditions
Calculation - pulling my hair out
Sort a Vector Into a Matrix
Pivot Table GETPIVOTDATA field reference
count unique dates
VLOOKUP accepts only typed values
Excel running slow - can't copy/paste
Default Cell Formatting
Indirect data is not always available
Excel 2007 Pivot Custom %
Custom Number Format
Excel doesn't have delete or add row event
Excel files opening in 2007 rather than 2010
VBA case fucntoin for conditional formatting to update entire row
Predicting future (home) prices
Unusual 'visible cells only' in Excel 2007
Problem with opening wk1 files in Excel 2010
VBA Text / Number format conversion when opening HTML file in Excel
Vlookup on a percentages, as opposed to a word/text
copy tab names from passworded workbook
Filtering to inculde multiple rows
Delete rows matching any of a long list of items
adding more options/variables
add error string to formula
macro to delete Duplicate records
time values
Data Validation - Dependent Lists - one to one relationship
Using OFFSET
Totals in footer / header
Mail Merge w/individual graphs
Copy certain rows of data to new spreadsheet problem
Using COUNTIF with multiple criteria
Formulas to Values - VERY slow
Pivot Table Cell reference and Macro
Need help with macro
Date formatting; adding a 'time' to the date
deleting rows using excel macro - repost
Macros won't record
Is it possible for a two way List box for data validation?
Automatically constructing text strings
extracting data
Excel unable to save file; huge file size
Extracting data
Compare and move
What the heck am I missing??
macro to bold just first word of a cell
Extract the columns and rows used for a sum()
excel 2007 file formats under save as
Way (VBA or other) to lock pie chart labels in place
2010
Prompt for Updating Links
Worksheet Change Events; multiple instances in a single worksheet
Pivot Table Calculated Field (Excel 2007)
Formula for calculating Utilisation
Form Controls
Changing format to allow Excel to CSV with commas and quote marks
Corrupted Personal.xls
VBA Error
formatting imported data
Form controls
change normal template Excel 2007
conditional format help
Copy and paste sheets to a different workbook
$ and holding the cell placement in a formula issue
Newly Entered Number is Changed when Moving from that Cell
Unable to recollect an Excel formula
saving to xlsm from xltm template
How to Subtract Sum of Several Cells from Fixed Number
convert a number to a date
delete blank rows
formula help comparing colums for matches within a range
Help with resizing a table array fore using vlookup
Searching for a new sales commission solution
Macro to Hide Rows in Excel
Change the month only in a list of dates on my sread sheet
Using SQL to query Excel worksheet from within the same workbook
automatically update value in formula to last entry
Formula question
Excel Chart on Grouped Data
Data Validation - CUSTOM v2007 RESTRICT EXCEEDING A TOTAL
"freeze" ?? block of cells
Ternary Plot
macro to select from drop down header in 2007
compute average with moving data
Unique Bar Graph Look Requested
Excel 2003 - Two column sorting
Applying style to cells based on another cell's contents
Complex data gathering
What happened to Shift-Edit?
Is there a numeric wildcard for COUNTIF?
Formula Problem #value!
Excel 2010 - Make a list of dates that run every-other day
Excel AutoFormat
Bar Graph Question
Average with variable, and days to average
Excel loop - offset problem
Column Width Tooltip
Macro to delete rows
Data Plotting (Excel 2003)
Macro in Excel 2007
File Save Date Formula
Excel 2010 bug
MEAN function in Excel 2010
Password protected Excel file-promptTwice for password for Original & Copy
Using Countif with dates
Data entry forms in Excel2007
Excel 2010 - Pivot Table Totals at Bottom
Concatenate text including quotation marks - Excel 2007
Selective Suppression Of Gridlines Excel 03'
Specify data ranges in logical tests
Pivot/Chart: sorting data
Excel (Office XP, Win7) crashing on startup
Fuzzy id a name within an email address
Cut the last character after a space
E-Mail List
excel 2007
Get rid of space after a comma
Mutal Pick Lists
Change import dialog default settings
filtering in excel
Calculating deadlines
Loading a UserForm from a spreadsheet
Copy cell text above if selected cell is blank
Dates, Conversion and Sorting
Time duration in Excel 2007
color in an IF expression
Row from Worksheet A = Row from Worksheet B
Nix Auto Format and cut & pasting from Web format
Combining two columns into one with reformatting
Format over Conditional Format
I need a formula to calculate eBay listing fees.
formatting text field
need formula
Excel-applying formulas to sorted data
Excel-using CountA function after filtering
Change Date Font Color
Modify Pivot Table - Excel 2003
Excel - sort or filter based on bold font
Graphing and leaving out data with 0 quantity
Excel - effect on formulas when sorting columns
Macro to show message when there is a variance in
Left and Find functions - meaning of -1
Missing shortcut menu - Excel 2007
Axis Scaling Issue In Graph
Help on multiple conditions formula, please
Data Validation
Selecting multiple values from dropdown list
List of combinations
Enabling Macros for a specific sheet (2007)
combining, merging, matching data from one WB to
Problems with data source linking
Show parts per million in Excel
Print Macro for Excel 2007
PERSONAL.XLSB fails to open
Extract 1st entry if more than 1 entry
Filter on Multiple Colours in Excel 2007
Cell knows its position in a list?
Excel 2007 - chart data
Combing data from 2 cells into 1
Show serial values for dates
HELP "Save As" button?
VBA Code to compute Percentages
check a file name follows naming convention
Line chart to show stock movement
Sum WITHOUT a formula
XY Scatter with a Vertical Band
Formula calculation automation by value insertion
Traffic lights in Excel
"above lookup"
Best Practices - Location of Formulas
Subtotal in a filtered table
Missing data
Merging data
Calculating variable costs per item
Conditional Formats in Pivot Tables - Excel 2007
Sum cells based on a condition
Excel 2007 start up
Leading zeros in variable-length part numbers
Command Buttons - 2 types?
Help with charting
Storing macros
Making column titles print on multiple pages
Personal Macro Workbook
sumif the first word in a cell is the same
Countif formula to count number in a range
How to compare two Powerpoint 2007 presentations?
Why is print & print preview greyed out Excel XP?
matching cells with similar information
Embed a Word Document in Excel 2010
pdf to xk
Conditional formatting (Excel 2003 & 2007)
Using Index & Match Formula
Chart only cells with data
Excel does not print 6 or 8 (these two digits)!
Problem with Dynamic Range
Minimum Text Cell Length 25 Characters
Slicer option disabled - XL2010
Centering Text in cell using keystrokes
Determining Prev Months & Year
Online Excel Courses
Automate long task (Excel 2007)
Address of last non-blank cell in a column
ODBC Connection Failure
Help Needed to fix a formula
Freezing a particular column
Match (I think)
Use of Iserror within Formula
copy formatting while using formula
Password protecting excel over internet
Multiple Drop down list with spaces
Formula to change when new col inserted and mont
VBA Error in Excel 2010
Need help build tool in Excel