Microsoft Excel Worksheet Functions

How do you round to the LEFT of the decimal place?
Re: How do you round to the LEFT of the decimal place?
Copying Cells
Elapsed Time Formula Help & Setup ...
Sorting & Page Breaks
VBA FORMAT(date,"YYYYMMDD") not working in Excel 2003 but works i.
excel customized template
Re: excel customized template
Format merged cells to receive JPEG
Re: VBA FORMAT(date,"YYYYMMDD") not working in Excel 2003 but works i.
How do you add drop down options to cells?
Re: Format merged cells to receive JPEG
SUBTOTAL BY DATE
Linking Data into Cells
Duplicating data into blank fields
Random Number to Second Column
auto sort asc/desc
Format merged cells to receive JPEG
Linking Data into Cells
Data lists and ignoring blank entries
Database Functions
auto sort
How to find duplicate entries.
Re: How do you round to the LEFT of the decimal place?
How to find duplicate entries.
Linking Data into Cells
Re: SUBTOTAL BY DATE
quick change from lower case to capital letters
Header/Footer
SUMIF function for multiple worksheets
Re: quick change from lower case to capital letters
Wrong Number Results
Re: Formulas with varying through ranges
Broadcast email from database
excel
How can I import data directly into excel from AS400?
to find dbq path for sql request
Copy the URL of the Hyperlink
How to find duplicate entries.
Interest rate calculation
Do not have letters on columns
Re: Do not have letters on columns
Re: CODE function problem
Problem with a logic/date formula
Insert a pull down menu
contiguous cells
Too many formats
CountIf Statements
date differences based on 365 days
Cannot Format Cells
Inventory tracking in Excel
Re: Problem with a logic/date formula
looking up dilemma
calculate age
Re: How can I import data directly into excel from AS400?
mid/find functions
combo box
Re: calculate age
Re: Problem with a logic/date formula
How to use the value of a cell in its displayed format?
combination of numbers
Simple Interest with irregular expenditures, irregular reimbursements at irregular intervals
VLOOKUP - CHANGING FONT COLOR WHEN CRITERA CHANGES
auto sort for excel
Re: auto sort asc/desc
Re: Insert a pull down menu
Question: Automatically Filling Cells by Identifying Row
Re: SUBTOTAL BY DATE
Looking for a scheduler for truck & shovel mining operation.
countif, sumif
I need the formula to change the background color in one cell bas.
Total unique with other criteria help!
"Split" is missing???
Help with nested functions / differing formulas based on number size
dating
How do I make a list for songs
Irritating Array Formula
SUBTOTALS in excel2003 differs from excel2000
Bullet points
How do I return last cell from a row of data?
Countif for a range of values
problems with "date" formulas...
Excel Identifier
worksheet
Excel timesheet
IRR Formula
Packaging requirements (how many Carton/pallets)
Extracting Values Common To Two and On One List And Not Another
Need Help! Conditional Summing
COUNT functions
Please help: Trying to count using criteria from two columns.
converting to text
combine HLookup & VLookup functions?
1
Edtae functions
Pivot Table Expert
Re: combine HLookup & VLookup functions?
Re: combine HLookup & VLookup functions?
combobox
turning zero into a blank
Multiple formulas based on 1 answer.
graying out specific cells when data entered in another
Pivot Table option, display as data list, repeating items down
Need to compute maturity date's for certificate of deposit?
Re: Need to compute maturity date's for certificate of deposit?
Need help with formula
FORMULA TO VALUE IN CELL
Re: Pivot Table option, display as data list, repeating items down
Formula Question
Interest rate calculation
Dataform problem
Worksheet function - Language Conversion
column scrolling
list boxes
SUMMING A CELL ACROSS MULTIPLE PAGES OF 1 WORKBOOK
limiting decimal points in a fomula result
Cash verification
Remove time from cell
Vlookup
Formula
Link with word
Data lookup
Vlookup
code to verify email address in cell
Re: FORMULA TO VALUE IN CELL
Default cell format
More than one logical_test in a conditional formula?
Data lookup
updating linked cell from Sharepoint
How do I work with circular references in a workbook
VLOOKUP return incorrect values
macro
Why the error message
Work sheet name Reference
Never mind previous post
I'd love you if you could solve this macro challenge!
macro
Open EXCEL worksheet to one specific location
How can I show only the horizontal grid lines in Excel?
RE: More than one logical_test in a conditional formula?
VLOOKUP return incorrect values
RE: Vlookup
How can I show only the horizontal grid lines in Excel?
Re: Need help with formula
VLOOKUP return incorrect values
How do I set tabbing order in Excel 2002 spreadsheet?
Installing Add_Ins without Office CD
functions Sumproduct, Index, Match - What to understand
Re: Open EXCEL worksheet to one specific location
checking radio buttons using VBA
I need an excel function that will give me the "mode" of text val.
RE: Open EXCEL worksheet to one specific location
How do I convert decimal numbers to hexidecimal numbers in Excel?
Re: How do I convert decimal numbers to hexidecimal numbers in Excel?
strip last 4 characters in a text field
Re: How do I convert decimal numbers to hexidecimal numbers in Excel?
Combining 2 VLOOKUP Formulas
spreadsheet macro
Re: strip last 4 characters in a text field
How do I calculate the first day of the next month following a ce.
Re: How do I calculate the first day of the next month following a ce.
Inventory sheets
Re: How do I calculate the first day of the next month following a ce.
how do i add up hours in a column
Re: Need help summing sheets based on a variable
Re: Vlookup
RE: How do I work with circular references in a workbook
radio button VBA help
How do I create a database?
showing results from more than one cell
Search workbook
Conditional Format
Creating pivot table with multiple ranges in excel
count formula
Date Calculation Problem
"weighted" average function ?
count cells in a range with multiple conditions
Date Calculation Problem
Subtotal weekly data
Dates prior to 1900
Combining Sum and Counif
Is this even possible?
Any Root of a given Number
Help with nested functions / differing formulas based on number size
SUMIF Problem
Re: SUMIF Problem
Difference between numbers
If Formulas
Can you do Box Plots on Micorsoft Excel?
Calculating from mutual share prices the correlation coeffiient of returns
SUMIF Problem
Rename a Workbook??
Linking Information
Linking Information
Dependants
cell("prefix",reference) returns wrong results when in array formula
Smart Tags
Save As macro
How do I seperate the last word from a cell?
DAYS360 Function Problem
Solving a puzzle using "Solver"? Can already do by Iteration & functions.
Excel Functions
Return 24:00 when amount of hours worked equals 24:00
Multiple Criteria Lookup
Multiple Criteria Lookup
Updating QtyReceived from other file
Excel Formulas
Data verification and notification
AutoFiter Pull Down List
Difference between numbers
Macro Help
Difference between numbers
Automatically copy formula
Pivot tables, external data sources and ODBC links
Autofilter:How to determine if the func returned no matches
cell("prefix",reference) returns wrong results when in array formula
computing formula according to criteria
dates missing
Anyone know how to Bestfit a spreadsheet?
Opening .csv document in text to columns
keeping cell fill colour when sorting
automatic invoice number increased everytime template is used
Function for range containing text?
Using MATCH with condition
When making a worksheet...
can excel schedule a six day work week?
can i get excel to explain a formular
Help with Array Function
How do I name a defined print area of different sections of a wor.
Run Macro
Macro Fill Down - filling too much of the column
Re: How do I name a defined print area of different sections of a wor.
Help
Macros and choices of shortcut keys
combination of numbers
if statements and 3 conditions to find duplicates
Code hanging on one line every other time it's run??
Help with Array Function
DATEDIF
How to keep track of Money for my students fundrasings?
add ISNA function to working INDEX/MATCH formula
Re: Duplicate enties
Calculating percentages
if statements and 3 conditions to find duplicates
Re: How do I name a defined print area of different sections of a wor.
Edit / Compute over a large range...
Calculate total hours
Assigning a name a number
Drop down List Boxes
Count with two Statements
Total for negative amount
Sample of Pivot Chart in VB.NET
How do I apply the formula =PROPER(text) to existing text in works
THANKS (FINANCIAL FUNCTIONS PART II)
bullets and indenting text with a cell in XL
lists
If formula
counting how many times a given letter appears in a tekst string in a cell
counting multiple criteria
Lookup issues
Finding the first cell with a value and then reporting the cell ab
Help with Array Function
Time values
How can I disable the Refresh button ?
Page grouping
six day loop
sum two criteria
read only files
How to ignore blank cells in a summary worksheet
Sum values with #DIV/0
Vlookup for part Lookup_value
Combobox font
Time question
VLOOKUP - location of found value?
Future Value of Investment
cell("prefix",reference) returns wrong results when in array formula
Help with Array Function
Concatenate Opposite?
getting wrong results with my VLOOKUP usage
Re: getting wrong results with my VLOOKUP usage
Macro to open Spreadsheet
Show Formula of a cell
Re: getting wrong results with my VLOOKUP usage
Re: Show Formula of a cell
Hyperlink Removal
Removing multiple hyperlinks
Removing multiple hyperlinks
radio button help
Help with sumprodct
Rounding off totals
Help with SUMIF and two columns
Opening spreadsheets in separate window
Round multiple cells at one time?
Round multiple cells at one time?
Help with SUMIF and two columns
SUMPRODUCT changed...
Rounding off totals
Re: SUMPRODUCT changed...
Macro Command
Sumif???
How can figure out the gap between different periods for the same
Cell
Macros
Sum of IF Results
Re: How can figure out the gap between different periods for the same
Re: Macro Command
Re: Show Formula of a cell
How do I make diagonal Column Headings
Sumif???
Dropdown windows to select products within excel?
RE: More than one logical_test in a conditional formula?
RE: More than one logical_test in a conditional formula?
Averaging specific catagories in a list
Invoice template
PivotTable in Macro
Data conversion
use a cell containing the name of a sheet as a sheet name in ...
Re: use a cell containing the name of a sheet as a sheet name in ...
How do I remove duplications.
Balloon Feedback
Adding rows and updating funtions
Re: Balloon Feedback
VBA with radio button help (please...)
Excell functions on Palm OS
Paper Size
Lisa needs a formula please.
How do I add the negative format of ( ) to cell formatting in exc.
dividing time
Re: Lisa needs a formula please.
How do I add the negative format of ( ) to cell formatting in exc.
Re: How do I add the negative format of ( ) to cell formatting in exc.
counting multiple criteria
Help needed arranging data for a Pivot table
Removing ALL duplicate entries
link access to excel
INPUT MINUTES, SECONDS AND MILLISECONDS
selecting cell
RE: Lisa needs a formula please.
Re: INPUT MINUTES, SECONDS AND MILLISECONDS
formulas
How do I create a database gathering info from a form built withi.
How do you get excel to return blank?
Re: How do you get excel to return blank?
Re: How do you get excel to return blank?
Return all cells in the same row as a cell with value 0
enhance vlookup to not return #n/a
how do I add a reset button ?
how many cells sum to X?
Re: enhance vlookup to not return #n/a
Growth Worksheet Function on Excel 2003
auto filter with search
If function
How do I create a formula which displays past project dates based.
Hyperlinks Changed in Recovered document
Formula
How do I add the negative format of ( ) to cell formatting in exc.
need array of true/false if text exists
Graphing Respond ASAP
Re: How do I add the negative format of ( ) to cell formatting in exc.
Re: enhance vlookup to not return #n/a
Functions accross files
Paste to Visible Cells
Searching a list in reverse order
Re: How do I add the negative format of ( ) to cell formatting in exc.
Re: how do I add a reset button ?
Is it possible to do a "virtual"/simplified shared worksheet?
Averaging
drawing lines dont show up only points in exel
Offset function trouble
Count with multiple condition
copy formula vertical and paste horizontal
creating a list with criteria
Ability to change the Excel comment indicator color
Web Query question
Averaging
Strange currency symbols when importing .csv
Countif
How to use Function IF
How to hide columns in grouped worksheets that works in a macro
Count
Prevent Macro to run Macro on Worksheet.Change
Download sql.request
Countif
Changing Excel 2003 Column Headings
IF with #DIV/0!
on some printout sheets my print is very small and faint
Formula Help IF?
WEEKNUM Question
IF with #DIV/0!
Linking workbook to powerpoint pictures
Trying to link TEXT (not figures) between two Excel worksheets
Formula Help IF?
Re: Linking Secondary Workbooks to Main Workbook via Product Type
ADD 1 TO CELL UPON PRINT
Re: Linking Secondary Workbooks to Main Workbook via Product Type
Processing exported CHOICE field from SharePoint List
make a long formula short
auto filter data from shee1 to sheet2
Refreshing the worksheet
Map
Re: WEEKNUM Question
automatically changing the format of a cell?
Add to formula
Comparing Values with If Statement
How do I count cells containing a criteria in a filtered list
Re: How do I count cells containing a criteria in a filtered list
Help with a IF formula
how to change cell color as result of formula answer
Using cell info to reference worksheet
Help with a IF formula
converting time to decimal
how to change cell color as result of formula answer
cumulative or running total
Returning a word from a list
Office 2003 is excellent., escpecially the help in Excel is fanta.
Re: Office 2003 is excellent., escpecially the help in Excel is fanta.
a function required
Indirect help
Re: Indirect help
Running Total without Updating too Many Cells
de-celling hours and minutes
change fill or font colors
Inserting Word Document into Excel file - missing pages
Using cell info to reference worksheet
Help With Formula
counting cell entries
Re: change fill or font colors
Formatting
Help with IF not working
chart help
Removing Text from numer field
If Statements - Commission Plan
Running Total without Updating too Many Cells
Please help me with "IF" cell formula
Re: Help with IF not working
Auto Populate
RE: Formatting
import question
Formatting
Help With Formula
Re: Please help me with "IF" cell formula
countif question
de-celling hours and minutes
The sum feature in Excel defaults to a certain number of cells, h.
Pasting second page
Formula confusion
Re: Please help me with "IF" cell formula
Re: The sum feature in Excel defaults to a certain number of cells, h.
date reminders: =IF(K5<=TODAY(), A5, " ")
unlocking cells using VBA in protected sheet
Running Total without Updating too Many Cells
Searching for a specific word in a table and counting the occurences.
Hyperlink
Add only the cells after a particular number in the previous cell in the same column
Searching for duplicates
Header line sorts with the data
SUMPRODUCT Multiple criteria in one column?
Need Formula Assistance
Re: Please help me with "IF" cell formula
Re: The sum feature in Excel defaults to a certain number of cells, h.
Display a column label reference
Re: Display a column label reference
Drop down menu in cell.
Re: Searching for duplicates
Re: counting cell entries
SUMIF with criteria a date range
Vlookup size limitations
Sheet 1, if cell g2 (which is a name) matches
How do I extend the columns without losing the formula?
Troubleshooting: copy numbers from *.pdf to *.xls
Referencing Own Cell in =IF
log all changes
Referencing Own Cell in =IF
Pivot Tables
=D3-(D3*B#) in which the # is the Row number that the cell is in
Re: Referencing Own Cell in =IF
delete Forms toolbar controls
Help needed =IF(.... Function
=D3-(D3*B#) in which the # is the Row number that the cell is in
=D3-(D3*B#) in which the # is the Row number that the cell is in
Freeze Panes printing problem.
=D3-(D3*B#) in which the # is the Row number that the cell is in
=D3-(D3*B#) in which the # is the Row number that the cell is in
linking cell ranges
=D3-(D3*B#) in which the # is the Row number that the cell is in
transpose function - hide rows in between can work?
Calculate new price with conditions
Converting numbers in figures to words
Calculate new price with conditions
Error when Subtotal function inc #N/A
Autofilter stops working
RE: Pasting second page
Can you add up hours and minutes greater than 24 hours?
Excel work sheet
Nested IF Functions
Help With a date formula
Search, Calculate and Display
Merged Cells in filters
Function help needed
array formula
automatically changing the format of a cell?
Function to link workbooks problem
how to break security password ?
Searching for a specific word in a table and counting the occurences.
Re: how do I add a reset button ?
Re: Invoice template
Using (H/V)LOOKUP to assign value based off position in a range...
truncating formulas that point to several worksheets to a few
FAO - Bernie Deitrick
Is there a way to solve for loan term if you know the payment?
Set the length of a number
Domenic, where are you?
Re: Is there a way to solve for loan term if you know the payment?
#VALUE appears in Excel file with links using "No Update"
date + 23 days
Stupid formatting
Problem with Formula and Formatting (General;*. @)
Can excel 2002 pad left?
Subtotal and Countif
Check Boxes
Counting characters within a cell
Password protecting worksheets
Re: Can excel 2002 pad left?
Re: Counting characters within a cell
Re: Can excel 2002 pad left?
Re: Stupid formatting
Formula
Sorting Groups
COUNTIF for text and strings
Re: Formatting values in Excel
Re: Formatting values in Excel
Re: truncating formulas that point to several worksheets to a few
Re: Formatting values in Excel
Re: Is there a way to solve for loan term if you know the payment?
Return the cell location of a value
Re: Sorting Groups
In Excel,how do I display my title cells so that as I scroll down.
Value of last non-blank cell in a column
Re: In Excel,how do I display my title cells so that as I scroll down.
Changing Cell References
In Excel,how do I display my title cells so that as I scroll down.
lookup date
How do I retain row numbers when doing a filter?
Re: How do I retain row numbers when doing a filter?
RE: How do I retain row numbers when doing a filter?
Re: How do I retain row numbers when doing a filter?
sorting blocks of data?
RE: sorting blocks of data?
lookup date
Random Sample
Sorting Groups
Saving formatting when pulling data from an external source
My formulas keep disappearing!
Sumproduct or Sum If??
COUNTIF function
trouble using dmax function
Sumif
trouble using dmax function
Can someone help me to understand how this formula works? =IF(E3.
importing multiple files
mailing labels
To sum according to cells color
Get "Error 1327" message when trying to run setup.
Can someone help me to understand how this formula works? =IF(E3.
Add only the cells after a particular number in the previous cell in the same column
sumproduct formula error
Future date in cell to change color on that date
Add only the cells after a particular number in the previous cell in the same column
Auto Filter "issues"
Re: mailing labels
Excel Auto-Filter problems
Excel macro
xl 2003 - Analysis ToolPak question
need formula to calcultate sports times
Formatting numbers in Pivot Table
Help with Formula
Calculate new price with conditions
Auto-Filter Stops Displaying # of Sorted Records in Bottom Info Bar
Excel macro
Re: Excel macro
Searching for duplicates (#2)
Excel macro
Excel macro
Excel: auto-calculate a date 2 weeks after an initial date
Conditional Linking of worksheets
Calculate new price with conditions
IF statements
Re: Excel: auto-calculate a date 2 weeks after an initial date
RE: sumproduct formula error
Pivot Tables
Re: Conditional Linking of worksheets
Re: Excel: auto-calculate a date 2 weeks after an initial date
Re: need formula to calcultate sports times
Sort a table using formulas
Re: Future date in cell to change color on that date
Re: sumproduct formula error
Re: sumproduct formula error
Complex IF Functions
Re: How do I retain row numbers when doing a filter?
Future date in cell to change color on that date
Re: Using (H/V)LOOKUP to assign value based off position in a range...
Re: how to break security password ?
Re: Sort a table using formulas
RE: Future date in cell to change color on that date
Macro to send multiple files to an email contact
how to do a reconciliation
Question
Adding user name associated with user id
Excel should accept angles as a number format. Degrees, Minutes, .
Re: Question
Re: Formatting numbers in Pivot Table
Statistical symbols...
Calculation
Index/Match???
Re: Calculation
Re: Excel should accept angles as a number format. Degrees, Minutes, .
Re: Excel should accept angles as a number format. Degrees, Minutes, .
EZ one Maintaining the reference cell in multiple calculations
Help with Formula Again
using calculated address?
Data Entry Mask
fill down
Complex IF Functions
Re: Saving formatting when pulling data from an external source
Sumif
Sumif formula greater than a particular cell
Adding user name associated with user id
Add only the cells after a particular number in the previous cell in the same column
Adding user name associated with user id
Pivot Tables - adding source data
Variants on the "Median" function - any ideas please?
how to separate words in a column with a common character in micr.
Switching Rows/Columns
transpose
Multiply entire column by %
Amount to Word Format
Dates prior to 1900
Changing colours of a cell
vlookup
Protect
Seperating common entries between different categories
identify references to linked information
How to make a pull down menu inside the worksheet ?
Is it possible to have a 'query'/filter from a master worksheet t.
Sending an email from excel
conditionals fields
Using the Indirect function with links
scroll bar arrows missing
Counting entries in cells
lookup
How do i create a marksheet gradebook template
IF
Output filter result to new worksheet ?
VLookUp Table
Applying minimum cell value
Decision Modeling Add-Ins for Excel
countif question for a rota
Total Time
Count function - fill color
Sorting column
Count Only Visible Cells
Sum Large, two criterias
Conting none blank fields
Lookup? countif?
allow viewing of certain cells in excell worksheet remaining cell.
Random
Creating custom number formats
How can I convert degrees minutes seconds to decimal degrees
Replacing contents of a cell.
Pasting data with commas
How to filter & aggregate nonblank cells that all contain formulas
How to filter & aggregate nonblank cells that all contain formulas
Cell Functions
Lookup and return the max Value
excel defaults
Complex IF Functions
Two conditions in a SUMIF
Formatting numbers imported to Ecel
what can i use to check the formulas were correct in excel?
LOOKING FOR BETTER SYNTAX
inserting rows
Two conditions in a SUMIF
Two conditions in a SUMIF
Using a date range in an IF function
DATE
SUMPRODUCT >24H00
Two conditions in a SUMIF
NUMBER FORMAT
Adding Within Categories
Multiple SumProduct Functions
new spreadsheet
Two conditions in a SUMIF
ACCRINT formula problem
AutoFilter Did Me Wrong
new spreadsheet
Automatic vs. Manual Calcualtions
Worksheet Not Printing What's On the Screen
Certain numbers always become dates
Scrolling
Trying not to use array formula
Only the text cells with zero convert to numeric
pROTECTING CELLS
pivot table formula function disappeared from excel 2000 in excel
VBA auto fill problems
Function help?????
Calculate new price with conditions
vlookup formatting problem
how to convert feet-inches-fractions to feet (or inches) in Excel
Reset a saved document to the previous version?
Can you color code the text result from an IF statement in Excel?
Calculating dates
handling nulls in concatenated string
How do I consecutively number several different sheets in a workb.
sumproduct formula and its limits?
Functions Help!
Use a cell, containing a tabname, in a function
Web Query Layout in Worksheet
"If Then" for cell color or boarder?
Inserting rows
Please help with date insertion
Timeline Chart?
Re: Pivot Tables
autofilter above 1000 words
All cells now divide by 10,000 any number that I enter
using calculated address?
Formula to find x number of values in an array that sum XXX.
SUMPRODUCT
Complex IF Functions
macro
Custom Fill/Enter?
invoice database feature is broke and needs fixing
Show only cells greater than zero
Need assitance w/ creating a running tally
printing formulas
Excel spreadsheet calculations
Please help with count function
Mass Deletion of Records
Please help with count function
convert numbers to words
Problem with changing defined ranges...
Function for sheet number
Excel checking numbers against a large list of numbers
VLookUp
create arrays
Lost Right Click Function
make calculation with mix format
Calcuate age
Lost Tabs on workbook
Help with Calendar
Match() returning the wrong row?