Microsoft Excel Misc

CountIf and Sum Help???
Styles in Excel
Compare data in two columns to find duplicates.
copy-paste from excel to powerpoint - grid lines
How can I import a PDF into Excel?
How to get Excel to auto sum after it has been saved with data.
data table problem
is there a "treemap" plug-in for excel (info week 09/05/05- pg 34
Conditional Sorting in Excel
How can i get an inventory list that adds and subtracts inventory
Formula
Return a value if criteria contained in cell
Formula Question
Convert MSWorks 2 SS to Mac Excel
shared environment
Is there a template in Word or Excel that compare career benifits
Create a formula
A reducing number by given dates
find formula between worksheets
Write to a New Spreadsheet
Saving file in the format "YYMM"
Financial modelling from Excel to Access
How to change drop down values based on another cell value?
Page Margins
Get excel to list values that occur within raw data
How do I merge multiple quicken reports into one workbook?
Sorting numbers, please help?
how do i create a reducing number that reduces at certain dates
Concatenating two formulas
I lost the cell view just below my toolbar.
connect a form to excel database
Text Cell Overflow
cannot access excel spreadsheet
Filter based value in multiple columns
Excel Not Updating
Setting page frame for a table of several hundred items
How do I automatically insert the latin tree names
copy values generated by conditional formula in one sheet to the other work sheet as values
how do i repeat paste
Run Time Error 9 (Subscript out of Range) for XLA file
TAB Settings in Excel
Streamlining a long IF=(AND formula ??
Naming a newly inserted sheet using VBA
right click on objects not working
Macro or VBA
TEXT CELLS OVER 40 CHARACTERS
TEXT CELLS OVER 40 CHARACTERS
stock management spreadsheet
grayscale conditional formatting of text
Moving worksheets into viewing area
Rogue Password on Properties and References
Way of making an object with a greater number be given a point....
Find and Replace help
complex criteria
Excel Showing a Calculation and a Value
Excel Slow to open Spread Sheet from Explorer
Shortcut key help
Excel workbook responds very slowly
How can I insert a row and have the existing formulas apply?
Combine excel sheets in layers
error on formula results
Dragging multiple refences
open workbook on same worksheet
Need help
VBA Training
How to sort just by month when cell says 05/14/1963
copying data to an adjacent cell
Wildcard In Condtional Formatting.
How can I insert a row and have the existing formulas apply?
Unknown Error
How can I insert a row and have the existing formulas apply?
Can I put 2+ rows from excel on a single label using mailmerge
How do I insert a row & have the existing formulas apply to new ce
Copy from multiple workbooks and display the original worksheet na
Count unique occurrences of name
Delete cell contents with input to adjacent cell
how to keep leading zeroes when saving in xls in csv format
The Excel Drawing menu Autoshapes stopped working.
How to handle multiple currencies with one spreadsheet
Zeroing out data but leaving formulas.
IF formula and whole numbers
LIMIT NUMBER OF CHAR IN A COMBINE CELL
excel floating digits error
height and width settings locked?
Can you display numbers as words in excel (eg. 10 as ten)?
Concatenate
Subtracting dates to get hours... but I want to skip weekends
Spreadsheet Applications & Copyright Issues
I give up, help, trying to print duplex but
Pivot table formats text data with 2 decimals
Opening a URL in a cell without a mouse click
emailed docs coming back in different format
Mistery digits on excel
Vlookup Easy Question
Formula Every 3 Line
Conditional Formating
If Year equals 1999 then multiply cell by x
Countnig Unique Invoice #'s in a Column
RE: Macro between Microsoft products??
Remove "read-only" from a worksheet
Formula to Autofill Info based on Other Data
Very Urgent VBA Procedure
unwanted page breaks
huge amount of text in merge cell - want undone!
Dynamic Named Range with blank cells
How do I insert the same extra digit to each cell in a column?
How do i get Excel to email me on a set date??
Changing the border of one cell s/n change the border of adjacent
View/Edit Excel in HTML
How do I make a line non-selectable?
View/Edit CSV/Excel in HTML
Excel Superscript
How to remove red strikethrough generated as an error?
How to put a SQL query in a single Excel cell?
How do I create a calendar with the months I need?
Getting contents of a cell when cell reference is in the sheet
Excel 2000 back up file
Combo Box List
excel open in new window
i need to make a pub quiz league fixture table
conditional formatting based on another cells formula result
Pivot Table % calculation
Sum by selecting each product
Colour references in formulas.
Split text and number
Conditional formatting in a data table
Circular reference error
Prevent wandering users
pivot table
error message when saving excel workbook
This even possible?
Removing Hyperlinks
Removing Duplicats
Can anyone recommend a good Forum/Message board for SQL users?
Re: Excel Error
maximum value in a list less than specified value
Auto Text in Excel?
Getting error "selection is too large" when copying data
Getting error "selection is too large" when copying data
Find within a file as a function
does item match any in column B
Change Connection of a Query
Tying an imported graphic to a cell
Sum Product Function Question
How do I set up raffle tickets to be numbered in Word
Prompt for Save when closing a file
Multiple IF formula
Macro to edit formula
runtime error 1004 method range of object '_global failed
Macro in Excel
Limiting physical length of text in a text box control
Cells Protection
HOW TO SELECT EVERY OTHER LINE IN A WORKBOOK AUTOMATICALLY
convert capitalized text to small text (with Capitalized names an
Protect / Unprotect with checkbox
Is there a faster way to switch between sheets?
How do I calculate the week day hours between 2 days
In Excel, Get todays date in a cell
Hyperlink Locates file regardless of it's location
Lookup, Index or Offset
Second MAX?
get rid of #N/A in a VLOOKUP
Setting a cell to not go below an X value, or above a Y value
A question of sorts
Excel Upgrade - Office XP
EXPAND CURRENT LIMIT OF 4,000 DIFFERENT CELL FORMATS
Sum Product Function- Blank Cells
how to automate invoice using excel database
Opening and file associations for Excel
I am looking for a Excel program that I can log my vehichles.
Recover overwritten file in Excel 2003
number format
Moving a line of data when information is entered in a specific cell.
I want to show lapsed time as a negative value
Inserting the file path in a cell
Conditional line/arrow
Formula help please
sharing problem?
Edit Menu
Sort data in Excel
Moving / Sharing excel files with queries
find last cell that has a value in row
input box
How can I format an cell in excell:10min50Sec 88hundreths of a Sec
Convert .csv files
Hoe to change text format .126 to number format 0.126
Printing 1 Form with differnt values ?
formula average
Multiple Workbook Data Capture Summary Sheet
command button
Target cell=range??
Display Last Saved Date Excel
Conditional formatting
picture 34 was inserted by excel?
When opening a file in Excel
Pivot table formats
dim trouble
Error using Excel add-in with INDIRECT.EXT function
I'm having problems printing on open.
about CSV
Change the Default Comment Format to NOT be bold
office web component error
Web Query - Submitting Data and Capturing Result
Can't figure out how to average
Circular Reference will not solve #VALUE! or #DIV/0!
Add email attachment to command button
how do I update links without being prompted in Excel?
how do I update links without being prompted in Excel?
Detecting version of Excel being used
inputbox question
Cond Format -- on set of columns, then one column
How import MSWorks spreadsheet to Excel
How do I create/filter a list of names without duplications
Creating a regular six pointed star.
Pivot Table Grand Totals - Hide Some, Not All
Finding the cell that is linked to a file
Where is the WORKBOOK template
how do i make a document lengthwise
Keeping Source Formatting with Paste Link and VLOOKUP
paste special
Is it possible to change the default number format in Excel?
Links
weird problem with LOOKUP function
Unlock File after crash
expanding the side margins in excel does not expand header
sorting data in columns
copy a formatted cell to another sheet as text without format
Excel 97 Options Tab Problem
Templates and Queries
printing limitation
Transferring Excel Data to Word Document
How do I stop Toolbar from automatically showing up?
Insert row if condition met
How do I print excel doc from an email
How do I print excel doc from an email
Urgent-Urgent VBA LOOP
pivot table
Open hidden sheets from a drop down list selection
Formatting and Grouping Columns
Adding cells from multiple Worksheets
Excel opening a "phantom" worksheet at random times
How do i find the first value every month
Transpoing: 2 columns=>1 row
Hide columns to all but one user?
Populating Cells from other Cells
How do I Remove a Split from my Comments in Excel 2003?
How do I Remove a Split from my Comments in Excel 2003?
Insert sheet, move to end, rename with cell data.
why is an apostrophe in front of text
Populate List / Combo Box
Auto Completing Fields but not changing later...
How do I remove the outline protection in Excel sheet?
function that returns a list to a single cell
How can excel open at the same cell where it was saved?
Variable in Range
Re: Auto Completing Fields but not changing later...
Link or embed into Word?
Summing Hours and Minutes
Help Error Run-time Error 424
Need to make a "range" in conditional formatting.
Run-Time Error 424
save spreadsheet as web page
Calculator
Need help cleaning up an email list in Excel
How do you get rid of 0 when data not in formula row yet?
Calculating Anniversary
Need a filter macro
Correlation - Which Analytical Function to Use
Urgent Help needed - I need to stop a process that is running forever in Excel
Conditional Formating for a cell based on another cell's value
Deleting Blank Cells Wholesale?
How do I create If then statements
Running Macros when on the LAN
Re: Urgent Help needed - I need to stop a process that is running forever in Excel
Want to join a hyperlink with an animated sound clip art
how do I make drop-down list select based on 1st letter entered?
Pull information from one worksheet to another
sorting data across multiple columns
Re: Urgent Help needed - I need to stop a process that is running forever in Excel
Classifying Data
Can I insert a file or folder names in Excel cells?
Pearson's Progress Bar
Changing negative numbers to zero
Insert Row macro not working
Can you tell me how to restore the 'template tab' I deleted?
calculation based on meeting two criteria
Buttons and macros?
How do I add the file last modified date into an Excel header?
Ex 2K Standard Toolbar won't stay hidden
How Change default "look in" location in EXCEL for Importing Exte.
I need a template for scoring tennis matches
Protecting Cells
Countif - Counting time in a Column
Iterating through string in a cell
Excel 2003
cannot open a file
Cannot insert extended ascii character
weeknumber
i think its broken
Remove Spacing In A Cell
Pivot Table: How can I organize data items in a row?
Hide collapsed group headers on print
excel 2000 downloadable template for amortizations. can't find
Automuliply
Crime Analyst needs help with co-ordinates
Help on how to use Offset in Excel
Help with sorting..
Importing multiple XML queries into Excel
linked values not displayed unless source file open
Check Box Formatting ??
i want to know company letters
Excel
updating tables automatically
How to convert phone area-code to state name and time zone
How to Show Records with No Data..........
how do I open older version of file
how do i copy drop down lists and paste them
Selected cells: item count versus summation
elseif formula
Logic command IF/OR
Macro -- repetitive tasks
Using macro to run repetitive tasks
How to add a description to an excel table
how to get data automatic moves to next column?
Protection or some other method used to person must "save as"
printing macro
Microsoft Query syntax
match colC to ColA, put row from ColB for 'answer'
Unable to close excel as a group from the task bar
how to add word to the front of every word in all rows automatica.
Leading Zeroes
excel opens under task bar
Conditional Number formatting?
USA DTAE settings !
DISPLAY ZERO WITH LINE THROUGH IT
Making a formula continuous
Auto Shape Menu
Why does the Data Analysis Toolbar Disappear
What does _v0000 mean on the name box?
Displays statements in Subcript or superscript using "If" formula
How can I create a formula for Salutation
How do I determine which numbers in a list equal a given sum?
CONDITIONAL FORMATING DATES
Input Box
Random Team Generation
Insert Rows Problem
Adding amounts based on a conditional date
Formatting and Macro Problem
New Excel data does not appear in linked Access table
Please help very urgent
import pdf into excel
Drop-down data not appearing in exported XML
Omniform 5 Help
Macro VB code help
Formatting Table within Excel
Pivot Table Question
Pop-Up Box
Select Multiple sheets
keyboard shortcut for moving between windows
counting TRUEs and FALSEs
Error 400
Re: Pop-Up Box
change the column labels from A to Name
On deletion of rows
how to add footers to ALL sheets in a workbook at once?
Place X in cell if criteria met`
'Date' problem
Dependant parts list -lookup
simplyfy and help on errors
Excel to Lotus
How do I make a picture stay inside a cell?
How do I print multiple files from windows explorer?
excel to html looses button and macro, why?
Is there an easy way to filter duplicate rows of data in excel?
what is the sign to keep the number the same in the formula
Page #s and bottom corner dates have disappeared in printing.
Countif in two columns and in different cells
Hiding a workbook
Cell dependent on another
why do changes only save locally on networked excel file?
hard coding a cell
Control Box - Please help !
how do i create tickmarks
Email Spreadsheet
Negative Results
2 Columns - Show extra items in Column B
Benefits many people - Question
hyperlink to word
Re: macro's problem
Reference Problem w/ inserting rows
Re: filtering and macros
Automultiply
Re: macro's problem
excel contact list
Adding message window
Calculating Total Number of Minutes in a Clock Setting
summing formula help
How to obtain Averages from a list of multiple items?
Hyperlink Function Problem
Calculating Age of person on admission date
How can I change the title by a check box?
looking for template to track travel plans for 5 people
display contents of cell
Pointer position on opening
Add a character to each row in a column
Error handling in this code
How do I paste into 'consecutive' cells?
Pivot Table
Linking to Visual Basic for Applications Help Files
Web Query
Opening an excel index sheet by default
no duplicate numbers
excel to access problem
logic test
if test using true/false or yes/no
How do I make a spreadsheet interactive on a website?
count if in two ranges
I cant make entries in my spreadsheet
Drop down lists
Drop down lists - thanks (and one more query)
an Excel question
Notification on entering the same data twice
Generate absolute hyperlinks to cells
Print conditional worksheets
Unlock VBA Project
Insert Rows between the existing rows
lookup certain formatting
Why doesn't this work !!
How to print multiple columns on same page
what is 11" X 17" paper size called in excel page setup?
how to create a "sub worksheet"
How do you turn off a print area for a page? (no print area)
can excel check one column against another
Please include fonts from previous versions ('98) in new versions
compare two lists
Adding Columns
Can I copy data from only the visible rows in Excel?
Find & Replace within Unlocked Cells in a Protected Worksheet
how do I delete numbers without deleting formulas
Time Please !
my printer ejects a blank sheet prior to printing with EXCEL
VB error
Runtime error
keyboard shortcut for sum
Please help with txt file
calculator errors
advance filter excluding record
7 days of the week
how can i make grafs for role call?
I know Autosum. Is there an "automultiply" shortcut?
Draw line between two points using data on the spreedsheet
How to copy cells horizontally to cells out of sequence
Timesheets
Object vs Picture Handling in Different Versions of Excel
Allowing data in specific forms
file/sendto/mailrecipient failure
Auto Shift
csv manipulation question
cross referenceing data in excel
Macro
Data Val list Excel 97 fire macro
Anybody have a good example of a project punchlist in Excel?
increments
how/can do i do a proportional circle?
Can I add more columns to a spread sheet or is limit 256 columns
How do I convert my swedish version of office 2003 into an English
Time question
How do I find the fat content for certain foods
Access a excel file through FTP without write protection
default manual calculation instead of auto in options excel 2003
Data Validation - Do not allow the letter "O"
compare time
Does anyone know how to make a colymn graph where y axis is colors
email print area
personal.xls won't open when I start Excel
FILTER: show/don't show selection with tickboxes
How do I reference pictures in a worksheet?
how can I import excel data to word document
sorting (alphabetizing) while keeping data in tact.
Opening Excel Files
Grouping columns
WHERE DO I FIND EXCEL TEMPLETE AMORTIZATION, BIWEEKLY AND EXTRAPA
Window View inverted
What might cause a small excel worksheet to be over 2MB?
question for excel how to have linked sum in column?
Insert Row-First time user
Template design and consolidation
Are there template footers for "Filename and Path" in Excel. How?
excel cell comments
Saving Excel workbook in SQL server using c#
copy and paste with offset
sheet
Formula: If 2 values (in a range of six) are >3 then TRUE, FALSE
retrieving of overwrite excel file?
opening non microsoft program from excel
how can I drag formulas with other cell references
Percentage calculation on text columns
How do i set up a range of numbers which prompts at a particular n
Automatically insert page break every 6 rows in excel doc
filter companies that does not perform a year
Update pivottables
how do I put a border around headers?
How do you find info in a workbook?
date calculations
Auto clear when qualification is met
input masks and validation
Why does shared workbooks uncheck users Windows in Taskbar option
How do I create a new toolbar with different tickmark buttoms?
Adding 7 highest numbers
Spreadsheet Disappeared
HOW TO JUMP TO THE LAST CELL IN A ROW?
Split the words
How do I create a formula to add 10 workdays to a specified date .
Refrencing a variable cell in a formula
How do I open a Microsoft Works 95 Spreadsheet with Excel?
Corruption problems in Word?
McGimpsey's Disappearing Pictures
Conditional Formatting for Dummies
Unlock VBA project
Adding Rows
Print withoutshowing a comand button
reference is wrong
Sumif() help
Can custom headers be linked to a cell in the worksheet?
Name Format
SumIF
exclude cells with certain criteria
Averaging function is pulling back a zero in Excel
Inserting a picture
Ouput File Creation Date
I am looking for a company that does excel "consulting"
Re: Inserting a picture
Font Colors not reflected on printouts
Macro Security
Is it possible to make comments font larger by default?
Question about creating a template
VB evaluate a value in a table's column and display msgbox
Workbook Defaults to Printing 33 Copies
Worksheet Change Event
validation
Pivot Table Code
Excel row highlighter
how do I remove an email heading from an excel worksheet
Formula Result
Find and Update Macro
proper
Pivot Table VBA code to move a row
Chart title text linked from a cell? Possible?
Change general format to US date format
EXCEL saving to A: drive
Sort as "reference column"
consecutive numbering
Cell flashing
Conditional Formatting
Access an excel file through FTP without write protection
Range in VBA
Tracking employee time and jobs worked on daily.
unwanted csv date conversion
ideas for Bid Forms for Office and Business Cleaning?
Selecting multiple filters in a pivot table
Combine rows
Date functions
How do I copy text formatting using a formula?
Rounding Sums Format
Blank cell if no data
In Excel, how can print columns of data?
Border Formatting Disappearing when data entered into cell
Excel Problem
Compile error for MsgBox copied from Microsoft training example?
Office XP SP3 interfering w/ Excel
How do I open a Quattro Pro ".qpw" file with MS Excel 2003?
Text decides suddnly not to wrap
Help with collecting data from a spreadsheet
Re: Help with collecting data from a spreadsheet
Check box
FORMULA PRODUCES WRONG RESULT
Excel List Sorting Problem (Descending)
number format
Can't one excel file on network drive?
Pivottable : repeat break value
How can I copy a list from word into a single cell in excel
Data in narrow columns truncated when saving as DBF
look for one total from a list of numbers
how do i change the currency on my worksheet
Excel - Matching data
excel running slow when saving
Using F9 Financial Report Program
Trust access to visual basic project in XP systems
worksheet size in bytes
can I use x in one cell and give it a value of 2 in another?
Hierarchical Worksheet Tabs??? New Excel feature?
paste is gone, please help quick
Insert Row and Maintain Merged Cells
I am looking for excel return on investment templates. Does any.
ROI Templates
Looking up data and images!
column width
Formula to transfer text from merged cells to single cell?
customize toolbar won't save
close button does not close
Stop asking to save changes
the use of e in Excel
I need to add a dash five characters from the first in a cell
Format Cells Custom Forumula?
how do i figure percent
How can I transform several rows into 1 column in excel?
Calculating Time difference based on a condition
Help - Access menus options locked
Looking to automatically "unhide" rows in excel using hyperlinks
Consolidate
How do I copy a cell + it's formula from one workbook to another?
How do I increase font size in a drop-down list in Excel?
Select rows and sort based on type
Problem with pivot table
Insert Row by a defined Number
Matching up data from multiple documents
Volume in horizontal round tank...
Why did my Excel file suddenly balloon in size?
h:mm to decimal value
Cells become unlocked and visible using a check box
Same action in different worksheets
Filling out list based on other lists
Excel - give users option to keep info in clipboard after pasting
Data Access Pages - Excel 2003
formula for Greater of C or D X E
Dynamic Named Ranges
MsgBox compile error in Excell
YYYY format displaying wrong date
cursor tracks / highlights recalculating cell?
stop macro from flashing sheets
How do I make a Header stop printing on page 1 only?
Excel2003 C\Program Files\Travel Dictionary Trueterm V5.xla not fo
Help please!!!!!!!
sort by date
automaticly copy data from one worksheet to another
changing column headings
Code to save info to another column?
Formula help
Compare Two Worksheets
Max sheets in a workbook or max # of calculated cells
Excel 2002 Unhide Columns Shortcut??
Range Blank
I NEED GRADING TRACTOR TO SHOW ON MY SHEET BUT HOLDS VALUE OF $80
How do I get a calendar pull down list in Excel?
select and delete all blank rows
Why is my row truncated in a pivot table?
Autofit Row height or Column Width does not work
How do I copy a formula with relative ref. keeping the same ref.?
Grouping Sheets
duplicate numbers
Filtering for multiple sheets
Password protection lost
Formula or Macro needed?
How do I highlight a word or sentence within Excel?
updating pivot table
Need Formula to detect duplicate invoices
Formula Help!
Auto Recover is happening Twice
Using Variables in Links
Volume in horizontal round tanks???
Macro for sheet delete, very easy
Any free excel downloads so I can edit my files, not view only?
Combining multiple columns of text
Excel 2000 too light
IF THEN FORMULA
Combo Box
project calendar
Lock just formatting?
auto create a file
sum column with 2 if criteria
I want to merge two workbooks but the option is greyed out. Why?
How to combine 2 cells' text into 1 cell
selecting data from a list box
Excel 2003 not recognizing whole dollar amounts, formats amt as ce
Pivot Table - Unhiding Fields
Max / IF questions
highlite in excel
Macro to compare two columns of data
Macro to compare two columns of data
delete cell that doesn't contain a specific word
Synchronizing Excel documents?
Column sorting incorrectly
custom formatting cells in excel
How do I make excel start with 0 instead of 1 for my x values?
VBA code to Add data to exsiting worksheet
Cant visible autoshapes(Circles, Rect) in sheet and also in print
Protecting Formulas from a range from being viewed
Changes to a VBA code
continents
world countries
excel Problems
Why does macros assigned to a toolbar lose its link when saved as
turn off auto fill options box Excel 2003
onkey method
vlookup
If / Then Question
Wildcard Usage: I absolutely need this to count?/sum? two or more criteri
Hyperlink Screen Tips not cross platform
vlookup
Getting rid of #VALUE!
calculate from sheet 1 to sheet 2
Removing Non-Numeric Characters
Freezing panes
Retrieving formulae
Excel cannot access..
Excel cannot access
Access Links
Vlookup from lists
get xml option in data menu
Sorting
Close a Folder
autoupdating Excel
runtime error 1004
Setting a pie chart segment to No Fill
How can I view all of my tabs in one screen? Can I layer them?
Wrap Text
*.txt separeted with blank character
Too many different cell format
Hyperlinking to Excel 2000 with a linked spreadsheet
RE: Refusal to save
Change color of a cell if another cell has text in it
Choosing a formula to used based on a codition fulfilled
refresh of pivot table clears fields (column headers)
Pivot Table Page fields
need help creating a formula
create a formula for price * discount* tax =final price
INT and MOD
Pivot Tables
Help with SUMPRODUCT
Attaching a worksheet to an e-mail
Excel Queries using Access data
How do i set up a mail log in excel?
Lost customized toolbars & recalc
adding a number to every change in value
Formula for adding totals from separate worksheets
full UNC path in footer
compare results
can excel report scientific values rather than absolute numbers?
Drop down menu with emp name then autopopulate with supervisor...
Format for credit card numbers
adding a number to variables
runtime error 1004
Formula that only adds numbers that meet specific criteria
convert works 4.5 spreadsheet to Excel 2002 (Office xp)
How to import data from a password protected Access DB into Excel.
Multiplication problem- Please Help!
can i freeze conditional formating to copy to another worksheet
excel tells me that outlook is not my default email
Delete Printer Bubble
Delete record(s) in other cells based on value of one cell.