Windows Secrets
Windows Secrets Lounge
Convert cells from General to Date Format
Finding the "missing" record in a filter: Excel 2010
Slide Timings in Excel
Excel footer, What is optimal size for A4 print?
Macro format
Forgot how to do this again
COUNTIF but if Hi-Lited Don't
Checking for duplicate/similar values
Goal Seek within VB
Helpfile for a workbook
Exporting Outlook email details
Protect Worksheet but Allow Refresh from Sharepoint List
Sheet 2 is same format as sheet 1 without copy/paste special/formats
Sumif not adding values correcly
How To Process Web-Imported Values
Delete Columns if Empty within a Range
Need help with conditional formatting using .net
Check box or radio circle on and off in a cell by clicking
Using SUMIFS when the Range & Criteria rely on there relationship
SUMPRODUCT problem
Named Range to be used with Target.Address
Adding preceeding and following "-" to center text
Vlookup where value is a formula
Another Compare Data columns issue this time with 2 columns
Pivot table - getting all possible column headings
Error creating Pivot Table formula
Tagging data to copy to different spreadsheet
Find last value in a column
Sumif Problem
Vlookup where numbers on one sheet are text
Sorting issue
Do Until If Cell range is 0.00 then Delete Row, won't Delete !
Help with a solution for calculating incentives
I need some design help
Selective Addition
Car Re[air Template
Web Query syntax error
Macro to compare data
Single vs Multiple Workbooks
Macro to Copy data from One folder to specific Folder
Coverting rows to column in date and time order
Comparing account numbers
Copying Down a Long Column - Excel 2003
Early and Late bilinding in ADO/DAO
Conditional formatting with five-icon set
Exporting certain data from a sheet and as save as CSV File
Macro to open specific directory and copy data
How to copy formatting?
insert or update data via VBA Source excel to Sqlserver
Indirect cell addressing
Need a rounding function
Need help Retrieving Data from one Ms Excel Worksheet to another
Count Unique Customers by Class and then Consolidated
Formula to Split data
Is there a difference between Excel 2007 & 10 re: this function
VB to insert space, create sub headings, and merge cells
Cell reference keeps reverting to data result
Microsoft Template; formula question
Delete/Condense Rows
Create column,move all strings to column A and fill series
Lost formatting in Excel
VB Code required to evaluate Excel formula
Determining if a Specific Value Ever Exists for a Project Name
looking for a sample excel file for inhouse training session fo pivot table
Excel 2003 Custom Toolbars
Need a workbook BeforeClose event
from network to sharepoint
Prompt for Signature on Every Save
Hyperlinking in excel
Sorting by different columns automatically on two sheet tabs
Nest IF/And/Or Too complicated?
Replacing zero-length strings but skipping certain columns
Using a formula instead of Goal Seek
Using Count If to to get PASS /FAIL /NA based on values in 2 separate cols
Trouble pasting excel spreadsheets into word or powerpoint
When is an empty cell not an empty cell?
Backup Storage Disk Space Calculator
Edit links manually only
How to Display a Blank if Linked Cell is Blank??
Macro to update internet links
Recreating a data display table using VBA
help with formula
Cross Version Copy
Matching very large number of cells in array
Getting the Addins tab to display in Excel 2013
Naming ranges using VBA
Open a foler then select the correct filr and copy form that to your master
Line Weight in Excel Charts
Conditional formating a formula cell
Sum values based on a Named Range
Conditional formating - excel 10
Significance or function of '^' in a formula?
Observation About Text to Columns Wizard
Second opinion; Can anyone poke holes in this formula?
Formula help needed!
Combining Data of 4 groups data (in 3 columns) using common unique index
Calculating Time from Custom date formats
Pulling rows from one tab into another based on a value
E-Mail Certain Worksheets in a Workbook
Offsetting a chart
Help with formula
Error in MSExcel 2007
Using Excel to find trends and patterns: problem management
Copying selected records
Can you in VB append column headings to a row and repeat
Printing Images Imbedded into Comments
02/12/2013 Windows Update
A lookup to take into account 2 column values and 1 header value
Displaying a string in a blank cell !
Difference between two times - to the second
Transpose
Sequential print from list
can't update horizontal data in chart
VBA to refresh all queries and pivot tables
Updating Links
Need to understand Index/Match and Vlookup can be nested.
Need to change lines in Excel 2010 chart
Changing Dates in Text to Numbers
Wrap Text function treats negative sign like a hyphen
Flaky Sort Macro - Excel 2003
MSQuery time conversion error
Change signs based on criteria
Deactivate Timer Macro
conditional formatting to display a currency symbol based on text
SUMIF the criterion contains a specified substring
Libre Office Calculator help please!
Function other than VLookup
Create new sheet with customers from one sheet but not on 2nd sheet
Remove all words that are not all caps
Delete certain text
Microsoft Query Assistance Needed
Combine 2 tables with data from separate Fiscal years
Conditional Formatting question - shading of one cell or groups of cells
Formula with database
Prior postings in Spreadsheets
Sorting and Moving Pass Fail Results
Pivot Table Report Filter - Excel 07
conditional formatting (more than 3 variables)
Count Cells Containing "IMMEDIATE"
Trouble Running Macros During Cell Change
Excel 2010: "can't find project or library"
Conditional Format if Cell is Blank
stack chart
Dynamically Challenged (in Charts)
PowerPoint: hide selected objects from printout?
Global search and replace of text on sheet tabs
Excel macro function firing when it shouldn't
Help with Code or Forumla
Formula needed to extract a date from a string
Conditional Formatting
Inverting columns of data
Extending formulas down a spreadsheet
Saving settings in Excel 2010
Countif
Determine if data in one column is in another column
Excel 2010 Yields Massive Files
Update columns of numbers in spreadsheets
User-defined function: Triangular Distribution
Excel error opening
Sorting Unique Items Over 2 Columns
Lost Custom Colors
2 worksheets on 2 monitors in Excel 2010, Windows 7
Active Cell + 250 lines highlight macro issue
Macro troubles - relative referencing, but not really.
copy creates a blank sheet
Tool tip for a UDF
Sheet Change Event doesn't fire
Creating a daily cash report showing # of trx and total amount
Assigning the 'On Open' macro ?
Combination of numbers
Help with BIG Project
reformat
Transpose with a pattern
Ratio calculation
Calculate % difference
Average time calculation
VB Corner for Excel- Learn Visual Basic, VB Code Repository
How to footnote a formula
Using a pivot table to add minuets
Formula to find next business day
How to pad out emails?
How do I change a txt file to a quote delimited/separted file?
Lost Macros
Macro for if auto filters dont find a match to not copy data to a new sheet
Using macros in Excel 2003 and 2010 and vice-versa!
Type mismatch
Find Upper and lower boundary numbers. calculate average rate between them
Excess Spaces
Need Code
Sum based on colour?
Clculate Remaining Months and Days
How to Autosum in a macro at each change in data
Not sure how to do this - missing file numbers in a sequence of file names
removing protection from an Excel spreadsheet
Auditing utility accounts (with pivot table?)
Locate chart below last row of data
Taking a variable break based on change in naes over an entire column
Parsing trendline equation
Help to adjust this Spreadsheet please? :)
Excel 2013 poor performance
List of records with unique entries in one column
Sort by the code
Changing the X scale of a chart
Excel Combo Box Macro
VBA for Excel - Copy rows and populate with split cell values
Find function
Obtaining a "SUM" or a "COUNT", "COUNTA" etc. on a filtered list
Macro Pivot table where the range of data always changes
Printing custom views
Cannot create Pivot Chart with VBA in 2007
transpose column to row in loop
More on Sheet Tab Names
Quattro Converter
Sheet Tab Names
pdf conversion issue
Permanently save custom number format for all workbooks
Need formula to extract from string
pivot table and calender month view
Lining up decimal points
Changing the order of columns
Conditional Formatting with colours - tied values
I saved over a file I can't replicate
Changing order of names in a column
Select and print defined areas of spreadsheets
Hyperlink formula to long file names that include commas
Help with Excel formula
changing to lower case
transfering excel spreadsheet with hyperlinks into Access 2010
Excel File Growing Beyond Belief
Help with arrays couning dates
Days between 2 dates, including the 2 dates
macro to copy cell contents and preserve data regardless of change in orig
Restrict the number of colors in Excel 2007
Close routine, cancel close and return to spreadsheet
Formula help: is =Right right?
Excel 2010 loses number formatting
Macro to copy data from multiple workbooks and sheets
How to Change Cursor Behavior in Excel 2003
Create new spreadsheet (13 columns) but data has variable number columns
Editing a user defined function
Count based on two conditions
Delete rows base on string first text and also leave numberic
Derive a Cell Reference in a formula, not the value
if statement
Offset funtion challenges for date selection
Excel Help
Need help debugging user-defined function in VBA
Macro/VBA if statement-Excel 2010
Workbook Tabs
Message to advise when values <>0
Excel 2007 - PERSONAL.xlsm project locked
Excel count enteries
Excel 2010 Date Picker
Highlight Cell if Row is empty
sorting grade n marks
Problems
Excel 2010 color scheme
.xlsx file not opening in Outlook
Upper Case Date Format (2007 SP2)
Rolling Calendar
Limiting user input
Macro to auto-hide rows
Forgotten Formula
Excel formula or macro for string of numbers
Index and Match
Selected output from coin inventory
Forgot Formula, and can't find it
How to get name of selected sheet for use in excel macro (vba code?)
Compare multiple (non adjacent) columns between 2 sheets in Excel 2007
Excel VBA to Clear Ranges
Need a Formula to plot employees within a range
Excel for iPad
Export to Excel from webpage no longer works
Printing to JPG Format
Excel 2010 bar chart with 2 y-axis
Can updating rolling calendar tables and their graphs be automated?
Macro to format Dates
Need to create a simple Hierarchy
Combining Workbooks/worksheets
Inbed search function inside array
Spontaneous shutdown of Excel
Convert hours
Formula to find and relocate discontinuous series of numbers
Want to highlight missing dates
Calculating date and time in business days other than Saturday/Sunday
Combo Graph Question
Excel 2010 SP3, intermittent link cell problem
Conditional Formatting Problem
Excel Options question
Adding amounts across multiple spreadsheets within a date range
Dual Axis Graph Question
Checking overdue date value from cell
Get average of percentages
IF function
Excel 2010 formula to shade cell to match another cell
Changing formulas to point to new column in budget
Sumifs within a range
Sumifs Question using Excel 2010
Need some help with visual basic to use cell ref for Y axis values
Excel - output in Unicode
Excel formatting
excel compatible format
Saving files to sharepoint
Pasting a volatile formula in Excel 2007
Password protect all tabs
█ Automatically transferring data between worksheets █
Data validation with a named range and conditional formatting
Conditional data formatting in excel 2007
Rearrange Smith, John to John Smith in Excel
Data validation annoyance Excel 2010
Excel comment font.
Excel formula or formatting to change number
Copy Data from One Col to another
Grouping Dates in Months Pivot Tables
Putting Cell Contents into a Print Header, Then Formatting
Default Folder
feedstream calculation
Networked EXCEL - warn and protect against access
proprietary spreadsheet protection
Testing error conditions?
Making Excel 2010 accept quotation marks and spaces
Help with excel 2000
Smooth Vertical Scrolling in Excel
Display a graphic based on a cell value per row
Dynamic Print Rage
Need help w/duplicate data
ActiveX Listbox problems [2010]
Comparing mortgage loans
Microsoft Excel
Rolling Counter using CountIf (Excel 2000)
Excel will not print the complete cell
External hyperlink to Excel 2010 worksheet
excel 2010 wants to install another program when opening
Code to open up worbooks and copy data
compute sequence (partition) number
Line spacing in wrapped text
Excel 2010 Flowcharts
Hide Unhide Columns
Check for certain duplicates but not all
Using the "find" command excel 10
Link Several sources to one spreadsheet.
Graph Needed For Time
Concatenation and quotation marks
Adding values based on a certain criteria
Fliping a range
Filtering based on text in Excel rows
Setting up a check box
Pivot Table Macro
Some design ideas please
working with multiple excel sessions
Writing a formula in a pivot table & being able to copy it to other cells
Excel Vlookup $ problem
Sending a message in the body of an email
Interchanging columns in Excel 2010
Macro to create Pivot Table
MS Query in Excel 2010: concatenating two fields returns error?
Getting rid of #n/a in a vlookup formula ( excel 2010)
formula help
Hide Duplicate rows in a range and give serial no
Batch file to copy sheet
Excel - how to copy the sum from one cell and pasting as a value in another
Excel - how to automatically format number (##) to text (US$##.##)
Help with Code
Form, hiding/unhiding active X controls & maintaining position
MS Excel 2010 { } function
Julian day in formula
VBA Code to copy specific data drom Source Workbook to Destination Workbook
Strange behavior for a combination chart (Excel 2010 and beyond)
Convert Formula to Value and copy values
VBA Code to Open Workbook and copy data into destination workbook
More than one Cell Being Selected - Excel 2010
Want a user function in Excel to add incrementing counter to list of values
A quick way of naming a lot of cells?
Protected Sheet & Book but developer mode still allowed?
Tutorials on VBA
Column name headers cut off at top
Macro to export sheet as CSV
VBA Code to extract specific Data
MultiConditional formula
curve fitting
counting greater thans
Sales Forecasting
Need a Macro to turn "off and on" conditional formating
find a text in a string
Excel 2003 using Send To, Mail Recipient quandry
Design Science's MathType add-in to Excel 2010
formula for adding time to a date based on a number entered into a cell
Cell does not display formula results
copying and pasting a hyperlink in VBA Excel 2003
Page Number to Exclude Count for Title page and TOC
Change Excel input mode
Dropdown conditionally based on values in a table
Formula in data validation List
Select Data in Excel 2007 will not update graph
Highlighting rows based on column value
Excel 2010 Locked Printing Inconsistencies
Insert Rows - colour filled cells repeated
What's in column B
What's in column B?
How to sum 2 sum_ranges using one SUMIFS? (Excel 2010)
Pivot Table-Displaying Current financials Years Data
Excel 2003: Filling a form with data from spreadsheet
Alternative to search and replace filename
Create new workbook with tabs from another (VBA)
Calculated Field function help IF X OR Y THEN =1
Skip if there is a blank in the range move to next row
Still struggling with VBA for copying a sheet
data validation not ignoring blanks
Can't read entries in Excel
Deleting Rows
Pivot Table Count No of Items per Category
Cannot save Excel file with macros
More VBA Help
Autofilter problem
Macro to move data from one sheet to another
Recorded macro in "Personal.xlsb" only works in original spreadsheet
vblookup problem
Compare data in two columns
table reformat
filling a form from data in separate worksheet Excel 2003
Model Railway Timetable Excel Spreadsheet - autosort help
Matching columns on seperate sheets
Clearing a Range of cells - size of Range not known
Extracting numbers and data
Another complication related to a drop down menu
drop down to reference drop down in another sheet
Using shapes in bar charts
Getting rid of the #VALUE error
Macro to copy all sheets into a new sheet
Weird happenings in Excel 2000
Excel 2010 Average Formula Changes
Apply Macro to Multiple workbooks simultaniously
Vlookup to look up interest %
Having the option of which input will effect calculations (CON'T)
Mortage Repayment question
Having the option of which input will effect calculations
Decoding HTML Encoding of Foreign Language Text in a Spreadsheet
Search String for Duplicates in Column C then sum of data
Input file name into a workbook
Error meesage if Report Stops
Copy data on string name
SUMIF? - Sum numbers if a condition is met
Macro to compare number
Format mask percent column.
Find "trigger" resulting from drop-down
VLOOKUP Assistance Please - Many Thanks
Issue - Range.Row in range in formula is offset?
Identifying the last break in employment
VBA code to capture dropdown entries on a web page
Spontaneous File Link Changes
Hiding Rows
formula for addressing
Use Keyboard shortcut in macro?
(9,8 - 9,1) - 0,7 = 0,000000000000001110223024625160 ??
How to format one cell(s) based on contents of another (Excel 2007)
Count down in # of days remaining
Highlight Approaching due date & ideally display a pop up box warning
Highlighting one word in a cell
Is there a "smarter" way to move a row to a different place in Excel?
indbedded if with a #value! excel 2010
Excel 2003 CELL function
Email PDF - PLEASE HELP
Graph Problem
Email Workbook using Outlook with two accounts
Sending Email with two Outlook Accounts
Excel 2010: Copy from all worksheets to one worksheet
Hyperlink to a UserForm
Automatin selecting and relocating number data from multiple worksheets?
Pivotable and other linked data to external sheets
Email
Count IF code for Excel worksheet
Allow Group and outline on protect sheet
Help w/simple excel log formula
Excel 2010 - Unsure How to Proceed
Counting # of occurences of a symbol
Excel 2010 Line Charts
Sorting Issue (2010)
Counting text that's only part of the cell
Count the text and fix to template
IF - ISTEXT - VLOOKUP STATEMENTs
Date problem
"Average" a Range of Strings (Like They Were Numbers)
Create a Dir
clear cells based on a formula
need to remove garbage from eml
Unique Renaming of Worksheet
Excel not passing parameters in hyperlinks
Delete Worksheet
text extract
problem with array formula
Cannot open up column a
Wacky page numbering
Compute average start time
Array formula explanation?
Show Status bar running code
Need a COUNTIF formula
If function help
Memo Field - Access to Excel
can I create a jpg or gif from an Excel chart using VBA?
Can't open excel spreadsheets when connected to Wi-Fi with corporate laptop