Worksheet Functions [Archive] - Page 14

0 if blank
Convert lc to UC in rows of spreadsheet
How to sort 2 fields in 2 merged worksheets
Need help with countif, vlookup and maybe more all in one
Identifing duplicate records
Freezing Panes within a PivotTable
Degrees Minutes Seconds conversion
Brain Fry: Data Set Sum Compiling
Copy Paste only formula across wksheet
Too many different Cell Formats
Using a Excel macro or VB to call up a WORD mail merge document
LINKING CELLS
Duplicate Records
Help: CountIF 2 columns non duplicates
Stumped on finding last row with data entered
Adding pull down tabs in a worksheet
Count-If function with multiple variables
mail merge foorm excel to word having problems
Re: Excel Function: COUNTIF Problems
Stock quotes pullup into Excel
Counting number of occurrances
Cannot check autofilter - Grey'd out
request virus scan
need to access a database in a excel workbook
using IF with a {>= but <= } range
subtract
Excel Loading
Frequency displays incorrect
Counting dates & Times
method to copy cell format through formula/VBA?
How to Combine Cells of Information in Excel
day number in a year
Converting Values
Avoid comma displaying
Time Function
Add a month ??
Creating a PivotTable Report from an Another PivotTable Report
Work Week dates
Is it possible to find out formulas behind functions
Re: Help Create an Effective Marco
nesting formulas, if a4=1 than d4=b4*c4
Trouble with Find method locating Date fields - works great with String fields.
Open as Read-Only
Excel solver
Pivot Table - Total(s)
PV & NPV discrepancy? -showing different results for same entries
Actual numbers turn to dates
Version compatibility
counting multiple occurances
Formula for Shading? Is this possible?
&[tab] Usage Twist
Date Formula in color
Re: Time Formula
Re: Format cells based on other cell's value
Worksheet Protection
Transfer data from sheet to sheet
Combo Boxes and Blocking entering text
Custom Number Formatting
Times from sheet to sheet
Re: Add data from sheet to sheet
Select certain rows of sheet & delete the rest
Value of a cell in a range if color is yellow
Locking other cells based on values in a cell
Can't change font default
Rounding numbers
formula for percentage w/ arrows
Re: Using Countif across multiple sheets
Re: Text Box problems????
vlookup
checking a value..
Autoformatting...kinda?
Kms to Miles conversion
Looking for efficient solution to formulas
average
Matching / lookup problem
Entering Dates
Find the date question
PAYROLL
Mouse Not Working
Re: calculate time
how can deactive cells to input data
concatenate
calculation
Is there a way to avoid that Excel add quotes to text when exporting a sheet?
payroll
Work Time Sheets and Wages
Filter based on data entered into cell
Printing only what can be seen
Removing Hyperlinks
formatting phone numbers
feet
help
autofilter large worksheet
Macros
Calculating Time?
Formula to combine cells (A challenge!)
Re: Find #DIV/0! Error and Replace
Macro
If function is limiting me at 7!!
Goal Seek Formula
formula for computing multiple links
Entering a formula to round a number by a certain criteria
How can I upload without using msxml?
Syntax for writing a formula to a cell
Day of the year
Re: "Matching" column A's values in column B
Adding the Registered Trademark (R) back to the auto correct file
DGet function
Pointer-like behaviour in Excel possible to build formulas?
Hung Up With 3rd Argument of IF
Formula for year (leap year)
Print Excel columns not side by side
Advanced Filtering
Sumif, subtotal and filters
VLOOKUP
Import data beyond worksheet.
Headers
more lookup trouble
Finding "links to other data sources"
Re: Negative numbers in formulas
Convert minutes to hours
Re: isformula
populate cells based on mulitple characters
Office 2003 Excel data tracking and template wizard
Re: populate cells based on mulitple characters
Automaticaly calculate over time
Connecting Separate Spreadsheets together
Nested IF
Limiting Input in a Cell
Another SUMIF
Formula doesn't display value
PRINTING COLOR
change cell color
Restrictions on the IF function in Excel (nested queries)
Re: Average and If function
excel help
Excel Formula
Counting coloured cells
functions for drop down menu...
How to turn off the automatic date feature in Excel 2003
Countif Formula
Copy ranges and pasting in reverse order?
Separating the data in one column into two columns
Drop down menu
Excel Worksheet Sum Function
Can this be done?
Excel Links to files on network not updating
Frontline Systems Solver
Create formula with variables
Getpivotdata function error
Very quick q: a space causing a problem in GETPIVOTDATA
Re: Display a blank instead of a zero
Burglaries Analysis: Peak Day and Time
Copy of date formula
Re: Return target cell if its' answer is true.
Re: radom number generation HELP
Copy & Paste
SumProduct Counts Blank Results
How to filter data to show similar entries in a worksheet.
Prohibit Entering Data into a Cell
Extracting Data
Restore "deleted sheet" in workbook
show nothing if the cell is blank
show multiple occuring name in a column
External Link To Other Files
IF Ranges
Does date fall between two ranges?
Returning multiple values from a worksheet function
Automatically entering a date that does not change?
Re: Finding errors in formulaes
Formula not updating
How to convert a column to a string?
Number format problem in CSV files
Calculating and listing items over 20
using VB opening multi-excel files and searching for a string in them
Setting up quarterly dates
Creating List of Worksheet Tab Names from Function
Narrow range in Sumif formula
array formula not working
format cell reverts to previous format
scenario names
Pivot Table
Date Formula
Format for rounding to hundreds place
2000 vs 97 Formulae
Network User Name Link On Forms
IF Statements
Automatically resizing rows (or columns) in a worksheet
IF or Vlookup?
Re: SUMPRODUCT to calculate commissions
Clear cells from drop down list
Sum Question
Comparing separate worksheets
Re: Offset Problems
Execl Check Spell
Re: Finding ASCII value of a character
Re: Correlation Coefficients for 2nd & 3rd Order Curves
Formula or Function
combo box text
Multipule Lookups???
Cell won't calculate/does not include value
how to lookup and add numbers
Clear User Input
Average
Pivot Chart
Solving with Iteration
A lookup table to subtotal categories??
Re: Excel VBA-fixing cells
Re: Linking workbook cells with a UDF
RAND and RANDBETWEEN Workaround........An A Comment
"Global" search in a workbook
Excel function - Rounding currency
Matching column data in different worksheets
Excel - conditional formating
Opening an excel worksheet from Outlook
COUNTIF / SUMPRODUCT problem
Excel printing issue
Automatically updating function results
array formula nested in non-array formula
Adding based on cell location
Cell compare and based on the value change the cell background color
Limit to number of nested "IF" functions
Re: Auto Update remote references
count unique records
Finding blank cells with a formula.
Forcing Caps
COUNTIF in non-consecutive cells
Help with formula please
IF Function Multiple logical tests - Syntax
Help with VB Script Code
formatting worksheet tabs
Advanced Filtering
Access and Excel
Missing Excel Tabs
Graph Help
Counting items in one column based on another
ROUNDUP
Sum
Excel 2000
Automatically posting data from one worksheet to another based on specific criteria
Use of CELL and/or OFFSET functions with MAX function
adding column a if column b = X
Calculating time
Hiding data in an ExcelSheet
MAX
How to put sheets in alphabet order inside a workbook
Determine last entry in colum
Re: Greater than & Less than
Time convertion
lookup