Worksheet Functions [Archive] - Page 89

sum of last 7 numbers
using particular positions within an array
IF Function to test formula in a cell
formulating a balance when a loan payment is made
Display text > 1024 characters in a cell
Counting text across multiple sheets with a specific criterion
help me getting value of column based on condition
Formula problem.
Performing Math with Time over 24 hours
How can I sort one column and have the entire row sort. (binding)
frequency formula with criteria
Auto Sort using Macro
Q - Excel 2000: How to refer to worksheet in the same book?
Using the RATE function in Excel, I get a NUM error.
Excel, turn off the hyperlink format when formula is @sum
If function for workday & weekend
Macro Help
How do I subtract using formulas?
Renaming Sequential Rows to create serial numbers
Conditional Functions
Conditional Functions
Conditional Functions
Average to date
combining a Vlookup and Mid formula
auto insert invoice number that increases by one each time opened
sequence of numbers
Help formatting cells
part number with 'E'
help me please on if function
Is it Possible
What is a function in VBA EXCEL witch finds a string like "not" in cell and then deletes a row with this cell?
World Clock
Countif with more than one criteria
An Inquirey on the Round function
combo Box
Help!!! Vlookup!!
Date format
Summing large numbers...
in excel tel diff. b/w 01/05/2006 and 28/02/2002 date wid formula
formula that compares different ranges
Working with data?
count G4:G51 for critera only if D4:D51 contains text data
How to make an input in one column determine dropdown list in anot
can you use countif function for noncontiguous cells
Spinner Control Properties
Suppress array formula #NA
Auto Inserting numbers
Can I use a Reference inside a SUMIF or COUNTIF Function?
How to repair 2005-2006 student attendance record?
Macro to replace data within a worksheet
Text string and sum
if data in one cell, then date in adjacent cell
hyperlink changes when doc emailed
Time Card Show Up Time
How to convert 250minutes into the format of hh:mm:ss in Excel?
extract numbers from cell containing text & numbers
Force format change in excel
Multiple countifs
Select rows based on criteria
Write cell info to external file
macros
Condense formula
Multiple if or multiple vlookup
how do you make negative numbers show up as 0 in Excel?
how do I sort email address by ISP?
Autofilter Locks???
Autofilter Lists across Multiple Sheets, Maintain Correct Referenc
Unable to sort data in excel with cells containing if & hlookup
Count excluding Duplicates
Can I make rows of an excell spreadsheet 'selectable' (on/off)?
Creating Formulas In Excel To Calculate Time Intervals
spell out amount?
How do I JUMP from pane 1 to Pane 2?
why does the toolbar have a button, $ and is said currency,it giv.
PLEASE HELP--going crazy with a simple calculation
EXCEL OPENS THE SAME FILE TWICE, HELP!
how do I autofill an excel worksheet with contacts from outlook?
Merging worksheets
sort in excel using end of email address
I want xl to look up postalcodes and compare them with another she
Not to sure
Referencing cells in different worksheets
Limitations od Excel Sheet
how use range to bottom of filled cells?
Scheduling employees by dates... LOOKUP or FILTER?
formatting date-time values in macro
todayif??
How do I get cells on a sheet to automatically fit data?
Simple Formula (I thought)
Can I apply a "score" based on multiple cell values?
formula needed to track dates event happened
can an array do this.....
Comments in cells
Formula in a writable field
Automate a date referenced in a formula pointing to another sheet
extracting data
Number of work sheets
Adding a formula within a formula
Computing a date range
Comparing 2 columns if they are the same
help me on tough sum on conditions issue
Formula
One line of list show up in different sheet
Excel Help
" / " Changing Decimal number format to Fraction on Protected Cell
looking up names in a list
Roundup or rounddown
how to use sumproduct
Converting column & row numbers to a cell reference
multiple formulas in one cell
wrong year
make custom formatting permanent
removing unnecessary spaces from multiple cells
Column A = X, Column B =y count = count +1
To copy values in a column relevant to text in an adjacent column?
Is there a function?
Compare range with another range in other workbook
Calculating elapsed time
multiple criteria ifcount()
Hyperlink problem to cell in same workbook
Another Date issue.
How do I calculate a formula once
2.3345 I want to find out what the last 2 digits are, i.e. 45
Matching when spaces are involved
Forms Toolbar in Excel 2003
Count rows if date is between two specified dates
search funtion
Count multiple occurances in a column
my sumif statement brings back mutiple answers, how do I fix it?
vlookup problem, possibly due to "noise"
If a cell is modified after a date; font color change indicate
Conditional Formatting-can a "then" be placed with the "if".
How to generate #'s that excludes certain numbers?
In EXCEL 2000, when using the Filter feature
sales tax
How do i set up a running balance on one row?
How do I create a formula for a quiz in Excel?
Value in cell refers to value in another cell
how can you convert hours into minutes?
want highlight when all cells in range are equal
find same amount in different workbooks
Lookup
What formula do I use if I need to look at the column and row?
Help with complex VLOOKUP
if command for yes or no
How to sum data that is only within a specific number range?
Can I use SUMPRODUCT for this?
Averaging a Value Between Two Serial Dates
Formula Workdays-Holidays-adjustments
I would love to be able to put a wrap text button on my toolbar.
How can I sort in groups of 3 rows?
How to correctly write a cross-sheet "IF" formula in Excel
Is there a macro to convert times between 2 places dep. on date?
Identify missing record numbers
removing pre-set characters from comments
How do I sort and put a space between each sorted choice
Multiple worksheets
Transferring data between worksheets
Excel filter dropdown shows all data
How do I prepare a debt acceleration worksheet in Excel?
Entering Same Formula to A Full Staring from Say Row 5 Column.....
Cell text based on 4 condition test
how do i name a excel worksheet and make it appear in cell a1
conditional fraction - sumif?
countif problem - am I bonkers?
countif followup
Discrete "Normal" Curve Function?
How can I call a macro or form. in the moment that enable any shee
Icon for "Wrap" and for "Centre Across Selection"
How Can I call any form or macro..
vergelijken tabblad naam met waarde uit cel
how to change a list of possitive numbers to negative
how to change a list of possitive numbers to negative
Multiple Criteria for COUNTIF and SUMIF
Holiday Dates
How to change number to text in new column from another worksheet?
Select cell containing specific text &return value from another ce
Find and copy part of a cell
Totals
Conditional Formatting
Display Part of the cell value
Inserting rows into worksheets that are protected
How to project usage.
How do I set up an "IF" formula?
How to add a column of accumulated data in pivottable?
Date(Y,M,D) 'feature' or problem?
Macros
Significant digits
Formula help
How can I delete source links and change the current sheet accord.
Nesting Index and Match Functions
Post 1000 Message to Newsgroups Promoting my site and earn $100.00
Conditional Lookup?
formula that will go up one space if no value in specified space
Selecting the i-th element from a range
Problems losing changes in shared workbook
Excluding cells
Running a macro if any data is entered in a range of cells
Sorting and Adding Space
"IF"- "THEN" type Formula based on Null value
Constructing range address given row and col numbers of boundaries
Vlookup and forecast
If formula result is false, how do I auto-delete that rows?
Get paid to promote my site
FLOATING CELLS
Text is being converted to Date
=SUM(A1:A5)*24 for totalling hours and minutes is not working
Referancing differant sheets
Counting cells base on a predetermined range
countif
Formulas
RE: Does anyone know how to turn off the GetPivotData function?
change values globally
Selecting specific row/column from a named range
MAX function for a given Position Title
Formula Needed...
data sorting
Bug in help for Excel SUMIF function
How do I write the formula to calculate someones time worked
Return Array with Array
Sumif or Sumproduct
copy and paste between cells that have data
Merg Worksheets
Converting decimal calculation to h:mm format
Help summarizing data needed
If ? maybe.....
DateDif problem
how do I count the number of times text in column A matches text i
Does anyone know how to turn off the GetPivotData function?
INVOICE COUNTERS
Converting a number to a letter in Excel
VLOOKUP issue
VLOOKUP issue
Replace cells with blank
merge worksheets
Search for record with specific name in a cell
"FIX" is displayed on status bar
Return entry in column above/below cell
how do you link rows of cells to other work pages?
I would like to print the titles of files inside a folder.
how to diferentiate integers with decimals in the IF formulas
program to open excel sheets without excel
How do I find....
Is there a logical test for a cell's format instead of contents
Having trouble with vlookup and match
Function determine if date is even or odd
Using Excel in different countries
TEN OLDEST DATES
problem with FIND
IF NOT FOUND