Windows Secrets
Windows Secrets Lounge
Deleting Rows With Subtotals
Index/Match
FOR NEXT control
Now function in Excel
Highlighting individual characters in a cell
Increment numbers
IF statement to find cells with subtotals?
Macro to sort by month
Hidding Contents Of A Cell In The Formula Bar
Highlight Cells
Macro to Copy & range value
INDEX - MATCH
Very slow Excel spreadsheets
Excel Add-ins where to put a button to open form
Using Offset Function where Column Changes
Linking Merged Cells from worksheet to worksheet
Named Range Leads to Crash
Last date used for a specific client
Data validation list without the blanks
Excel VBA Loop Range
Printing worksheet with comment boxes in Excel
Excel 2004 for Mac: Recurse Directory
Excel - give cells a ranking based on the value?
Category: dates
Copy and paste in Excel
Powerpoint - Excel stays open (2007)
Hide ribbon if present
Autosum
.xlr to excel 2007
Time sheet woes
Entering serial numbers
Hyperlinks Everywhere
formula to return all matches from a list
Formula bar
Sheet/Tab Name Automatically In Cell A1
Count a column based on multiple criteria
Excel - macro enabled?
Transfer color palette
Totalling cell values by week over 12 sheets.
Refer to previous sheet
Data Validation
Entering dates without typing slashes
Conditional Lookup based on two values
Matching Dates
Confused about security level for macros
export in a FORTRAN format
Excel to Word
Help to change a formula please (Excel 2003 SP3)
Excel 2003 Screen Painting Error Patch
Cell format
Import External Data - Excel 2003
Pop-up calendar
Concatenate
Workbook says read only - non commercial use
Text LookUp More Than One Condition
How do I create "bell curves" in a spreadsheet
Print Two Sided
How to do Grouping
Lookup and add to cell
COUNTIF
Strange request - probably needs VBA
Conditional Formatting
Can't change x axis min/max data
Counting Nonblanks based on another Column
Date Format not Showing Conversion
Removing pivot table formatting in 2007
automatic update of linked data
Database Query
Conditional Formating - Excel 2003 SP3
MS Excel
Layout / Feasability advice please (2003 SP3)
subtract on date
Getting back 2003 add-ins
Need to Always have Macro available
Attach ORG-chart
45 degree angle of chart text
Select Random Number of Rows in a Range
number of consecutive days of value exceedance
Color text or cell shading
replace blank space in a string
How to link Excel sheet with Powerpoint ppt
Cell evaluating to zero displaying as blank
remove blank dates from chart (2007)
Pivot table charts
Best way to insert values
Name a shape?
External question for internal data source pivot
Formula assistance please
Toggle SendMail Warning Message
Adding a text prefix to a formula result?
Frequent Numbers
Recovered PERSONAL.xls
xlColorIndexAutomatic (Excel 03)
Copy from worksheets into one based on date
Find merged cells
Moving XL windows to another screen - Excel 2003
Circular reference issue
Hyperlink works in Outlook, not in Excel
Change list Orientation
Using COUNTIF on cells with formulas
can't save or find excel schedules
Prevent macro from running when ...
Conditional formatting between worksheets
Make all formula references absolute
summing range
Batch Change Password Protected Excel Worksheets
Trying to Insert,resize cell and photo using VBA
Logical Function with Vlookup
Color Shape hierarchical
Remove one database's entries from another
Excel 2003: Cell inner margins
Add Word table data to Excel
Help - missing personal.xls
FINDSERIES (Excel 03)
Enabling Macro prompt
calculate the weights
Adding extra data to Date Validation cell
Pop-up form leaves trail when drag across screen
VLOOKUP issue in Excel 2007
VBA Format Data Point Graphics
AutoFit height on a wrap text, merged cells
Paste Buffer in Excel
Colouring Cells (Excel 2003 SP3)
Reuse of XLA's (cross referencing functions)
"Too many different cell formats."
Name worksheets after a cell value
adding new items in pivot table
Counting colored cells
Assistance With Modifying Data Validation Entry
subtotal results "drill-down"
Cell show formula not result
Combo Box (form control)
CountIf?
Want a Pop-up to display a chart
StDev of sub range
Filling a cell from one worksheet to another
Chart with non-consecutive dates
EXCEL, Office 12, MS Office Home-Version
Same sub in many worksheets (Excel 2003 SP3)
Excel 4.0 Macro Functions
Permutations
Change Event - Excel 2003
Cell reference problem (EXcel 2003 SP3)
Rounddown affecting caculations
Compare row with column
Compile error in hidden module: User Form 3 ?
Excel Lookup 2003
Formula to extract last filtered item
Formula to count characters in a formula?
Trendline
Data Validation; match data in a column
Macro to clear data
How to count disparate values?
Excel 2003 Running Column Totals
Excel comments
Edit - Replace
Evaluate which quarter
Password protected files
Convert a % Column to $
runtime error 75
How to sort row cells?
Named Ranges in VBA (Excel 2007)
Problem using temporary recordsets
Formatting a Chart Axis Number (Scale)
Favorite in "My Places"
blank cell
Hidden Combo
Spreadshet only opens with the VIEW tab selecte
Compare and merge worksheets in Microsoft Excel
Excel 2003 thinks things are dates
Excel 2003 crash on reference to another sheet
Pivot table problem
Formula rationalisation / simplification
A universal directory for XP, Vista and 7 ?
Can I augment selection from a list?
Startup Template - Excel 2007/Vista
Error Handling
2 editors - 1 file - Excel 2003; Windows XP;
Counting Data Entries in Excel
MAcro cyping data info different sheets
file highlights
Transpose grouped items into single column
copying one worksheet to another workbook
Please check my Sumproduct
Excel cells erroneously selected
Fixing short date format in Win 7 (Excel 2000)
Lotus Symphony
compare several columns
Repeat rows in Page Setup is unavailable
Screen size issue
Counting addends
Can I add a yearly cumlative total to weekly sht
logic test for copying data
Data validation box size
Clearing Pivot Table filters
Spreadsheet In Use Error
Sort with multiple decimal places
Showing 2 sheets at the same time
Search function
pivot table set all row field sums to none
Export to Access
Calculate missing figure?
Have @Sum treat text in cells as zeros
Can I dock my form
Top left cell
SendMail to Notes
SUMPRODUCT letters and numbers
Matching one column in 2 sheets
Macros issues in 2007
Userform to unprotect and Unhide Cells
Truly Empty Cells
Get text out of a shape into a cell
VBA Solution to EOMonth
Event subs not running
Function Assistance
Link to another spreadsheet using Defined Names
Build Work Breakdown Structure in Excel
VLOOKUP result when no match found
Array Help
Macros won't run
Display color in Excel 2003
Reason to be
excel dropdown list
Multiple stacks in column graphs
Networking an Excel workbook ?
Displaying text in a template
Streamline printing multiple areas
Blank Excel Cells
UPPER function doesn't seem to work
COUNTIF referecing different file
Making a cell read-only
Formula in Excel 2007
Help with countif function (Excel 2000)
Indicator if condition is present
Display today's date within Chart
Max returns a Column Name
Preventing auto_open and Workbook_Open events
hotlinks to file system objects
Macro to add missing leading zeros before sort
Force User Defined Functions to calculate
colorindex problem
Annoying Prompt on .XLS Save in Excel 2007
Problem with excel userform printing docm
Open Office Programming / Automation
Replacing 2007 ribbons
Excel 2003 - links break
Sorting table rows containing merged cells
worksheet function
Read Only Files
Startup Excel and run macro sometimes
syntax for logical tests
autocomplete for lists
First Monday of the month - conditional format
Month Formula
Excel 2007 Is Very Slow
fill (color) only unfilled (uncolored) cells
Is there a formula for this?
Lotus Smart Suite & Win 7 64bit
Advanced Filtering (?)
Automatic saveas xls (Excel 2003)
Row shading changes when value changes
A Factorial List
Wrong Results
Syntax to check 2 cells sum zero
conditional formatting to detect nulls
Filtering Rows
Match, Index, Vlookup Combinations
Replace all formulas with values (& Pivot Tables
Autosave file recovery question
Excel Crashes on Copy and Paste
NETWORKDAYS function not working
Creating multiple copies of a worksheet
Excel 2007 and Win7 Taskbar Preview
Sorting limitations
Sort by formula in Excel
cell value repeats
Antilog?
Problem with "on change" VBS
Summarize data - multiple conditions
Excel to dial the Phone
"IF" odd number question
Quadratic Interpolation
Time formula problem
Printing Excel 2007 in Windows 7
Inserting file name and path?
Turn off query wizard in Excel03
Autosum in Filtered List
Multiple Substitutions
Updating hyperlink when inserting rows
Get rid of Personal.xls
Logic
Ensure that filter is null
save file as....
USING Multiple if and OR
convert date from texte but in antother format
Reactivate Excel once email sent
Advanced Filter Criteria
Negative times in formulas
Formula: Calender and Fiscal years
Want to read color of condtional formatted cell
Commandbar popup
OPEN sheet (tabele) with jet 4.0
Excel Matching
countif with changing range
Convert comma list to array
Can't see highlighted cells in Excel 2007
Updating charts
Macro to change Scroll Bar Maximum Number in For
Excel Formula
How to fill empty cells?
charts-conditional format data points
Unhide, refresh, hide problem
Hiding cells- set range object
Hyperlinks to bookmark in Word doc
Macro to go to end of the row
Calculating Mileages
Anchor shapes into shapes
Return address of commented cell
Business day math
VBA that will only open workbook 10 times
Selecting a list box item
Formula to insert worksheet name
Protect Cells in Excel (Formatting Only)
Copy a range of cells and paste into one cell
Removing a dash and everything thereafter
Concantenate and Dates
Create Access table
Cell clear contents
date of minimum value
Copy picture
ms query - fill down not resetting
Adding a trendline to a chart
SUMIF (if possible)
Screenupdating and listboxes
SUMIF with an OR argument
Object instead of a Picture
remove dashes in SSN
Default Chart format
Calculating Hours for 24 hour roster
If/Then based on day of week
Sumproduct (?)
Copy and paste charts
dll not found
How do I eliminate a 0 in a target link
Timer in Excel?
Goal Seek
Finding incompatibilities
Tiered Charges
Error Message when inserting row
Open, minimize, get focus
Combination Chart
Chart - Data Labels issue
Sumif Certain Text Is Present
Extract min value from a range
add Excel add-ins & deploy to all pcs
sumif
Combinations
Transpose
Code to change .BMP's
Macro to Print Graphs Streamlined
Grouping Data in Pivot Table
Excel 2007 - multiple drop-down lists
Formula Tape and #VALUE on Links
Macro to Print Graphs
Pivot Table Subtotals
Multiple Options
Excel Workbook Window Problem
Formula Problem
Grph To Compare 2 Levels
Individual To Subject Count (Calc Help)
Maximizing Spreadsheet In Excel 2007
Removing spaces using trim command
Copying data from sheet 1 Vlookup?
Formula to = jpg or gif?
open dialog box with only csv file
Macro to Link & Copy Data
Filter dates in a list box
Using VBA to copy and save a file folder
compare two lists
Excel 2003 - Extract number function
Clipboard Paste Problems (Excel 2007)
control date entry
Excel 2007
Locate duplicate records (Excel)
Sheet codenames
page numbering from several work sheet
Hyperlink to external file
Keep decimals when converting to csv
Dynamic gridlines
Snake plot graph in Excel
question from the statistically challenged
Cell Formats
Formula without creating a circular reference
Quotes in cell format
Setting cell with #N/A
Chart problem
Ignore all Worksheet_Activate events
Convert formula's to R1C1
Unique random number
Excel Compatibility with OpenOffice ?
sumproduct
Custom format for rankings
User Defined Functions
Formulas from web query causing file bloat
Finding a Row Number
Formula to Calculate Water bill
Replace old picture with new
Perform a function based on certain text in another cell
median array formula
Mail Merge forming a "list"
making relative formulas constants
USEABLE REPORT FROM A PIVOT TABLE
flummoxed by array formula
Dual Look up: Vlookup, index or match
UDFs in VBE: can't reference my file
Delete Cell Contents
Excel 2007 - Remove Cell indicators
GetChartElement in Excel 2000/VBA
Extract Data From a Cell
Copy a formula in a column
Change Pivot Table Column Ordering
Simple CountIf
import dbf file from arcgis
Excel 2007 - Multiple Pivot Tables Reading 1 Database
FORMULA DRIVEN REPORT
Macro Toolbar
Chart help wanted
Stack chart
Change scale
Search for CONDITIONAL FORMATTING
Hashes when printing
Custom toolbars in 2007
Report
Lookup or Match
ComboBox auto fill problem
Relative References Won't Stay Relative
Percent Increase distributed
Sumproduct (?)
Excel pagination Help
Remove everything after (
Separating Contents Of A Cell
PIVOT TABLE %
Defined names - setting
COLORIZE ALL ROW in sheet
Sum with offset
Entering in cell
Adding a Chart event to a new chart
Charts - copying
Weird code behavior
Make allowances for user's monitor settings
Modification in code
How to add cells with text and numbers
Forecasted Trendline
Excel to Word
VBA Excel Multi Dimensional Array
COMBINING DAILY ITEMS BY MONTH WORKSHEETS IN A WORKBOOK
Import selected Files
Substitute function
transform date
Split Data
Duration in Months
Date range query
Protecting sheet and allow button macro to work
Multiple Hyperlink changes
Advanced Filter Challenged
Schedule Report
Paste Formula
Remove Excess Spaces
Sheet Copy and Formulas
Autofilter query
Symbol with if condition
Long IF
Knowing when rows are added in another sheet
Advanced Filter
getting YTD totals
Need Font Recommendations for use in Excel
embedding a formula ( worksheet name) in a VLOOKUP formula
VBA copy worksheets routine
Importing External Data
SumIf / SumProduct Help
Backup version opening
match data, plus or minus
Dynamic Bubble Charts: a challenge
loop in loop
Last entry in column
IF/THEN Statement
Attaching Macros to Spreadsheet (not to Application)
Macro Security
Copy data between workbooks
lock all elements of userform
Get Data from Saved Workbooks
VBA Listbox in Excel
Excel vb range box
Macros/VBA
Color formatting using a worksheet change event
Data Forms
Why does the SELECTION object not show in Immediate Window
lookup xls sheets
Tab Name
Functions