Microsoft Excel Worksheet Functions

Help using two different values in a lookup table
Absolute reference when creating links to another workbook?
Stuck on a anlysis formula 2
Excel formula NEED HELP
HELP !! - stinkin' zeroes
autofilter
Excel, Data Generation from contents
Thanks Date Help
Macro/Formula percentage problem
Pivot Table
Pivot table
funcres.xla
filter
drop down lists
Pivot table chart problem
Lookup problem
VLOOKUP function problem
networkdays I think with formula
Conditional formatting problem
Partial string in IF statement possible??
Do You Need Visitors
Excel List Function
IF statement quandry
combining vlookup and hlookup
Macro/If Statement?????? HELP!
duplicate records, how to identify and count
Convert Kilo's to pounds and ounces
paint cells with highest numbers
One book, 5 sheets and 1 sheet for totals
NEED HELP: ADD-INs
Re: WHAT IFS
Re: WHAT IFS
Duplicate Rows
Top ten highest numbers!
convert kilos to STONES and pounds
Text to Columns
Add a Zero
Re: NEED HELP WITH VALUE INPUTS
=LEFT Function
Re: When I enter 0e001 the cell formt keeps on changing
Re: When I enter 0e001 the cell formt keeps on changing
Re: When I enter 0e001 the cell formt keeps on changing
Links showing #VALUE!
SUMIF(AND) FUNCTION
Excel 2003 - conditional formatting
Find the nearest Number
Comparing Ranges of Times
Converting HTML to Excel number
columns reversed on worksheet
losing cell format while saving in CSV type.
Querying Access DB via Excel?
Need to calcualte difference between 2 time fields
Need to calcualte secounds to the next 1/2 minute
Formula controlling format based on content of a cell
Division on a sliding scale
Adding text string to a number across worksheets
Need to determine if a call is Long Distance
Linking to a Chart Worksheet
combo boxes for each cell in column
Find and copy data
Growth Curves
calculate % of difference
Re: Including advanced criteria in DSUM formula
Merged cells separte when pasted too.
Sumif cell contains a certain value
Convert
Formula for comparison of Three Teams
Conditional Formatting
Formula Help
Embedded Word Document problems
SUMIF (Continued)
vlookup to return multiple lines
Drop down lists
use an address returned by CELL function in SUMPRODUCT
Re: Count Unique Entries per Month
=I2>=LARGE($I$2:$I$5,2) ... to be modified
Automatically Removing 3-D References
Formula not working, All "(" and ")" are ok
header/footer link to cell?
need to determine a text value of a field based upon a number
Need help getting information from a live range
Combining Worksheet information
Quarterly and YTD calculation
Creating a Chart based on Cell color
CountIf and AND
Default open sheet
Auto-Complete
Outlines
Page Break Preview
Sharing protected worksheets with outlining
Re: how do i hide field boxes in a pivot table?
Re: Fixed Assets Depreciation Projections on annual basis
"Today()"????
"Text Limit"
"Data Entry"
Separate phone number and address
Sorting problem
Autofilter ALL freezes Excel
Multiple worksheets on one file
Colouring on formulas
separating address from postcode
Unhiding Multiple Excel Sheets
function how to!
Conditional Sum
Formulas employing cells linked to a combo box drop list
Conditional Formula in Excel
Re: NEED HELP WITH FORMULAS/VLOOKUP
Re: Worsheet consolidation
Apostrophes and formatting numbers reading as text
Combining data from multiple fields into Pivot table
Want to fill down using exisiting data
Re: Sumif using multiple columns
Re: Sumif using multiple columns
Re: Sumif using multiple columns
Highlighting cells that exceed a specified value
tabs in combo boxes
Re: Inventory w/transaction log
Removing characters from cells
Cell formulas
How can i freeze 2 sets of panes?
Re: # hours in each month
Counting Unique Values
Excel - Increase a highlighted range by 5%
Re: Need help with time
Calculating Time
Re: Need help with time
Re: Worsheet consolidation
Re: Need help with time
morefunc help
Urgent Project, Please Help: Copying Formulas
Re: Check Boxes - only one can be checked
Re: Check Boxes - only one can be checked
Re: Count Unique Entries per Month
Entering formulas
Conversion
How to hide rows/columns that have zero values
Strikethrough Text
Re: Copying Formulas
Re: Copying Formulas
Excel problem
RE: MAX Function
RE: MAX Function
Max function with cell lookup
Button to Jump from Chart to Worksheet
Sum = value
Still Stuck!!
VLook Up Assistance
help with complex sumproduct, lookup formula
Copying a column
Multiple selections in a Drop Box
ISBLANK
mixed cell reference
Stupid question?
Automatically displaying a date
Compare numbers
DISPLAYING DATA SIDEWAYS
data consolidation
Using an address reurned by the the CELL("address") function
Is it possible
need help
Caculating Annual Percentage Rate
which function will work?
mulitply a $$$ by a quanity and sum up the whole row?
Bug in Excel 2003 Subtotal Function
Filter operation on Protected Worksheet
Sumproduct
INDIRECT.EXT function, PULL function
Average formula
Date field
Linking more than one cell with multiple cells in the same workbook
sorry forgot the attachment
Lost the plot..... Help.....Copying Answers from formula
Excel 2000 - Worksheet Probs
combining 3 columns (year, month, day) into one column
Being Stupid - Help needed with nested IF statements
Refreshing data in Excel from a SQL DB
Count Unique Values
Username
lookup problem in excel
Linking Workbooks (complicated)
Resetting Worksheet formulas
Re-sort a range dynamically
VLOOKUP & Data Validations Tool errors
Auto Opening a dated workbook
Need help with date function
Re: Need help filtering 2 columns of numbers
formula not working
COUNTIF
Re: Need help filtering 2 columns of numbers
Linking to Data from Multiple Workbooks
Sumproduct Issue
how to use the fill function (serial no)while we are in filtered field
cell addition and moving questions
Import data from multiple worksheets into one master
help with formulas
Sorting
Excel Converting Colums to rows
color tabs on excel worksheet
COUNTIF
Re: creating name table
Re: creating name table
Macro to call a macro
Re: Linking cells
Filter Intrigue
Re: sorry forgot the attachment
Match and Datevalue
Run Macro From Within an =IF statement
More Than 3 Conditions w/in Conditional Formats
return results based on multiple conditions
smart tags
IF AND DATABASE FUNCTIONS
Linking workbooks
Sumif & AND function
I have built a filter
Using VLOOKUP function
calculating number of hours
Counting Unique Values
on a filter, I have a column that contains Yes or Now
Returning cell references
Cell -find number of columns unitl next non-blank cell.
Totaling Instances
Re: Time Rounding
Re: Adding Time
Re: Time Rounding
Time Rounding
Time Rounding
Can I lock cells?
automatically advance to next cell without hitting enter or tab
Flip Col A to be Row 1
conditional formatting
sum with multiple criteria
SUM FOR GENDER = m
Argument seperators
Hyperlink problem
Applying conditional formatting only if checkbox is checked
Open.text macro fn syntax
Stupid Question...
COPY then PASTE SPECIAL>VALUE
OnDirty / Auto Complete
Enter Key Behavior
Summing columns based on a date range
Rank() function Across worksheets
Wildcards in formulas
Sheet protection and checkboxes
Wildcards in formulas
Time Problem
formula needed for macro
How to get a formula to ignore blank cells in an = to function, NOT averages
Missing Functions
A Commentary on a range of values
Extract Last and First Names
lookup
Need help writing formulas for following functions -
Countif & Array formula
Running total formula needed
Count Number of Cells Q
Looking for the expert....
two sided printing
income protection calculation table
"Save a Worksheet as File??"
fractions
Problem: Help requested
running day-of-week average
NETWORKDAYS and AUTOFILL
IF.........AND......THEN function?
Sequentially dated sheet names
Updating data
Separate Numeric and Text data
255 character limitation of indirect.ext and pull-function
Preceeding cell
Function to return text string
Formula issue
Insert Cell Name of a value that matches a MAX function
Learning FUNCTIONS
Color Cells on Find
Formula to subtract time
Check box print view
LIST unique values
KEEPING ROW TOGETHER
which function is use?
I want to convert
pivot tables and row totals
Count unique entries
Text conversions
networkdays
Oldest dates first
consolidate data
Converting Numbers to Text
Changing the cell numbers
IF Function
Converting minutes & seconds to total seconds
auto filter / sort
Find row number
Convert Times to Decimals
Undesired Auto Color Fill of Cells
formating problem with paste-link
excel function that gives the highest text entry
Text box in Chart/Sheet with Dates
to follow a particular cell format
Commission Structure
String function
Indian System
Protecting hidden columns
EXCEL Help Please
Macro Custom Buttons - How do I delete them
Setting LinkedCell of individual OptionButton
Calculating days between two dates and multiply them with different numbers
Need help trying to get cell value when condition is met
Making formulas invisible from formula bar
count unique values with criteria
Compare
Excel form creator
!REF problems
Delete Leading Apostrophes in text fields
HELP: how to reference across columns while copying down
Print Screen Issues with Dropdowns
If Function for Letters not Numbers
sum if last cell equals max row length
Headers and Footers
Sum Totals between 2 dates
Excel 98 and Mac OS 9.2.2 - shortcut keys not working
transposing 4 rows from 1 column to 4 columns w/o using a macro
Time in mm.ss over 1440??
Creating a Top N report in an Excel Spreadsheet
Stumped: Help please, simple
need for a function similar to "FIND"
Hiding rows
averaging linked cells
employee hour sheet
Graphs
Display rows based on criteria
lookup
Lookup Q
Please help, just installed excel 2003, my old files can not open.
Expanding Merged Cells
Re: "IF" Formula's that utilize a number range
Keep cell reference when insert row
Sumproduct
Calculate age
Like CELL(), but for text properties?
Report 1st of the month
Lookup Question
IF statements in Macros
Linking Text cell comments to cells on other sheets in same book.
time conversion
Display formula in worksheet
functions question
Can This Be Solved?
I want to be able to create a S/shee to tell me how many Male Dept Heads I have
Fill function
are some page setup options not available for grouped sheets?
3 If Statements Q
macro for multiple criteria
Formula problem
sorting
sorting
Find a value in the n-th column
Sort a Dynamic Range
colour of cells
Sort cells by colour?
finding linked cells
naming columns
dividing all cells in a column by a number
Link between worksheets
excel formula "or"
Counting Unique Values
Combining Average & Sumproduct.
remove asterisks?
Countif Help
*.mdb links
How do I create an "IF" within a drop box scenario
How to convert multiple lines in word to single cell in excel?
Looking up value in left column
Cell shading
Filter Select Columns Only
basic subtracting formula
Assign Macro function
display number of cells resulting from auto filter
Tab Delimited Text Errors
Blank values in Pivot table cells
Re: Number of characters
Excel functions and macros
Re: Number of characters
Re: Number of characters
negative number
Re: Number of characters
alert when negative number is in a cell?
"INTERSOLV" Licensing Error for Excel 2002
VLOOKUP the second match?
data transfer
Copy data from field on next worksheet
Remove partial data from a cell
Worksheet calculations for 1st, 2nd, 3rd... Mon-Sun of a month?
copying non-sequential cell references
Remove space
average rounding to 3 decimal places
Sybase ODBC Connection
"Today ()"worksheet function help
Forms
Formatting cells - anyway to do this?
Complex Formula or Possible VBA Challenge
Does Anyone Know How To...
I didn't get an answer on my earlier: *.mdb links question???
Can anyone suggest a good Excel Primer for the beginner?
Pivot Table Question
Comparing Date and Time
VLOOKUP function
Re: SUMPRODUCT confusion
Re: SUMPRODUCT confusion
add a range to this VB
Transposition for a whole sheet? problem with all vertical paste series
select dropdown or free text
Removing Spaces in text
"SETSTRING" Function in Lotus 123
Changing summary options in PivotTables
Military Time to normal Time
Remove Space
Entering data in one sheet and have it appear in second Sheet?
Possible to create a range string for a worksheet function?
Macro
Remove "," from txt
Complicated problem, hopeful answer?
Printing applied filters
Is this possible?
Hyperlinks
Average
Update Header on Sheet 3 to Last sheet
Sub totals in an expense worksheet
Filter / Titles Rows not printing
Re: Sub totals in an expense worksheet
Getting the average of n maximum grades in an unsorted list of grades
Changing Chart Objects in Code
Time Calculation
help with Function is it possible
Bracket negative numbers
Match and index question
Match and index question
Format
Format
can't figure this out...
unprotect outline feature: How?
Grandtotal of subtotals
How to use command buttons to link to worksheet?
Special need for a pivot table report
Problem with Office Excel
Separating a number with decimals
Formatting dates with different regional settings
Computed Cell Reference in an Array Formula
Excel Pagination Function
Move Data to Oracle
IF Function or Lookup or ???
Array Function - Problem
Unfreezing all panes in a workbook
Multiplying 2 columns
Find last cell in a range
Date and time as file name
Beep Command not beeping
excel miscalc?
vlookup returns #N/A but value exists
Macro
Re: Including rows in a calculation if they meet a criterion
Paste Subtotal's only into new sheet
Re: How do you Count the number of unique values in a list ?
Damn Lookup Problem Again
Conditional format - change cell colour according to the text within it
Same formula returns different results
Re: setting up basic calculations
macro to add rows and copy data into the rows
Re: Rolling 6 month totals
vlookup if value is within a range
Re: Quartile (percentile) algorythm
zip code - can't trim preceding space
Using Trend function from VB
Re: Time Calculation
Re: Time Calculation
Time Calculation
Re: Time Calculation
Conditional formatting question
entering fuctions for multipule fields at once
Unable to access "OPTIONS" from Tools Menu
"VLOOKUP??"
Sumproduct
RE: Inventory Aging
Adding new worksheets
IF function - comparing data from different sources
Finding month when value first <= 0
Adding Footers To A Worksheet
Rand Between
Converting positive values
help with macro and delete rows
re: Footer Character limit
Pivot Table / Unique Values
Function HELP!!!!
average formula
Formulas
How to protect cells
macro to add rows and copy and paste
Sorting Across Worksheets
I need a quicker formula
Re: the sum from one cell on a sheet1 minus a cell on sheet 2
Sumproduct..need a push in the right direction
Formula
I need a formula
unsorted names and unique id's
Separate Text - Formula
Sorting Across Worksheets
Open Close Columns
I need to subtract sheet 2 cell B6 minus sheet 1 B12, whats the formula
Hour and minute calculation
Separating Numbers from Text
complicated function... can anyone help?
need help with formula
Can't find a link to another workbook
SUMIF and a range of dates- ??
Result depending of the result of a function.
Creating a link from sheet1 to other sheets
Strikethrough Option
color coding a vendor
Link - Absolute Reference?
brainy stuff.
Replacing function with values
Need formula to display info across cells
User Defined Function
Think you know ODBC ?
Shifting Row to Columns, Is it possible?
How can I create an input mask in Excel?
sumif function
Need to Calculate Employee Ages
rounding a formula
Write excel sheet data to Oracle
excel formula problem with Ten column worksheet
Difference between two cell
AutoFilter, n filterlist elements in 1 cell
External links updation for files sent via mail
Numeric Digit Grouping in Excel 2002
Numeric Digit Grouping in Excel 2002
slow and large worksheet--no obvious reason
Match and index
Pivot Table Question
Inserting a row after every seven lines
Returning data in a list
Links
Advanced Filter Please clarify
creating formulas
macro to insert rows and copy and paste
Multiple calculations
Unable to access Options Menu
Worksheet Title Missing
Excxel links
Re: multiple criteria
using spellcheck while a worksheet is protected
sounds stupid, but I have a deletion problem
Changing Linked Data Source Nightmare
average formula
Opening a File
Look up and IF function
Subtotal Buttons Missing
IF Function, maybe
sheet reference in if statement
Custom number formats
Re: multiple criteria
Hours worked calculation
COUNTIF based on DATE
Add a column of numbers with text in each cell?
Positive to Negative
Several cells needing multiplied
sum field not changing
Excel XP Template for Project XP
converting pdf to excel
Macro - change link
VBA code with macros
Index/Match with IFNA and IF statements
Save As
Sharing an Excel Document between computers
sumproduct with multiple criteria
summing with an if statement
Adding 1 to field
COUNTIF
Average Problem
multi-lookup & multi-condition
Urgent - Time function question
Re: protecting worksheet from copying and pasting
Need a quick answer on this one........
Return last value in a range.
External data err
Adding up hours
sorting by a certain column
Re: I need to subtract cell B-6 sheet2 from cell B12 sheet1/ Excel 2003
Average of the last n values in a column
Validation using AND function
Array help and counting
Find the greatest number in different cells in different worksheets
standard devation
IF Statement...I think
Sorting Formulas
"IF" How to use the IF function
IF formulas
Date capabilities
Dynamic Moving Average
IF function?
Macro possible?
last business day of a month
stats for a set of numbers.
Formulas
How to use IF statement??
And If Statement Q
time function
auto filter
Repeating Macro operations
coping boxes
Event sub's left half executed
Largest number for team
finding & sorting unqiue names list
Scheduling classes for school
Conditional Format (text strings)
subtracting numbers to be inclusive
Date function
Combining Multiple Address Lists and Deleting Duplicates
goal seek help
if/index statement.
How can I do this?
Excel IF statement problem
Complex formula
Return blank cell if cell to be tested is blank
PLOT MINUTES USED PER DAY
Data Validation : Allow only "X" or blank
Vlookup left
a simple question....about string searching
need help with Excel code please
How do you stop LEN counting spaces within the text?
Select Earliest and Latest Dates froma Range of Data Q
Tab Color Dialog box in 2000
hidden macro
How to identify duplicate records and count them
Excel Formula
Create Database in Excell
Need simple macro
Picture behind cells
How To Find The Last DATE() Listed
Excel 2000, simple function question (I think)
VLookup
Convert decimal hours to hours:minutes
Validation issue.
Update all sheets in a workbook
Question 1
Apply Tax Rate to Net Profit on P&L
Question 2 HLookup
Autofit Row Height
"Turn off auto-update??"
Get Rid of Duplicate Cell?
Just a quickie
Combing TWO worksheets into ONE text file
How to return cell data as text in another cell
Excel is not copying my formulas correctly when I drag them down
line feed in cells
SUM Function
Validation, not working.
Excel Formula
Counting Cells
Links
Word text into Excel format
Count blank cells until a non-blank cell is reached
Custom date format
Vlookup value from fill colour only.
Splitting one cell into two
Please Help!
Auto-Filter Locking - Not able to use
Removing Numbers
running total
Please Help!
Autofilters not working
Formulas
cell reference change with insert row
Conditional Formatting
Formula to multiply time
Forms
linking worksheets
about INDEX function
ROWS Function
Re: want vlookup to be blank
Question for Debra Dalgleish / Reply to a Pivot Table Question
Re: want vlookup to be blank
Scan a table into Excel
Re: Desire blank field instead of "0"
Re: Desire blank field instead of "0"
Control program used to open hyperlink
Re: Midpoint Calculations
Re: Midpoint Calculations
Re: Midpoint Calculations
Re: Midpoint Calculations
Converting Time
Re: Midpoint Calculations
Excel
RE: Midpoint Calculations
time zone calculator
IF statement with strings
displaying descriptive stats on a chart
Another Time Math Question
Excel 2003 XML Abilities and Amazon.com
Calculate time counting up
Conditional Formatting to Check if the Sum of a Range of Cells is Less Then 20
Averages - Help
Sum If Meets Criteria
Average Help
Help with Cell references
Using Hlookup or Vlookup - HELP!!! :)
Macro - help
Deleted Macros - Still giving message that some exist
Excel 2002 column info question
Validation List
Fill a column with hex numbers
Required fields
XIRR vs. IRR
Referencing Empty Cells
Find Function
select page option and grouped sheets
Various Questions
Adding and Subtracting in checkbook program
Problems
could Macro work?
XML Manipulation with Excel
THANKS!!!!!!!!!!!!!!!!!!!!!!
stock quote add in feature
Links to other excel file - I can't find the cells with the links!
Indirect and Address Functions
ActiveSheet CodeName Property Problem
Add 1 to field in worksheets
I have trouble with this macro - help
data from two cells into one
HOW TO FIND MAX NO INCLUDING NEGAITIVE ABSOLUTE NO FROM A RANGE OF CELL
Sort Function with a Twist
Formulas not adding properly
Vlookup & Iserror to cope with blanks
How to find maximum number from range of positive & negative number?
Finding Max value for range of cells meeting a critera
Serch cells with external links
How to find Max from range of Positive and Negative Numbers?
FUNCTION NETWORKDAYS
Excel Search Function??
Removing Automated Hyperlinks (e-mail)
command button
Using SUMIF to exclude mulitple criteria
Using SUMIF to exclude mulitple criteria
follow upd question command button
Lookup function
Syntax Help
date conversion from mm/dd/yy to dd/mm/yy
Finding and Listing Dating from an Index Query
Dynamic Workseheets
read only folders