Worksheet Functions [Archive] - Page 76

How Show decimal in Bar Function
Count the number of Cells in one ROW with conditions
converting a number to English text ( not to Baht) is needed
Help writing an Excel Formula
27 sets of data. Need to find zero in each set
% change in the last two cells in a row
VBA Custom function for lookup
Conditional Average
automatically insert row at each page break
Fill-in empty cells from SAP report
keep date format in a Combo box
My DCOUNTA formula results do not display in Excel.
Using dates in formulas
Is it possible to put 2 splits on one page? If so... How?
Count cells with condition
Function
Linking cells
Please assist
Type in letter return word
Help with conditional format
Don't know what to call what I need?
Concatenate and Vlookup
Controlling text in an Excel worksheet
How to record macro to print pages modified today
linear interpolation function in excel
What formula would I use to get -2 / -2 = -100%
counting unique values and matching to quantities
How to replace a word with a word from other column?
How do you convert embedded drop-down lists in Excel '97?
SUMIF excel function not working
preserve "-" when importing text field from access
Random Numbers
Summing only those cells that aren't hidden
nesting if statements
Formula Help with Lists
Pivot table grouping of dates in row fields will not work. Why?
Another Nesting IF Statement Problem
Range of data within a column
Find and Concatenate
serial number cell
EXCEL: IF CELL B6 RED, HOW DO I GET A "W" (ie for win)to show up
Apply cell shading based on adjacent cells in EXCEL
How can I count values greater than and less than certain values?
display minutes and seconds in excel
Excel should have a tan^-1 Cos^-1 and sin^-1
Sort from lowest to highest
comparing two columns & then perform a calculation
delete repeated numbers
Delete repeated numbers in Excel
Need Help Writing a Formula
if statement problem
return a cell contents as the result of usiing "small"
Compare two lists with two variables
If
How do I create a weekly series?
Smart tags for financial symbols
Referencing worksheets
Excel formula for monthly interest rates
halves
Dro pdown list formulas
Need help with formulas
Remove apostrophe
Splitting Character String
if function
Put comments on a locked spreadsheet even though cells not locked
removing year from date
is there a percent error function in excel?
Summing accross sheets
=(A6)!$O$14 - why won't this look for same name sheet as A6?
Average Function Help Needed
SUMIF problem...
1430 to 2:30pm
Excel sheet question
XIRR function not defined?
Auto number invoices in Excel
Subtraction formula for consecutive cells in a column, skipping blanks
Summing specific cells!
Copy & Paste macro
creating function (vba) with range arguments
Fill down to nonblank rows
Interpolation using GROWTH function?
Trying to freeze panes. line down and through middle of worksheet.
Fill handle formula
NOT UNDERSTANDING THE FORMULA
Help with Formulas
conditional formatting autoshapes
=CONCATENATE() help!
Pivot tables and total count
Workbook & multiple spreadsheets
can you filter more than two items in excel 2000
Arrays
Complicated lookup/match fuction
DATEIF Name error
printing problems
How do I quickly fill a formula result into a column of cells?
Delete Rows where cells does not meet criteria
how to format only a specific character or number in each cell withina range of cells
using filters with the sum function
Use functions when cells are merged
Pivot Table Question
Format single column cells to be 6 characters long
Pulling data from another workbook
File won't open. Error message "too many different cell formats"
Frequency within date range
attendance sheet
Locate and retrivie data in table/matrix
How many std deviations is Excel function "STDEVP"
How do I reconcile bank statements?
Reformat IF(ISERROR(....) : if 1st option returns empty, look at 2nd option.
Prevent Worksheet Deletions
Sumproduct not working when summing values between two numbers
Multiple coin flips in a single cell
How do I randomize ascending data (number values) in excel?
Text from Max value
Copy Cell Referecnces
using a checkbox for a conditional function
Merge & Center function is turned off...how do I turn it back on?
Functions not "recalculating" when input changes ???
vlookup reverts to data from a previous report
using getpivotdata function
organizing a workbook
Lookup
error N/A
Contents of cell
finding if name within range
Information from column to row
2 different Companys. Data Sort
#Value error when linking workbooks
vlookup almost does this but not completely...
Delete repeated Cells
Your online office "help" system REALLY sucks!! I'm not kidding!!
linked cell is displaying formula instead of the data
How do I sort entire spread sheet. Names w/data
Re: Shortcut keys assigned to macros/functions in excel
link help
If typed 12805 then 12/8/05
Frequency of values with Criteria
how do i calculate time in & out in excel using a formula
Subtotal results without word "Total"
Counting cells
Non-random numbers generated by excel's data analysis random gener
What is the spreadsheet function in excel
Display "Last updated date" for the Workbook (without using a macr
Copy and paste from 1 workbook to another
Make a formula that adds every 4th cell in a column indefinately?
How do I stop Excel from treating blank cells as zero?
move from one column to another after a set condition
format column for unique values only
Adding time Values up in Excel
Count "how many in a row"
Connect columns, with restrictions
Conditionl Format
Help Needed Urgently
Contains instead of Equal
how do i find # hrs & mins. between 2 different dates and times
How do I split a cell of 2 words into two cells
*HELP NOW PLEASE*
Macro
extract data Column 1 starting with A1, A4, A7, A10, etc.
European date formats
Look up problem
HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES
Adding numbers in a single cell
VBA - Do not allow duplicates
Multiple If Statements
Conditional Formatting that will display conditional data
SHORT CUT KEY(S) TO SHOW OR HIDE SEETS IN EXCEL
Help One Way did not work
Lookup question.
Can excel sort entire rows of data like access?
is there a "distinct" function native to Excel
tab scrolling buttons - excel 2003
How do I change where Excel looks for templates?
trouble shoot pointing to a cell
Retuning a column number for a specific value
lookup cell content in multiple files
Dates Not Formatting as Dates
vlookup over 2 sheets?
Calculating two numbers in one cell
numbers
Word Associated Shading or Color
finding name within range
Matching data using date criteria...
Please Help and Thank you!
Creation of a Generic Macro
formatting dates
HELP ASAP get rid of blank rows without sort
Need help summing time
Need to get rid of blank rows without sort
Need to compare 2 tables to generate 3rd table
mixed font styles in the output of a formula?
Vlookup for data contained in a cell
dynamic defined ranges
freeze other columns when columns have been frozen already
Avoiding #NUM!
I Need Help with complex formula ?
Converting CSV files into Excel files
Very Frustrating - Please Help!
How do I count a value if another field = a specific value? Excel
Filtering Columns to Align Matching Data
having a two tables on the same page with different widths
one formula to make a multiplication table work
search value in a table and sum another column
Vlookup Headache
add a column only if 5 other cells on the row satisfy criteria
Changing positive figures to minus figures
=max(range includes #N/As)
What is the shortcut key for adding $ to a cell reference eg $c$3
drop_down_box
Adding Cells
Calculating Month Average Exch Rate from Exchange Rates Calendar!!!
I cannot convert using HEX2DEC formula? i need a plug in i think?
looping through a set of calculations
Help with formula please...
using linest to generate 3rd order polynomial coefficients
Couple of hopefully easy questions
Preceding a number by zeros, that is still a number
matching numbers in col a and col b
Forecasting weekday occupancy between two years
ranking
Can I use Excel to create this text file?
Using countif with 2 conditions
Excel 2003 Subtotals not working correctly
how do I keep the dropdown list button visible continuously
Date functions
countif
calculating number of months from today
Help with formula
Locking cells after one answer
Comparing Two Spreadsheets
Sales League table
What is wrong on the fomular: Offset(MIN(A1:A10),,-1)?
Opening multiple Excel files that contain varied selected sheets
Formula to determine number of Standard Deviations based on % of population
Locking a table
Finding DUplicate Data set in Worksheets
how do i get this
How do I define "contains' as the default custom filter?
Formula Assistance Required
options under tools dose not come up
drop-down list validation won't allow a different worksheet
Can't get list in Document Contents for workwheet
Getting the first 3 digits out of 6 digit cells?
Search feature in workbook
Page Header
output based on data in a graph
Make boxes apear on paper?
How do you add a-z (alphabetically) to your toolbar in micr works
Linkage data between two spreadsheet
data validation list should have opt. to select based on criteria