Worksheet Functions [Archive] - Page 38

Macros
How do I make diagonal Column Headings
Sumif???
Invoice template
PivotTable in Macro
Paper Size
Lisa needs a formula please.
Removing ALL duplicate entries
link access to excel
enhance vlookup to not return #n/a
Count with multiple condition
copy formula vertical and paste horizontal
Ability to change the Excel comment indicator color
How to use Function IF
Count
Formula Help IF?
Add to formula
how to change cell color as result of formula answer
cumulative or running total
Using cell info to reference worksheet
Removing Text from numer field
If Statements - Commission Plan
Running Total without Updating too Many Cells
Hyperlink
Add only the cells after a particular number in the previous cell in the same column
Drop down menu in cell.
Troubleshooting: copy numbers from *.pdf to *.xls
log all changes
delete Forms toolbar controls
=D3-(D3*B#) in which the # is the Row number that the cell is in
linking cell ranges
Converting numbers in figures to words
Error when Subtotal function inc #N/A
Excel work sheet
Function help needed
array formula
Domenic, where are you?
#VALUE appears in Excel file with links using "No Update"
Subtotal and Countif
Counting characters within a cell
Sorting Groups
COUNTIF for text and strings
In Excel,how do I display my title cells so that as I scroll down.
Value of last non-blank cell in a column
Changing Cell References
sorting blocks of data?
Saving formatting when pulling data from an external source
COUNTIF function
trouble using dmax function
Sumif
To sum according to cells color
Future date in cell to change color on that date
Auto Filter "issues"
xl 2003 - Analysis ToolPak question
Auto-Filter Stops Displaying # of Sorted Records in Bottom Info Bar
IF statements
Macro to send multiple files to an email contact
how to do a reconciliation
Statistical symbols...
Calculation
EZ one Maintaining the reference cell in multiple calculations
Help with Formula Again
Sumif
Sumif formula greater than a particular cell
Pivot Tables - adding source data
Seperating common entries between different categories
Is it possible to have a 'query'/filter from a master worksheet t.
lookup
IF
Output filter result to new worksheet ?
Total Time
Count function - fill color
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
How to filter & aggregate nonblank cells that all contain formulas
LOOKING FOR BETTER SYNTAX
Using a date range in an IF function
DATE
Two conditions in a SUMIF
ACCRINT formula problem
new spreadsheet
Only the text cells with zero convert to numeric
pivot table formula function disappeared from excel 2000 in excel
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?
sumproduct formula and its limits?
Use a cell, containing a tabname, in a function
Please help with date insertion
SUMPRODUCT
Show only cells greater than zero
convert numbers to words
Problem with changing defined ranges...
Function for sheet number
Match() returning the wrong row?
Excel: Format a worksheet downloaded form Access
Calculating date ranges
How do I create a list using Excel when there isn't a list option.
help with sorting
summing cells in different worksheet
Sum using INDIRECT & Dynamic Named Ranges
Excel: Add a function to retrieve the last Save Date.
auto-generate a number in a cell on opening new workbook
Formula Help
Filtering based on selection
Formula Help
how can I setup a reference for a column of data to another sheet.
Dynamically linking several worksheets
sumproduct help
Excel PMT function returns incorrect values
Value from another workbook based on calculated value?
concatenation
How to get decimal point between dollars and cents
Can I subtract dates in excel and produce the answer in months?
Text Missing
time sheet to make schedule to work
Merge Columns
Lookup with multiple lookup values
Count non-consecutive cells.....
Advanced Filter
Help Conditianal Formula Help
How do I enable macros in excel?
msn money stock quotes add-in
Linest
Pivit Table
TODAY function?
IF Function Help
Question about "$" function
Changing default font in comments?
Using CountIF with multiple conditions
Array Formula
Data Range
If Formula
OPENING 97 FILES IN 2003 VERSION
Why "find" doesn't work in one workbook, but it does in another o.
HOW CAN I GET REPORT MANAGER ON EXCEL 97
formula guru needed
Convert date to text
help
How do I make one workbook from several
> 24:00
Between Times
Excel SUMIF formula statisfying two conditions in two columns?
Excel Formula
What Excel function returns the current worksheet name?
linking the other .xls files
Need function to calculate mathmatic formula base on two critera
Conditional Format/Count If
How do I totally remove macros from a Workbook?
Help with list???
How do I use RAND to generate times for 8 hour shifts
Time entry = Total Hours (rounded) ??
How do you make a checkbox work in Excel?
Formaula to calculate "between"
ex. Can you use the IF formula in each cell within a column and g.
Filter out duplicate values in columns
Random numbers and letters
Rank
Formula or Macro needed
entering a formula or function in excel containing just text
I need for Excel to make me a box plot
Make INDIRECT formula easier to copy ...
Number of columns
change relative to absolute references
Add words to a function
Search identical values in a column
Create dynamic link to multiple worksheets/workbooks
How do I transfer data from drop list column to different workshe.
Year To Date Ideas
how to pull names from a file and put them into a worksheet
Count Function in a Filtered List
VLOOKP
Conditional Format
Trying to do UK mortgage amortisation exercise
opening worksheet problem for one user
put row/column transpose in obvious place, like DATA -Transpose (.
Sorting Subtotals
Auto filling separate sheets in a workbook
Converting seconds to hh:mm:ss
Text stuff...
Semi-colon vs Comma in Functions
if with 2 conditions
if with 2 conditions
Conditional Formating
i cant change the format of the date when referencing another cell
going beyond just true and false values
How do I find text, returning the cell address
Time
Extract the unique combinations of values from 2 columns
Excel 2000
Automaiticly move from one cell to the next
What Function is the Opposite of the FV() Function
make a text string equal a number
Passing controls from Excel to user-defined function
Can Vlookup accomplish this?
RANK FUNCTION
Highlighting Every Other Row Formula
formatting excel worksheet columns
how do i get solver?
Need Help with AND function (cell colour or GANT chart)
using data validation with several different lists
wrap text not working
how do I count the cells that contain a letter along with a numbe.
I cannot insert a row in an excel spreadsheet.
VLOOKUP to tables in MS Access?
Ranking "Sorta" Sequentially
Totalling Values Specifically Identified
copy data from workbook to workbook
change date format to text
prevent cells from editing by mistake
button for FUNCTIONS
Compare Excel Tables
Reporting within Excel
SQL.REQUEST in Excel 2003
Copying Data in a protected Sheet
run macro when worksheet is selected
Excel rounding numbers
How do I link a Tab Label to a simple text label within the same .
Every Other row...
Series Trend
stripping out a text string
I need an excel formula that sums up 2 cells on a specific date e.
How can I subtotal in Excel
Pivot Table formatting help
Conditional formatting of a shape
Date - help
I have excel 2002 why doesn't it have a create list option under .
Hours into minutes
VBA IN EXCEL
how do i create a normalized bell curve from 4 data points
numbering
How do I zero fill columns in excel?
countif nesting with subtotals
NPV formula
using vlookup to find a value but use value only if starts with te
MATCH or VLOOKUP or ??
Countif and vlookup functions
System Date
Multi conditional IF
CHOOSE function, is this impossible?
countif function
How to import only last 30 records from a database
Data Validation List, how to create sub lists???
Filling a Series of Alpha Characters
create calendar from a look up table
Travelling Toolbars and hidden macro sheets
Select values form a table