Microsoft Excel Discussion [Archive] - Page 4

Excel 2007: Finding Column Position
Importing data from XML
Worksheet size of two documents
macro not working
Using Time in Excel
Inserting a blank row between rows of data
IF and AND/OR
How to suggest new feature
Autocomplete - on/off by column
> LIMITED TIME OFFER!!!
Sampling
Customize quick access toolbar
Countif Problem
Using the "group and show detail" in a pivot table
OWC 11.0 in ASP.NET and C# to create excel file
Performing a comparison between two .csv files to extract data
RE: Rounding anomaly in Excel 2007 - columns not summing up equally
Significant digits
copy range of unique value
Excel 2007 display wrong "document in use by ... "message
Startup Runtime problem
columns within columns
Filter pull down icon color
concatenate more column value
concatenate more column value
How to keep loaded file's format intact?
Excel found unreadable content in file only with Windows 7.
Word Data to Excel
Excel footer - print worksheet name
Open excel file from Windows Explorer
Excel won't close properly
Compare cells for same values via VBA.
SORT is sorting my headings amongst the data
Return last value in column
SUBSTITUTE with 3 choices
Control Tip or MouseOver label on Excel shapes
Combine fields containing quotes
Excell and FrontPage
Rename Sheet87(Dallas) to Dallas(Dallas)?
Trimming an entire Column of text
Visible row index after applying a filter in Excel
Date formats in Excel 2003 under Vista
Re: finding exact text
Display report / summary based on data in two worksheets
Tranfering data from one spreadsheet to another Automatically
how ro reference to other sheet with look
automatically copy cell
Non Sheet Specific Sort Macro
Conversion from Quattro Pro 12 to Excel
Disabling &[Time] macro in headers and footers
tab character not work
Dumb Macro Question
Macro to insert rows based on user selection
QueryTable.Connection sstrin syntax
Excel Copy and Paste Special problem
Re: Office 2007 Excel opening a file question
Pivot Table Solve Order
Re: SUM Divided by COUNTIF w/o zeroes
Manipulating jpg's in Excel
weighted average profit margin
Force Column Headers On Each Page
selecting data from a list
Excel format in selected cells have changed to DATE format!!!!
Dividing text
Conditional Formating question - Excel 2003
Counting years
Copy cells with value <> 0 as a list
Unlock Cells on Condations
Re: Office 2007 Excel opening a file question
Conditional Formatting Does Not Refresh Automatically
Excel 2003 looses document properties
1 VLOOKUP question
RE: SUM Divided by COUNTIF w/o zeroes
Re: contribute & live toolbar won't go away.
Re: SUM Divided by COUNTIF w/o zeroes
Creating Subfolders
Re: Can't save minor changes to UDF
Re: Office 2007 Excel opening a file question
Using Excel ActiveX Textbox to populate another worksheet cell
"Reset Ignored Errors" Excel Error Checking options
How to reset .xls file association.
Turning negative to positive on a mass scale
autofill won't fill to end of used range
Copy part of one sheet to another while maintaining formatting
send a mail to each client
copy data vba
Install 2 different versions of MS Office at the same time
Re: Selection lost with VBA
Re: Selection lost with VBA
Find specific condition in a range
Form - how to get text to wrap
Convert PDF to Excel
Validate the format of a number
cannot get office 2003 professional to install on my laptop
Opening old excel files
Take Data From Other Files
Macro to Delete Blanks in Col and Move Remainder of Range Up
Pivot Table Error
Quick Access Toolbar
List rows if item in one column is unique
help on "ENABLE AUTOMATIC REFRESH"..
Page Numbering when Grouping Worksheets
count if function help
Flashing Cells
Import Macros Saved on a Personal.XLSW Spreadsheet
Installed MS Office and Recent Documents Keep Disappearring
Worksheet names in Start bar.
#Adding new worksheet problem
@How to add new worksheet on right side....
Advanced Filter
VLOOKUP and highlight row
Erase cell contents based upon a condition
Range Lookup
linked formatting? link color of cells on two tabs
Hold Italics
Formatting making file size huge
enter current time with seconds
list sheet comments
Square symbol
Cannot open Excel file - using correct password - colleague can
WORKDAY formulas reverting to #N/A ?
advance filter unique records except on column
Error Message when connecting pivot table to Access DB query
Changing Cell margins in excel
Enable automatic refresh
Excel 2007 Change Standard Colors How?
Hyperlink
@how to select Name Box from ...
Re: Find limited to 1024 char
Displaying a negative time
Copying numbers from Excel to Word
Shared book (sorry!) bloating and not disconnecting
retrieving data from a range of dates
macro copy data in one sheet
I need to write this formula in basic
Re: VBA: Variable with name of function?
Lock Cells with Hyperlink
Make Excel 2003 auto upate cell caluclations
different colors based on cell values in bubble graphs
Adding six hours to a time
Excel toolbar
Formula Problem
date format
Re: VBA Watch List: Is there a way to force arrays to auto-expand
help - how can I imbed a doc balloon?
Re: Can a VBA UDF tell who called it?
Re: Variable with name of function?
Concatenate multiple lines
Removing Letters and Dashes
Can i have 2 versions of XL installed on the same PC?
Problem with using named ranges to create charts
FYI: MSDG not displaying posts; expects duplicates :-(
HTML in a macro
Re: Change hour by one
@How to change worksheets with keyboard
Shared file keeps losing connection
Database and VBA
Issue with local named relative range
FrontPage Form Resultes with Excel
Re: Open Workbook with todays date
Re: Difference between MyUDF(A30:C30) and MyUDF(Total1:Total3)?
Re: Difference between MyUDF(A30:C30) and MyUDF(Total1:Total3)?
Re: Difference between MyUDF(A30:C30) and MyUDF(Total1:Total3)?
How can I change font on the row and column headers in 2007?
Data Validation drop-down
attach files
Data Cell Formula - cell = (a) unless total of cell is less than (b)
Multiple Toolbars in Excel 2007
Stopping excel from converting numbers into dates on import
Re: Add-in function sometimes gets called twice
Copying A Link Formula
Worksheets unmovable at open
match duplicate data in rows and columns in Excel 2003
Re: Format Text in Date Cell
Re: Format Text in Date Cell
Re: Format Text in Date Cell
Search Column For Data
matching entries by partial match
Sum by range of time
Macro deleting rows including some valu/ewpression
missing cell rows (jumps from 2 directly to 9)
delete the extra space at the end of an entry
How to multiply time?
Re: How to generate a string with values from a range?
Excel Formula
Re: VBA format function codes
Convert years:months to months
Excel 2007 Save As menu customizeable ?
VBA
Nested IF AND formula for a shorter one
Calculating a date
Get values from blank cells
Re: How to generate a string with values from a range?
Pivot Chart Values
Show all filled cells
Advanced filter macro? trouble
Linking spreadsheet where rows are not aligned, but are when portions are hidden
Copy calculated field
Conditional formatting
Formula Trendline
Copy Pivot calculated field to another pivot
Pivot Table Row Label Problem
Help with speeding up macro
Logical Formula Help
show info commandbutton
Link to another workbook & indirect
Determining latest entry in Row of values and extracting value
Double Clicking on Xls/Xlsx Opens Excel But Does Not Show Spreadsheet
LOOKUP problem
Re: Best way to save add-in versions
Re: Best way to save add-in versions
Re: MS Access Query
min formula
Can VBA macros be compiled?
GG posting problem (reported by Ken Johnson)
X axis titles on logarithmic scatter chart.
Linking broker website with excel
Sorting data and searching
Set Bookmark Range results in Type Mismatch
how to create a data view in excel for customers
Erase filter with macro button
formula if with condition in other cell
Cell value determines where to look
Why messages fail to appear on MSNews server
Arrange data based on two conditions
ignore this test (sorry; xyz)
Decimal minutes to mm:ss format
Counting across tabs
my studenst are asleep
Printing Report Card
Re: Sort Columns in Excel 2007
Re: Sort Columns in Excel 2007
Autofilter on non contiguous column ranges
copy/paste macro
Time Difference - Post reconciliation Check
Moving a column
Global Warming and what you can do to against it
Data - Subtotal error in excel 2003
Weekend / Non Weekend Days
Chart Format
Display text as date
Double vs Variant
Calc one month prior - text only
Macro copy range
Dates don´t show as they used to
Find two different, unknown, names in list
count in-between values
Returning a value from a table with multiple entries
sort a column by date- by month not year
Find and Replace in Multiple HTML Files with an Excel list
Executing a macro command
Grouped Objects in MS-Excel 2007
How to do math on cells with letters
switch off transforming number into date
Macro copies values in other workbook
How can I filter ofr odd and even values
Excel Office 2007 and maximum rows
Set environment variable on closing file
Hide Unhide Button
Date in excel
Macro that deletes values with condition
macro that copies all values of columns in column A
XMAS
Getting Rid of Zeros
Economical Auction Site
Adding a Formula as a data variable in a pivot
Countif multiple column criteria
~Count Between~
File permissions on Excel Workbook -- make only owner/admin read/w
Dynamic Range Chart and Ignoring Zeros
Excel 2003 Add-In - iSeries
Pivot Chart Row and Column Headers
Insert Graphic onto Worksheet
Math based on text or formatting
Creating a drop down list based on two cell values
Formula to count number of days that match, when comparing one daterange to another
Autofilter blue indicator arrow showing on wrong column
Excel 2007 .xlk file - why is it created?
Formula to show numbers except two
Shared workbook opens with all rows hidden
Unevenly spaced x axis on chart
How to cluster data with Excel
Excel trying to open files no longer existing..
Comparing Date Ranges in one Table to Date Ranges in another Table
drag down, not by series
Assign macro to enter
Re: Macro that shows range of dates
Protect sheet problem specific to mac
Macro case
Macro that shows range of dates
Unable to Open a File
Moving multiple worksheets
Re: Live Excel consulting?
formula tu sum up to a number till 7
Delete repeated values
I wanna show days and numbers automatically or with formulas
Show results in bold if a cell is in bold
problem with a macro autofilter to delet rows
Embed Hyperlinks
Linking Two Combo Boxes
Setting Conditions in a Cell
Re: Function gets value error
Re: Live Excel consulting?
Locating Info In New Excel Spreadsheet When Compared To Old One
Lookup for Most Recent Value of a category
Re: Function gets value error
Help on personalized "slope" function
Re: How to change chart legend text (Excel 2007)
Re: Live Excel consulting?
Merry Christmas fr. Garunar
Create a "Dead" Chart
Macros that draw shapes in Excel 2007
countif value falls in a range of possible values
macro that runs only when workbook is created
Discussion Forum Tools & Tips
workbooks.open freeze
Changing Text Import Wizard Defaults
Re: Formula to process 3 cells using IF statements
Objects Moving With Cells
Delete rows with true or false
Problem with a macro and rectangle
get code from some rows
Project not viewable in shared workbook
Trying to calculate the average cost per minute of cell phone usage
Function that helps me find the middle value
Pivot - Turn off 'click-through' functionality
Help with Autofit Row Height Macros
Convert text into formula.
Calculating Dates
CSV and Custom Fields
How to stop a vlookup function in vba
Cannot move or copy a sheet
separate data and change text to number
How to insert footpage number in a cell
Time Separators
Calculate minutes in different time zones
Automatic insertion of cell address
Excel Data Sort Help
Forcing a zero
Data Design & Filter
function udf with date and time
how to sum match score
Change info order
Stop duplicate data
Upper Case and Max 3 letters
Re: Prevent Excel from changing fractions to dates
Re: Difficult Sorting problem
Re: Using Defined Names for Column Values?
Re: Not working out
Re: Excel Function for Tax Calculations
Re: help functions
Quartiles in Charts
Quick Question - Extract Number from String
sheet tabs bar position - may i change?
How can I do a progress bar
blocked cells
Choosing numbers randomly
Off Topic First look Office 2010
macro duplicate sheets and refresh links
Summing unique values (where "unique" depends on multiple criteria")
Excel 2002 in Windows 7 ?
Changing Opening â€œBook1â€ & Templates
Third grade equation
Re: numbers as text
if statement to DISPLAY (not calculate) a formula?
Find cities visited
How to base a pivot table on another pivot table?
Expanding column count
Two Excel 2007 problems..
How to Past cells with formulas not using "$" without changing ref
Pivot - show as % of sub-total
finding macros/formulas used in a spreadsheet
Personal workbook does not save when it changes
Countifs with "or" embedded?
personal.xls in 2007
Re: seemingly simple dropdown menu/vlookup question
Please help!
seemingly simple dropdown menu/vlookup question
Count, for values within a range?
Pivot table numbers turn into dates on refresh
Any alternatives to excel?
Autoshapes
Clearing contents
Date formula
Using more than one OR Statement
count multiple values from contiguous range
Hide non-printing characters.
Sheet outline range.
Macro: make list of all files in all folder with sub folders
msft publisher fails to access all excel mailing list records
Formula Help
Multiple IIf with Is Null
Zip Codes Dropping Leading Zero
Excel issue..
Sort many columns independently, at once?
Excel not seeing cell value?
Re: For Next issue
For Next issue
Auto numbering down
Shared Workbook Saving issue
update data alert using = today()
Re: Excel doesn't show th data when double clcik on excel file
Excel 2007 Run Remote/Server/Network/Shared Macro From Custom Butt
Re: Slanted grid???
Does anyone know any Excel Experts ?
Excel crash when refresh pivot table
decimal time data entry
find data
counting grades
combining worksheets
Calorie Counter
Doing a VLOOKUP (probably using the INDEX and MATCH function), withboth vertical and horizontal values in play.
Lowest number excluding zero
Automatic Functions in Excel
Corrupted local file hyperlinks in Excel 2007
Stop Buttons Moving in Excel
Re: Challenging Sort Problem.
sumifs
VLOOKUP bug? Different answer for values vs calculated table.
average with exception of some cells?
Need some help with complicated (for me) formulas
Excel Cell Protection not Working
Re: Challenging Sort Problem.
Excel 2007 printing does not scale properly
Excel 2007 issue...Urgent
Name box too small
<<Extracting the desired data with an formula>>
Newbie OLAP pivottable filter and sort on values
Error message
Building a Dynamic Sheet number in a formula
copy cell color but not conditional format equations
Strip out text/numbers
Re: vlookup between 2 spreadsheets?
Nested IF driving me nuts...
help with naming file, re extension
Move to same cell, next worksheet
Solver not showing up even though it is loaded
Excel links via SharePoint
count if a match occurs
How to combine cells into one
Re: Jumping blank lines in autofilter
Problems autofit rowheight with wrapped text (but no merged cells)
Fill the below blank cells
dynamic build
screen corruption
09-uggmax
Sorting problem
Using excel for a colour calculation
Columns limit
Excel Books
Text formatted for Days and Dates
Is this Multi-Search Macro Possible?
Calculate difference between hours
Help with Lookup
Conditional Sum wizard...How to enable it?
Graph
Conditional Sum in Excel 2007
Finding cells with leading characters
Finding cells with leading characters
Finding leading characters
column with all the working days of next year
Converting .txt file to Excel
Re: Displaying Actual Cell Values
Run macro from shape when runnig macro in Excel 2007
Job for VLOOKUP?
Appending Pairs of Column Data!
excel rounding error?
How can I resize/restore the File > Save As window?
Using Excel for a Survey
VBA change filter match from INCLUDE to EXACT,
Display Text with Formulas
Excel using =RC[-1] format and I don't want it
Excel 2003: automatic grid borderlines?
can you look up info from a validated drop down menu in excel 2007
Pivot table problems since the install of KB973475
Excel Localization and Pivot Tables
pivot table question - want to get a range of values as a field
comments
Format
Re: Displaying Actual Cell Values
Re: Displaying Actual Cell Values
Finding last accessed point of time to a list of files
change color what is in between brackets
Macro for resizing excel chart to match powerpoint destination?
Re: Elimination Of Lines With Certain Criteria
Macro: set filter containing certain value(s)
Pivot Table
Lookup Value
RE: Challenging Sort Problem
PLEASE HELP
Format an underline for zero in accounting format
find Brackets and change color
Opening Excel in a foreign language
Re: Chi Square questions
Re: Chi Square questions
if value, then bold? any help?
Re: Adding dates ... to previous weekday if falls on weekend.
getting rid of blank area
Formula using "If" and "or" criteria.
Re: Adding dates ... to previous weekday if falls on weekend.
Re: Adding dates ... to previous weekday if falls on weekend.
Re: Ctrl + F not working?
Re: Data Validation - Custom
Adding dates ... to previous weekday if falls on weekend.
Data Validation - Custom
fill right
Plotting two datasets on a graph
SOS! how do I write a customized function to do multiple-value lookupin Excel 2007?
Problem with ISBLANK Function
Re: Challenging Sort Problem
Formulas
Making formula read sheetname from a cell in my main sheet.
inviting investors, students, entrepreneurs
inviting investors, students, entrepreneurs
Count Conditional formating data
change csv list separator in excel 2007 Dutch version
Re: Counting against a date
Replace non-printing characters.
Chart Help Please!
insert row not taken into account by sum box
64 bit versions of Excel
Multi-filtering per worksheet
adding one colum up with referance to a second
Need Help of How to do a Filter
Excel crashes when writing formula referencing to external workbookin freeze frame
Make a complete list of words from texts in a range
Problem with saving excel 2003 files on network
PRO11.MSI
Pivot tables downgrade 2007->2003
Excel2007: copying filtered table values, how can I copy ONLY thefiltered values
Problem with footer data with Excel 2003 and 2007
Date Picker
Pictures in Excel cells
Highlight Duplicate Column
PIvot Table top Values
KPIs in OLAP PivotTables
Creating a customised list
Word Detect and Repair screwed up Excel
MSVCR80.dll not found error message
Re: Text function multinational format
Re: Text function multinational format
Text function multinational format
Re: number format
Re: Auto filter Hiccups
number format
Auto filter Hiccups
Help with IF statement check value in multiple cells
Pivot Table drill down and 256 character limit
How to get cell coordinates?
Re: Refer to same range on another sheet
Re: Refer to same range on another sheet
count string in cell
The code below worked for a few days and just totally stoppedworking. What can I do to make sure it continues to work? Thanks!
Shorten long IF statement.
Upgrade from Excel 2003 to 2007
Merging two excel files
Forms. Reccomend a good site for teaching?
Pulling data from one sheet to another
Conditional formatting on pivottable
Why is xlsx version slow to open
Use of EDATE function
help - problem with data using vlookup in Excel 2003
troubles with delimited files
Add-ins and #NAME errors
Dates show up as a 5 digit number in Excel 2007
how to find a second comma in a text
VBA Error when trying to save
sorting; blanks at the top; what is a "blank"
Re: Changing format for -2^2?
Autofilter Problem
Formula in opposite direction
Re: Changing format for -2^2?
TRUE/ FALSE in check boxes do not toggle
countif formula with 2 critrtia
formula and delete sheet
10 Reasons Why YOU Should Join Us
Excel query help with union select
PIVOT - COUNT IF "YES"
sum if duplicate
summing values of duplicate entries
SumIF with 2 critrtia
Sumproduct
Language Problem
Find any cell with a specific format
Can series 1,2,3 label in data be RE labeled to different text?
copy conditional formats
Excel 2007 Form errors in calculations
how to do in excel
Count YEAR value?
Open file from Jump List
Convert E to exponent?
Splitting cells into multiple records
Excel display problem
Identify and email name of user
How to delete rows automatically with values zero out?
Double Clciking Excel File
protecting all sheets in workbook
SUMPRODUCT Within certain Times
Reviewing Toolbar - cancel auto appearance?
How to preserve Excell 2007 conditional formatting for non Excel u
Macro: Find matching DATA, copy correspondently values into anotherlist
DATE
Date Format
zero in a range
Lookup Question
Can Someone Please Tell Me What's Going On
extracting multiple rows of data from another worksheet
How to identify a cell [format|category|number|scientific] for sea
simple formula formatting question
Searching for Excel Cells with [Format|Category|Scientific] Specif
Conditional Format Help
How to create a "dynamic" sql code
Excel 2007 stops responding
Re: Prevent Excel from changing fractions to dates
Conditional formatting depending on sub string content i cell
How do i format this time ?
Macro: Save and update/replace comments in a list - tricky task
problem writing this (1/(1+0.38))^2
Excel licence message
Sorting in Excel like in Window Explorer
Upgrade to 2003
VBA Worksheet Event Change or Selection Question, please assist me
Find cells in a range that sum to an amount
How do I jump to the last filled cell in a range?
Re: Prevent Excel from changing fractions to dates
Quick VBA Worksheet Change Event or Selection Question:
data lookup/validation syntax
Most Right Value in a Row
Lookup Question and Formula
Teensy problem with hyperlinks in Excel 2003
Macro to take to last line and insert new row with number
Can you use multiple vlookup's to generate one answer?
Error Message When opening Excel
Re: Difficult Sorting problem
Date Changes to General
Run Routine Automatically
Chart of Times
look in coulm
SUMIF with a twist
ActiveDocument.Variables / ActiveWorkbook.?
Return vlookup result but only for the first hit
Re: Cannot enter certain text in cell
Not genuine copy of Office 2007?
Re: Using Defined Names for Column Values?
Re: Using Defined Names for Column Values?
Re: Not working out
Customized Format
Conditional formatting
Average Top N performance in table
Changing Radians to Degrees
if the numbers in sequence
Help for formulas in spreadsheet
Re: Excel Function for Tax Calculations
Standard header footer to all my spreadsheets I make
N/A - conditional format so as not to appear in screen
Re: help functions
Problem with MACRO recording
Re: help functions
CLEAN function
Re: help functions
Problem printing underlines
Excel
Sorting Range that Contains Merged Cells
Re: simple question
Re: simple question
Excel Mobile doesn't like XL2000 file?
Re: simple question
Re: simple question
Dropdown list allows other enteries
Min function with a variable range
text typed into one cell shows up in another
Filter Duplicate Records keeping record with latest date
If SUMPRODUCT & Blank cells
Stacked Column bar charts smallest value / excess on top
"germany jobs" "germany job sites" "germany job search" "jobs ingermany" "german jobs" "germany jobs it" "germany jobs for foreigners"
COUNT ON NON-CONTINOUS CELLS
Pivot Table display
Re: Local names
Using match to return value
Excel Read Only in New Windows 7 Installation
Re: Local names
Re: Local names
error (bug?) with VLOOKUP function
Copy range to multiple workbooks
TRIM formula over multiple cells
Problem with ISTEXT()
Use different numbers for a calculation dependent on input
Re: How to change cell shading/fill based on value in another cell?
Macro to reveal three hidden rows each time it's clicked
Preserve number as text in Pivot table sum of values field
Use data from DBaseIV table in Excel 2007?
Excel Rows to Word Docs
checksum; generate for sheet; already done?
Macro to always take you to the last active row
How to use formula to get
Need help entering cell formula
Macro running slow
Networkdays
Presenting Pivot table data as product of 2 source data columns
Conditional validation?
Converting Text to Number by formula (Opposite to Text("000",A1) )
Pivot Table formatting
Referenced cells from other Excel files and need to permanently setcells
Re: Sorting - Keeping multiple
Subtotal In Excel 2007 Table
Excel Index of Worksheet Headers
Re: Sorting - Keeping multiple locations together - Still a Problem
Variable Mean Source Range
Excel 2007 - Conditional results added together in a totals cell
automatically adjust sum to include top row (added)
Saving within email
Running VB Code
Building folder-list in Excel
functions; passing parameters; optional as string or range?
Autorepublish
Conditional pivot update
Complex excel - calling formulae result and setting as value of aspecific cell
adding check boxes into an excel workbook
How does excel do Top 10 in pivot
Excel Tools that make sense, FREE ADD-IN
cell format, custom type: mmm-yy; working with
Excel
Need help with lookup
Problems searching mail in archive folders
VBA function performance
Convert Excel list
Cube formulas and Excel compatibility
excel 2002
excel 2002
Two versions of Excel in Win 7//
find and replace code?
Using possibly If and Vlookup
Showing Distinct Values on a Sheet
need to have SUM formula update on row add/delete/move - Excel 2003
Re: Sorting - Keeping multiple
Re: Sorting - Keeping multiple
Re: Simple sheet to calculate contractor pay
Shared macro not working for one user.
Macro: Hyperlink shown as ...."OPEN file"
Wrapping doesn't collapse rows
Forgot password for Excel 2007 spreadsheet (*.xls)
Data Refresh Speed
Re: Deleting a excel file
Drawing blank - Need from what I hope simple solution
Excel - Creating Tabbed Delimited Text File - Need help with blankcell output
Re: IF statement
Re: IF statement
Re: IF statement
Opening multiple Excel files from IE browser does not open in new instance of Excel - BUG?
opening excel files in new instance