Worksheet Functions [Archive] - Page 61

How do I get a spreadsheet to print to actaul size of page?
if statement module use please help
Stupid
help with forumla needed... getting a yes/no answer to ??
Horny Teen Girls
Constant growth
Dynamic Formula
Need a formula that would make life easier
same formula giving diff resutls
converting hours to days,hours,minutes
validation combo boxes not working
How do I sort a horizontal worksheet to create a vertical table
Bilingual workbook problem
Login Logout Date Problem
Help need with formula
ACTIVATE CELLS
random numbers from a data of numbers?
IF AND question
IF AND question corrected
IF statement to check cell contents
Excel should let me imbed documents and programs within its-self
Help with function to add percentage to cell based on checkbox.
autonumbering
Formulas e FuncÃ§Ãµes
pair single column to multiple column
Extracting data without using database functions
combining numbers into combinations
Command
re:Any Ideas?
Rank Question
Activate List of Email Hyperlinks
Lookup worksheet agony
Excel Calculation
#N/A resutls in Vlookup when there is a match
Why am I prompted for the workbook password for each worksheet?
Summing up time
adding a formula in a cell but when cell = 0 cell is blank
How do I count the number of alpha occurences in a range?
How to change a visible formula into a value? (Quickbooks download
deleted w/sheet. How do I recover
Sorting a sheet
I'm Lost, Need Help
excel compatibility
Can I count cells with specific format (e.g., yellow field?)
Insert excel data source into word doc using currency symbols
How to find method to cut steel coil by using excel.
transferring checkbook template to excel
A way to refresh a certain cell everytime wroksheet changes
Fonts
Even and Odd Numbers
How select an item in a list box
sumif with 3 conditions
How do I perform a contains function for a specific cell?
Hyperlinking
preventing one part of a formula from iterating
Ticks or Crosses
¯äsite¤@*Ó
¯äsite¤@*Ó
add cell across all worksheets
¯äsite¤@*Ó
¯äsite¤@*Ó
normalizing data -- a twist
NETWORKDAYS gives #NAME even though Analysis Toolpak is installed
Re: Autofill date based on date in another cell
Access Rights & Reports
Spreadsheet/VBA Project Consulting: 50% Discount or Even Free - Limited Time Only
RE: Sumif Fucntion
HOw do I set up Standard Error in a spreadsheet?
Volume and pricing calculations
RE: COUNTIF or SUMPRODUCT counting multiple criteria
RE: Macro - formula for end of last row
Column number of last column containing a number
Only do Sum function if not "0", IF"0" then return "0"
RE: Lookup Value is Between Range 1 and Range 2
nesting functions
making a number be text
How do I put more than one criterion in a SUMIF function?
Opening Excel out of explorer or outlook attachment
Recogniziting Dates in an IF function?
Count the number of specific values in a cell
RE: SUMIF using a multiple-column range
ISERROR VLOOKUP
Putting Sheet Names in a range and renaming it?
Macro - formula for end of last row
COUNTIF across all sheets of a workbook
Empty cell control
Lookup Value is Between Range 1 and Range 2
Count if not 0 or return value of 0
COUNTIF or SUMPRODUCT counting multiple criteria
Is there a function that allows me to list the names of excluded d
SUMIF using a multiple-column range
Sumif Fucntion
How do I have a formula check if a value occurs within a range?
Determine the location of an external source of pivot table?
Sumif and autofill
Linking from several cells of 1 spreadsheet to fewer of another?
need to program my lists to automatically alphabetize when new ent
How do i make a formula reference the last entry of a column
Help with an if statement
delete rows from multiple worksheets
more conditional format conditions
How do I calculate the area under the curve using Excel?
subtracting hours and minutes
hidden names in active workbook
Converting 100 cents to 1 dollar
Filtering data to another sheet
calculate interest between two dates
a search function
emailing
How do I use 2 worksheets in 1 page
Time Date Formula Problem
Re: Do I need a sumif or sum of a vlookup formula?
What is the use of {} before any formula?
Troubles with the OFFSET function
Array formulas
Trying to email a spreadsheet
Formula for next day based on clock
daverage problems
Re: can lookup a number to a 10x10 table?
how do u remove default setting?
VLOOKUP WITH ALPHA NUMERIC
Averge time
Search and Get Function Help
Is there way to restart page numbering for each tab in worksheet
My copy function won't work - I get error "cannot empty clipboard
help needed with text to column
Date Formula
Length of employment
warning or message before saving spreadsheet
Opening Multiple Worksheets
Displaying only digits after the decimal point
how to make cell address reference increment?
Conditional Formatting Multiple cells based on 2 cells
DECIMAL PLACES IN FORMULAS
counting unique instances of text in a list
if statement in worksheet
Excel to Access
Formula for # of sales days in a month?
Optimize simple macro
using a slave worksheet
Reference to another worksheet
maximum of rolling totals - aka Rmax
Gridlines into excel spreadsheet after changing background color
Hyperlinks change when Excel file is saved to a different director
Return range of values on an "IF" statement
vlookup
How do I get rid of infinite numbers past the decimal place?
Merge Worksheets
help!!
Why do my dates change when I copy them between Excel worksheets?
Random Numbers
working with IF statements
No showing of cellnumbers used in formular with colour
List
Automatically inserting rows
"COUNTU" function in Excel to count unique entries in a range
Excel Statistical Functions and Routines
calculate the value of a mortgage purchased at a discount
Past Due - Due Dates
List
Separating Numbers
Can I add a Warning Meassage to a Macros Designed to Delete a Row
Unexpected result
How do I move or copy more then one sheet at a time
16th digit changes?? Problem,16th digit changes to a zero....
=B
How to Calculate Time
comparing a value in a cell to see if it is higher than a number
the cell currently being evaluated contains a constant
SUMIF??
Returning an answer in an if fuction between two values
Match/Lookup Statements
Format Excel column to notify with a reminder
Excel function problems
Excel % Variance Formula........
Pocket Excel/Workday Function
Wildcards in other workbook cell refrence?
Dependent lists
Formula on nth row
look up same values in coumn1 and calculate values in 2nd column
stop automatically changing fomula ...
Multi-layer excel spreadsheets
if coum 2 has vale then populate colum1
Complex If Then formulas
How do I get a row to show up on every page
The ExcelTip forums update this forum
Logical Function
Time Value of Money
Is Datedif Outdated ?
SumIF Formula
Anagrams
automatically filter out blanks in multiple columns
in excel I want to set up a drop down & link that to another cell
name list
I cannot get Excel to put negative amounts in brackets. Help !
Counting capacity based on technician schedule
macro used to change colors
Still need help
SumIF
Name list
How do I count how many times a code appears in a column?
cells functioning odd
Advanced use of IF
Use formula to hide/delete cell?
Syntax for 2 AND conditions within an OR function.
need function to sum top ranking items in list
Data Valadation -
SUMIF With Multiple Categories
Sorting data in a master sheet
Formula checking multiple worksheets
Cell Height formula?
Data Manipulation FUNCTION
Is there any way to get an AVERAGEIF & MEDIANIF function in Exce
How to Calculate Time
Conditonal Format Formula
vertical text
Exclude data from summary totals when hidden
How do I create a numbering format in excel?
sequential numbering in non adjacent cells
column changed from alpha to numeric
extracting text data in a cell
conditional value required on basis of column a
Search in 2 kolumns and 1 row
Further Question about Transpose
Pivot Tables
Please help with formula
Help Userforms / Excel SUMIF
HOW DO I GET THE EQUIVALENT OF MAXIF(RANGE,CRITERIA)?
Average of filtered data
Conditional formatting in relation to other cells
MARK EVERY FOURTH ROW
SUMPRODUCT vs CSE
Decimal points not needed
Pivot Table - Extracting specific data
Pivot Table - Extracting specific data
Conditional Formatting with two Spreadsheets
alternate blank row
problem with SUMMEWENN
How do I shade cells during selection?
Nested Countif
move column headings from row to column
How can I locate the second to last value in a range?
monitoring a changing range of cells
Can I use cell contents as part of a formula?
find and replace links in Excel 2003
"Drop the lowest" in computing average
Calculating recurring date in following month, calculating # days in that period
VLOOKUP works sometimes
Delete columns or rows
Excel Statistical Functions and Routines