Microsoft Excel Misc [Archive] - Page 24

consolidate workbooks to worksheets in one workbook?
Sheet Count & Insert NewRow
Merge /Update Macro
Auto Sum equivalent for Subtract / Multiply / Divide
Sumif with not criterion
Text Boxes in Shared Workbooks
Barcode suffix ean128
To find rate of each item from item.xls and to copy price.xls
Negative Conditional Formatting Excel 2003
can we map calender in to excel worksheet's cell.
Can Excel do this or do I need a different program?
how to make a default font for a precise row
Excel formula
Fill Series for Lookup
Copying down formatting
HOW TO COUNT INSIDE A CELL
Paste cell to last row in range
Using Excel for Decision Making
Turning Off an Advanced Filter
SUMIF by Week.
Vlookup I think
Hyperlink w/ vlookup
How to enable marco/vba editor?
Shading row based on value in one of its columns
Limit using pivot table with Access database?
How to use a range of time to assign a score?
HOW DO I INSERT 1 SPACE BEFORE A TELEPHONE NUMBER IN EXCEL SPREAD
Vlookups don't recognize text to column cells - why?
Paste Value Formula
Links to folders used to store web pages
how do i change to a bar code font in excel 2007
Cells change color when another cell is activated or typed with an
Conditional Formatting
formula question
link to calendar
Not More Than or Maximum in a formula
Need help with formatting / saving before I email my worksheet
Scroll Lock stuck on
Why is my question being repeatedly deleted?
Attach Word document to a text box in Excel
Saving Excel 2007 file in 2003 creates very large file
Copy & Paste Special Operations
Why won't Excel open xls file after I saved it with notepad!
sumif
Formula Help Please
IF statement syntax
Looking for a formula to perform this additions
Formula too large
"Not More Than" in a formula
File Disappeared
Pivot Table - Show difference
taking the file extension out of the file name
Display HTML
Can I search for the displayed value in a cell, not the contents?
Opening files in separate windows
Emailing Linked Excel Files
Comparing Lists
Unwanted Color Fill When Emailing
accumulate time file is open
Finding row, then copy paste (macro)
A specific date used for calculation of a new date
Match Cells expanded
How to create a formula with multiple (IF) conditions
Match cells
type on one sheet automatically apear also on another sheet
plotting line graph with 2 x values
Macros & "Convert to Number"
How do I use "sumif" for cells ">0" across multiple ranges?
automatic scroll, how do I disable it?
creating an new excel document (2002) to work out dates
Vertical page breaks won't drag in Page Break Preview
fig from excel not correct decimal place when merged. In word
Change cell colour
Automatic date entry
Pivot Table - show all row fields
Urgent: Excel 2003 - 2007 conflict!
Using autofill in Excel 2007
Numbering in blocks on 5
add symbols to autocrrect in excel 2007
Get excel to automatically go to the next cell w/o pressing enter
Excel Cell Height - white space
Count formula
sumproduct with criteria and multiply problem
Why must I configure excel with every use
Help with Dual Conditional issue (sumif?)
track and find crews or inventory
A slightly complicated finance problem
setting excel formula from code
Conditional Formatting
How can I update 2 or 3 duplicate workbooks in separate folders?
Formula Help
How do I set more then 3 Condition for a cell?
randomize a list
RE: How do I remove new line characters from a cell?(cathyc)
How do I remove new line characters from a cell?
12 MONTH INCOME PROJECTION sheet template?
in excel when i hit return, the cursor does not drop down 1 cell
How can we scale Excel or Word to print and fit on 1 page?
instead of using strikethrough, can you type a word
Go to this section of a workshee if M2="Y" go to O2-U2 if "N" go t
how can i automatically generate work order numbers from work orde
Merging cell data into a document?
conditional value in a cell
Why does my 100% Normal Page view not match Print Preview?
How to Alphebetize one column, but keep next column together with
XL2007 crash using MS Query in vista 64
Toolbar not working correctly in IE after loading Excel doc in bro
Some comments stay hidden even after picking show/hide all why?
looking for scheduling examples
Date plus month, year, or years in workdays
hyperlink
Windows Mobile 6.1 Pocket Excel & Macros / VBA
Combine text functions
Freeze Panes?
trying to find last row
auto scale print area
How to set up a worksheet to open where the next text should go?
conditional formatting many rows
How do I calculate standard error in excel?
Crack excel passwords
Change color of answer
Need help for a formula
Pivot Table
SUMIFS using an "Or" condition?
Display Issues
Convert date to age
conversion liter to kg
RE: I want to rename my worksheet tabs...
RE: I want to rename my worksheet tabs...
Excel 2007 Crash Due to Linked File
conversion liter to kilogram
Concatenate problem
Amend Formula
Cannot See Sort Ascending/Descding option in drop down filter
Multiple files open when starting Excel
Excel file gets corrupt if saved in one particular drive
Excel spreadsheet bunching up when filter
Using LARGE function in incontiguous cells
resizing calendar in excell 2003.
If statement for alpha numeric combo AND numeric only
I auto create a backup for each Word doc. How can I in Excel?
Re: use of drag-fill handle in a crosstab
OPENING AND CLOSING OF EXCEL 07 FILES
Color parts of a chart
Formula Help
Excel formula Help
When I save a workbook(2007) w/ a data connection to htm no data?
Insert Large Arrow with Text
Place shape/clipart over radio button
Entering an "IF" formula
Help with Cell Formula
how to convert project management file to acrobat
Help with Cell Formula
excel previous weekday function
excel weekday function
Need to Insert Page Number Watermark in Excel 2007
Sumproduct - Date Range
Sumproduct - Date Range
auto hide blank rows
How do I copy first consonant from a word into new cell
Re: Copy an array of Sheets
I need to have a record number change for every record
Re: setting up excel to insert time of day
Cursor movement
formula to insert time of day in excel cell
use of drag-fill handle in a crosstab
how do I tell Excel to apply cell styles automatically
hw can i total a sum of hours and minuts ans secnds with the time
Quattro Pro Conversion
Can't download Excel templates using Vista Home Premium
Can't download Excel templates using Vista Home Premium
Can't download Excel templates using Vista Home Premium
compare data from different worksheets and return matching results
Re: Link text between different worksheets within a workbook
Let User Select Sheet to Pull Data From
how do I insert a single quote on every cell in a column to make .
Excel Formatting Problem
Help with a pop-up msg
Sumif ">today()"
Named range/cell, sort & delete
Import large number string
Vlookup causes Excel to shut down
sumif? array enter?
Help! Names defined in Excel 2003 invalid in Excel 2007
Subtotal of Pivot "Max" calculation problem
Text Box Issue
Select a list in 1 cell by selecting an item from another list in
Problem (bug?) in the way Excel 2007 doesn't automatically load ma
Locked worksheet & hyperlinks (w/ select locked cells unchecked)
Average function
Auto Fill Help
Need formula help
Help: Print settings removed between users!
Countif based of partial cell contents
Functions - Difference b/w two dates
MS Query 2000 on dates with parameters
Percentage
UNABLE TO OPEN .CHM HELP FILE
Convert Text in cell to hh:mm:ss
Calculating STDEV for non zeroes
Conditional extract from database
Auto filling dates
Converting an old Quattro Pro .wb2 to Excel 2007
Pattern colors
Linking worksheets - Specific Information
including entire worksheet sort in a macro
how do I shade alternating rows in spreadsheet
Formula for Growth %
Compare multiple cells and highlight differences
Formulas in Pivot Table
Transferring/Merging Data Between Worksheets
how to replace an unrecognised character
Change Case
Selecting cells highlight
Conditional Formatting a Report based on a query
Deleting Macro Short Cuts
Create New Table Styles
RE: Update total based on two columns
Update total based on two columns
Sorting in Tables
Paste Link problems
How to copy 2007 excel file formula results into a 2003 Excel file
Lock Cell Borders
How to interchange the values between two selected cells?
Direct to sheet
conditional formatting
Copying a formula from original cell to mutilpe cells?
Re: mail merge not working
How to use hyperlink to chart?
How do I re - build border of my cell?
Border
Help to create biweekly dates excluding nonworking days
Sum IF ?
break column
How do I get excel to open with cursor in same cell as when close
DATE RANGE FORMULA
XL 07 Data : Text to Columns
New Excel 2007 user
IF OR statement help
Automation error '-2147417848 (80010108)' excel 2007
recovering an unsaved file
Find Feature
Re: add every other cell from another worksheet
VLOOKUP Error
Skipping Rows with cursor
IF STATEMENT HELP
How do I turn off random multiple cell selection in Excel?
Determining availability time
linking worksheets with hyperlinks
Average Summary Not Working
transfering data between sheets
Re: delete characters at the end
Excel 2002 : Any fast way of converting positive to negative numbe
How to insert row on Col A field change
Re: delete characters at the end
Workshee LLinks
Finding Duplicates in Multiple Columns
Paste cells copied from another sheet
Auto Cell Sorting from WS to WS
Re: delete characters at the end
RE: delete characters at the end
Re: delete characters at the end
How to change a sum to an actual number I can paste into a new do.
Excel 2007 - Email Option
Match data duplicates
How to find the first Word in a range ?
EXCEL MACRO 2007
Printing problems in Excel 2007
Pictures and/or Graphs in Print Preview not Printing in Excel and
More than 3 criteria in Conditional Formatting
Adding items to a combo box on a user form
Multiple Style in Excel 2003
Find data not hi-lited
hiding formula in cell
Refresh Pivot table data in Protected sheet
formula to calculate the number
formula to calculate the number of people
pdf file
when I try to change office assistant I get "not enough memory...
RE: merging text from two cells
splitting data from one column into two
merging text from two cells
sorting text & numbers
changing capslock letters into normal letters
security for tabs
If cell = now – current Qtr – 28 days then RED
Excel Size ?
COUNT A YES STATEMENT AGAINST A NAME
Import External Data not picking up letters
Deselect B1 & move curser to select A1
How to transfer "text" into "date"?
Is there a way to continuos sort data ?
How can I find loan manager in MS Excel 2008?
How to find the latest date?
Data Entry Form
How many number digits can I fit into one cell?
Merging Worksheets via command button
Refresh Pivot table data in protect sheet
[Excel 2003] File size equal to zero
LOOKUP OR MATCH QUESTION PLEASE
how to set reminder?
Excel formula help
erratic response while working on a table in excel linked to a tab
erratic response while working on a table in excel linked to a tab
mutliply a worksheet by a constant
Embedding an Excel 2007 worksheet into an email without attaching
Hypertext link
How do I print worksheet columns that aren't visible in preview?
Hyperlinks
improve clarity of excel data linked in PowerPoint
Hiding amounts that equal 0
Re: Average only if all cells filled
Unable to sort "words" that are numbers and letters
Data Validation
how to put my own pictures onto toolbar buttons in excel 2007
Hiding Header Columns abc... in 2007
Excel: Format empty date cells
RE: Text into Numeric values?
RE: Text into Numeric values?
Re: Text into Numeric values?
Re: mail merge not working
Cells
RE: mail merge not working
Replacing using a wildcard
Add days, excluding Sunday's and Holiday's
vlookup help
Dynamic Protected Range?
Trying to develop equation
show geographic locations on excel sheet
Is there a function to round down in Excel?
Copying Worksheet changes page alignment?
Can you use math functions as arguments in a subtotal formula?
Can Comments be printed in a spreadsheet?
Pivot table and chart refresh not an option
Page break issues
Recent Documents
Can you export comments?
How do I stop the copyright symb from displaying when I type (C)
Legend overlaps the plot data area in Excel 2007
Pivot table column limits
Pivot tables in excel
Advanced IF Formula help needed
RE: Average only if all cells filled
Re: Average only if all cells filled
Which formula is this" {sum()*()*()}"
Sorting
Vlookup and sum
outlook/excel
EXCEL MACRO
Add comma in last name first name
unable to set the values property of the series class
subscript
if statement in formula
Memos or Comments in Excel
Menu Behavior
Menu which appears when you right mouse click in excel sheet
Show/Hide
Pivot Table Editing or formulas
Pivot tables - calculations based on different sets of data
Trying to create formula...
can't send form as e-mail
how do I edit the content of a drop-down menu in excel?
select a single cell in excel 07, currently selecting a goup
If formula control conditional formatting
My Recent Documents
Why cant I exclude items with no data from the Page Field?
EZ?- Trying to insert a simple formula using VB
Count the Number of Weekdays by Month
Excel Dropdown menu
Sumproduct - several sheets ... indirect?
advise calculation is complete
Error Message
Sheet becomes a hyperlink when protected
how do i use excel to calculate weight (as in stone and lbs)?
Close User Form
Count macro
Lock Drop down Menu
CELL FORMULAS
Solver doesn't seem to react
Macro to create a Weekly Workbook
new cells in excel default to locked?
Internal cell margins (Excel 2003)
Setting column width to specific row in Excel doc ??? Thanks!
Divide by zero error
How do I create a formula that gives number records with certain d
Function to display details?
multiple drop down menu
How to keep UserForm open at all times while excel is running
Merge excel files
Round up an average
Count total balance using two numbers
How do I merge duplicated data in rows with different criteria
Drop-Down Menu
Re: WK4 files
WK4 files
conditionally formatting cells based on other cells
Get the row count of different areas in the Excel
Saving email attachments
Macro to Close a specific workbook.
Charting from Multiple Excel Files
saving data?
Macro saved .xls file is not opening in 2007
SUMPRODUCT with 3 criteria
IF formula
Adjusting formula for month in vlookup?
Pivot Table Calculations
how do I get a top 25 on a pivot table in excel 2007
How do I use Bin for data analysis?
How do I freeze/ unfreeze a window pane in Excel 2007?
MATCH A NUMBER IN A COLUMN WITH A COLUMN IN A DIFFERENT SHEET
crazy format/formula
why do I see " too many formats" message in Excel 2007
Alpha sorting (with a twist...?)
I want to change the page order so that page 3 and 4 become 1and2
Pivot Data and Filter on separate sheets
Lookup Ranges
Re: My spreadsheet in some cases automatically adds a row below how?
My spreadsheet in some cases automatically adds a row below how?
Import Data, using a command line switch
Unshared workbooks yet multiple people able to open
keep variable value after code quits
concatenate 2 columns (A2+B2) and compare for duplicates
Nested if then else statement
can you split and freeze simultaneously in the same excel document
"paste picture link" behaving strangely
#Value! error in cell
Too Many differnt Cell Formats in excel sheet
Too Many differnt Cell Formats in excel sheet
how do I set up the openning type of file
converting working hours to days
Printing Charts Excel 2003/2007 - Rendering Problems
Formula Help
Formula quandary?
Office 2007 Trial
Clear Checkbox
Unticking a Checkbox
help with option lists - also, this qstion is supposedly not posti
I need an option list for a table...
i need an option list
Vlookup - return exact phrase
Pivot Table loses Data Connection
Formula help please
Converting number into proper date format
AB or BA
Date format plus calc
formatting numbers
Changing a cell value from another cell.
Conditional Formatting
lookup options
Count same text from different rows
Why will Excel not apply a theme
Find Last cell in Range when range is date format
Excel 2003
Disable save on read only??
Paste Graphs as Pics with 2003 in a VBE
Returning to original view.
Conditional Formatting??
Copying subtotals Only
I want a macro to run anywhere on a spreadsheet, based on cursor
diagram i excel
diable macro if a certain sheet is active
auditor tickmarks
I want to create a savings cash flow according to what I spend/sav
Histograms with Cells and Curve Fitting
drop down's
spreadsheet disappeared
Two sheets into one remapped? How to do it.
a simple 'sum' formula is not adding all of the data in range
Help please - not sure
Troubleshooting 100% Stacked Bar Chart
Compare worksheets
Auto-Format Cell Shading
conditional formatting
Need the grand total pivot table filtered worksheet?
problem with run-time error'424'
Rows
MAX function
RE: data type inconsistency
how do I find my previous posts?
problem filling in blank cells with data above -
Strip away leading zeros
Lock Cells Dependent on Prior Months
Re: Problem!
Problem!
Re: Analysis Add-on for Office 2003--How Load?
How do I do a "mail merge" from excel to excel?
Create a relative column formula
SUM with multiple + and -
Can't access Advanced Document Properties
Conditional calculated field in pivot table?
Formula Based on Table of Data
to many formate
Referrences of multiple cells from one worksheet to another
Display state abbreviation from full name
RE: Auto adding a macro when Excel 2003 opens
Auto adding a macro when Excel 2003 opens
IF formula to conditionally format a cell
If formula to conditonally format a cell
File opens blank - but it's not blank
Sort by last two characters, not the first.
Subtotals and filters
Extract from one sheet to another
Clearing Contents
Macros
VLOOKUP with multiple lookup_value's
Match function
Pivot table data source
If statement
How can I higlight and clear contents but not formulas
Minimum non-zero value
Data Sort
display a complete list of tasks by selecting on a task
ALT+ENTER has stopped working in Excel
general ledger
When I hit 'enter' on a formula, nothing happens.
Use commas as decimal separator
=Text
Searching from bottom to top with MATCH?
Visual Basic: Get row count of a sheet in Excel
What does "~" do to the data in a cell?
Text to Formula
solving nested IF statements
Re: option not avaliable
RE: SUM a range dependent on dates
Create an Invoice from a row of data
SUM a range dependent on dates
conditional minimum formula
Excel 2003 VBA Macro
Saving to different format without renaming workpage?
Macro adjustment
how can i change the colour of cursor only
Linking to panes by changing value in a cell - is it possible?
Pivot Refresh Error when calling Excel Macro from VB.NET program
Sorting
naming a column
RE: Formula help
Formula help
Formula Help
Hold conditional formatting when sorting filtered data
date range
in spreadsheets copying cell contents plus font colour
cell references in vba
Subtotal by Date and Summary in Lists?
sort a table without including titles which r on each page
min if
Conflict between Excel and Outlook
Error message when attempting to set up an Excel workspace
Trying to make both averages AND sums of one spreadsheet of data
Best Way to Pull Data from Other Sheets
Click Option Button 2x in a Row
Copy & paste to protected sheet
Insert letter in cell
.xls file is not opening in excel 2007
How to create a list of permutations and combinations?
Delete rows
Re: is 0.000000000000000055511151231258=0 in excell?
Retriving text from a column
UDF in module of personal.xls
How to Substract a word from right side of the column using Right(
sumproduct - <>
Enlarge objects in excel
Template NFL Season for a office pool
array formula
Use Formula to Replace A Cell
Any Way to Use Vlookup in Reverse?
Combo Box - How to Use Output in Vlookup
Chart avisor
Insert, Delete row and cell
How to get a drop down menu to return another value
Use macro to write formula
Autoformat/Conditional Format of entered Number
Excel 2007 workbook reference
RE: sum a range based on current financial year and client id
how can i find a value in a range?
Refreshing Pivot Table on a protected spreadsheet tab
Q about sheet protection
combining two sets of data
Macro Fill Cells With Formula; Conditional To Seperate Column
What's the vba code equivalent for Countif
flash object dont work in my excel work sheet
Guidelines for posting questions?
Still more on loading a .CSV into a .XSLS
link between cells
How do you apply criteria in order of preference?
copy formulas over merged cells
Is there a formula that will return only the month from a date?
Sorting rows of data of varying lengths
how to zoom into excel line chart with about 2000 point tia sal22
Can't Stop the clock
copy from excell to word without grid
copy excel 2007 to word 2007
How do I abbreviate a year?
How to create percentages for the combined rows?
Random number macro
cell address changes
Re: Macro in Hyperlink
How can I fill a block of 300 cells with non-repeating random #s
Dynamic Range Within INDEX
Formula
column to show certain percent positive AND negative
Excel: Arrow keys scroll instead of moving to next cell??!!
Totalling number of text entries on a worksheet
formula
color after depending on 1st value in a cell
RE: Merging Lines of data
Merging Lines of data
Tabbing within a cell
can I create outlook reminders from worksheet data?
View set to 'best fit' for User
cell border problems in 2007
I want to create an "average color" formula.
Auto Refresh
Lookup ?
Conditional Formating
Code problem
Cell name to change name in codes of command buttons
VLook Up Error
End of document
VLookup - Choose Which Occurence of Lookup value to bring back
Vlookup
Delete rows based on multiple criteria
excel 2003
sum up two result in one column
RE: VB help required
writing coloured text with formulas
Combo box
How to shift a weekend date to the last or next workday
Can't make excel do what i want...
clock on user form
Opening Office 2003 excel file in Office Excel 2007
How do I add digits to all numbers in a column?
protection
combine rows and sum data with the same id
ALPHA/NUMERICAL SORT
getting rid of the "confirm delete" dialogue box when deleting a s
formulas
Re: Convert to Values
Convert to Values
how do I select every third cell in a row in excel?
MULTIPLE IF STATEMENTS PULLING DATA FROM MORE THAN ONE COLUMN
formula to calculate sum of payment increased by 3% annually
Text turns into date - how to stop?
default page breaks in Excel 2007
IF and THEN statements
Excel 2007 - display negative numbers with minus sign and parenthe
Re: is 0.000000000000000055511151231258=0 in excell?
page names in a workbook
IF/VLOOKUP with #N/A results
RE: is 0.000000000000000055511151231258=0 in excell?
RE: Need help w/ MS 2007 Excel/PowerPoint chart
very large WB-what can I do to find a specific tab w/o scrolling?
Re: checking the absolute value of a number
RE: checking the absolute value of a number
RE: checking the absolute value of a number
checking the absolute value of a number
Subtotals headings
Finding Duplicate Rows (Macro)
Check for Non Blank and Blank Cells Before Save
Excel 2002: How to insert an Auto Fit Width button at the tool bar
Locking Cells
Date Formula for number of days between a date and today
Musical Chairs using Excel.?
Canadian GST Expense Report Templates
Chart Number Decimal Places
Only allow cell content if it lready exists
Named Formula Not Always Calculating
Excel change a group of positive numbers to negitive numbers
importing a poster created in Excel into Publisher
how to make ........ even after a title in a cell?
Change selected cell shading colour
Postcode structure for data validation
Copying formulas between different versions into Excel 2007
borders between 2 specific words
Best practice for managing updates w/in distrubted workbooks?
Radio Buttons - Values
Return Just the Unique Entries From a Range of Cells
Print Area
Re: Excel hyperlink loses its path on save (2)
cell selection code
Count yes against name
How to use debugger
Horizontal Data to Vertical Data
Pivot Table - Hide (blank)
"is not a valid Win32 application"
How do I stop entry in one cell if another cell is occupied??
How do I move and size a picture with a cell but keep the aspect r
How to make db file in excel 2007
Gratitude
Annoying Paste Bug (Excel 2003)
Ensuring Correct Vin Number is entered
Working with times as conditions in formulas
Sumproduct or VlookUp
Get value at end of a row
Excel Crashes on Start Up
Synchronize option button
Calculating date and placing the value in the right date range col
Formula to define non-contiguous range?
how to round figures?
Under data/Group&outline/group
Classic View
Formula for 20 minute meetings
Record Macro Toolbar
For..Next..Loop
re-numbering or sequence priorities formula
Default zoom
User Form Text Boxes - Copy format of text boxes
RE: Delete rows with multiple columns with 0 value
Delete rows with multiple columns with 0 value
default number of copies
vlookup for an unique Text and return its address?
Cells no longer linked after inserts
Import list
Allow Users To Edit Ranges - Excel 2003
Grouping.
shading based on change of values
Splitting Numbers into Columns.
Blank Cells
Format into Time.
Hyperlinks on Protected worksheet
Total Text Length of Adjacent Cells
Extract text on right of various length from cells
Date Values Changing Rows
Opening Excel 2003 files in 2007 Vista
Error when opening a 2007 template saved in 2003 format from a mac
Re: how do i remove "mark as final" on a spreadsheet?
Adding worksheets using sumproduct function gives error
Prefix
How do I find date a data file in Outlook has been created?
How do i remove "mark as final"
More on loading a CVS into an empty formatted XLS
Picking one cell will highlight four or five, Excel 2007
Conditional formating
Control ToolBox ComboBox
External Link Issue
Values in cells not showing
RE: Identify if the result contains a particular value
"Excel has stopped working" after updates
Anyone know what "[VSync]" appended to filename title means?
Re: I want to converte number in excel to text 100 to One hundred
Embedded chart not appearing correctly in PDF
Functions in the footer?
Automatically pulling specific data into a separate spreadsheet
Sumproduct Column B based on Column A
Show only rows with duplicate values in a column?
Trouble with Vlookup
Averaging Data
Extracting specific text from another cell.
Iserror - too many arguments
Data Validation using Unique Values
Excel 2007 - error saving file & error loading dll