Worksheet Functions [Archive] - Page 33

Excel mail marge
Setting Cell to Worksheet Name
linking two sheets in a third sheet
summing visible data
Moving Rows To Columns in A Table
>> Dynamic Range
Sports draw
Using macros on custom toolbars in templates.
Combining upper and lower case functions
Rounding Help Please
how to put " in a cell thru macro
Conditional Formating cocor VBA
Change printer Macro
Info disapeared
Function autoupdate, relative addressing
Custom Menu return to Excel Menu
Hyperlink to file always opens with Exployer - WHY???
formula reference in cell
GETWORKDAYS function does not always work
Who who
Who who
Displaying total minutes in the form of hours and minutes
Displaying total minutes in the form of hours and minutes
Displaying total minutes in the form of hours and minutes
Displaying total minutes in the form of hours and minutes
SUMPRODUCT
Dates And TImes
Quick Summing Question
worksheets as series
help adding to my formula
display 1st day of each week and week number
Cell Contents Saved in File Name?
SUMIF
VLOOKUP with the Smith and Jones of the world
removing 'o' when referencing to a cell
dsum or not?
Match customer number to customer name
Re Target Times
vlookup help
Allowing access by password to a worksheet in a workbook and hiding other worksh
Excel Subtotal
multiply multiple cells by a specific value
Creating Reports
finding duplicates?...
Can a formula look for data in a number of worksheets?
Formula for rounding down numbers
Calculating percentages per group
"Conditional formatting" via VB?
week ending "Sunday" date function
Adding Debits & Credits within One Column
Skipping to the next cell in a worksheet
Left function returning first word
Calculate formula w/in one worksheet but 2 diff. pages
Changing conditional formatting based on seperate cell value
Rate of Return Custom Formula
Countif from multiple pages
search for text string within an array
Text Truncated in Excel Cell
sheet reference
Sorting Columns
circular reference
invalid file format
Lookup the most recent date from a column....involves 3 columns
COUNTIF
selecting multiple worksheets
Format......?
Timesheet calculation
getting a macro to change the value selected in combo box
Add missing zero's to customer number
Searching a text string in an array
setting up quick keys.
Calculating Cells
Change Formula to use Named Range
Vlookup with two reference columns
Selection Lists
Problem with Date
splitting cells
SUMIF using Background Colour
circular reference
changing date format
ranking with the same values
Monthly fills
Cut and paste problem
Excel 2000 - Formula Calculating Daily Hours Worked in Timesheet
#DIV/0! instead of total
Count unique rows and columns
missing formatting options
Can COUNTIF use a cell as a criteria reference?
Piviot Table Setup
data extract
Help with CONCATENATE
MACROS
Math operation
Daily interest calculation
array formula-f
Excel Combo Box using External Excel data...
Emailing pages of a worksheet
IF statement, copy/pasting cells
strikethrough condition
How to move from 1 sheet to another using macros
Trig and Excel Functions
Count ONLY the cells that are entered with a date?
Duplicate Entries
help with a couple functions
keep bllank cells blank
Color Fill Function
public thanks to Frank from Germeny
Inserting Rows to Include Column Formula
Countif two criteria - Date and vendor
Assign Functions to Control Button
Excel HELP with finding data in form and showing location
Array...
Vlookup
Trying to import several million rows- help!
Excel IF Function
Graph List
Calculating Times
Formula for conditional formats
Using the ADDRESS function embedded in AVERAGE function
#DIV/0! error - trying to make formula conditional
Printing
Forgotten password in excell 2000 document
Concatenate w/ Sumifs format
converting phone numbers in column
formulas!!
Average three greatest values
sound warning with conditional formatting
data import
Shared Drives
Removing duplicate rows
No Date Conversion Please!
Print Settings
Find Replace Dialog Box Close button
Conditional Format Formula
Subtotaling columns
Coin Toss
Find the average of fields containing text
Timesheet
Interest Calculation
formatting text strings
Trying to make a fromula conditional on at least one cell containg a value (not blank
Mail Merge like with Excel but without word
Cells won't format
VLOOKUP FUNCTION
COUNTIF AND
Getting around a circular function??
footer
Compact or Repair?
Finding the MAX Product sold by Salesperson
Home mortgage amortization with two different interest rates?
Help Needed
Linking formulas
Displaying the result of a formula in a different cell
Excel financial spreadsheets
calculation between cells in different formats
How to select a cell from another work sheet base on a formula
Blank Document not blank
Making First Letter Of A Text In Upper Case
advanced filter: duplicate result
Follow up on my previous "INDIRECT formula" question
Formatting Formula Results to Text
If then statement help
Where did my macro recorder tool bar go??
IF
drop down menu
CUMPRINC Function Returns #N/A
concatenate button
change a table to 3 columns only (Rows instead of Table)
mistake
active cell's movement from up/down/left/right adjacent to other select cells
Formulas not working
IF statement returns #VALUE
Random Numbers
Select numbers from a Random of numbers
using SUMIF function with compound conditions
If And Statement
To Jerry Lewis
adding specific cell with todays date
Nested IF Troubles
Data functions Lost or Disabled?
Problems With Custom Worksheets
Credit related formulas
proper formula for countif (a1:b10, "apple && pie")
Sum to exclude blank row
Count the number of times a charecter repeats in a Cell
Date and formulas
Copy Conditional Formatting
real state - Brazil
Is it possible to mix up a list of numbers
Extracting a # of days from a date range
Counting list entries on 2 criteria
covert text to e-mail address
=DAYS360 Function
vlookup and hlookup ? required
#N/A = FALSE
If / or/ then
linked workbooks
sum products with ANDs
Adding days to a date
subtotals
If you can figure this one out, youre a Genius
Protecting functions without stopping Auto filter
Concatenation
Concatenate...If...Need to roll up text.
Copy cells to a row specified in another cell
Find relevant sheet name
SUMPRODUCT Problem
TRANSPOSE and MMULT don't work together
cell protection
Rounding Up to the next .50
zeroes
External workbook references with variable components ??
ANOVA
VLOOKUP multiple conditions ...
How can i trap the rename event of an excel sheet?
TIME / NOW
Min
Fussy matching?
Filter for cells by locked/unlocked status
Re: today() function and text
2-line address in one cell
Function to replace
trying to input number from another cell automatically
Pivot Tables
How to sort by birthdate
Macros disabled message
isnumber won't work
Concatenation
link cells from one workbook to another by left clicking the cell.
Formula incorrectly calculating
Future Value calculation
comparing matching same values in two different columns
autorank
autosave question
Dmax Criteria
Custom Date format in formula
Finding a value
drop down menu
avg percent
Copy then Paste more than once
Auto Formua Calculations
filtering info out of a list
Can't insert a simple row
Ignoring the higest values in an arry, and the average of the rest
Extract part of a text
Monthy Averages
Previous Cell
Compare Text in Array of Text
change columns to rows in pivot table?
Fixed Decimal in Excel