Worksheet Functions [Archive] - Page 65

Conditional Validation - Using a "part-time" drop-down list
General Question
" "
date/time stamp
prevent more than one value in a cell
Search/lookup/cell reference
Need Excel Function that will return # of char in preceding cell
soduko
How to tell if cell contains a FORMULA or user-entered number?
Excel Analysis Add-in EOMONTH generates #NAME? error
how can convert 15 to Fifteen
filtering dates
AutoFill with Non-sequential Cell References ?
Copying into ranges
round up in own cell
how do you use the text function?
Dynamic reference to a sheet
Need help with reverse phone lookup
Fill down error for Vlookup
SUMIF Alternative?
Another rounding issue
how to set up one cell that assigns a value based on the value of another cell
How do I compare in between two worksheets?
CREATE LIST OBJECT IN EXCEL
Getting External data
SUMPRODUCT help
locking cells based on results at runtime
Checking for empty cells in a range
Filter Indicator on Column top should be white, not dark blue
Copying selected rows to another sheet
Hyperlink referencing
Creating a bar graph manually
automatic printing
How do I count two variables in different columns in excel?
Calculate 52 weeks
Brake & Move Columns
Sorting Account Numbers
Exce Hide / Unhide function
Countif for multiple criteria
i want to use the =if function to apply a colour to other cells
PRINT MORE THEN ONE WORKSHEET
Largest Value
Non zero weighted average
Formula syntax {;;;}
concatenating cells with their formats
Checking that any cells are null
&[Tab] is available as data in headers but not cells?
Underlines with autosum
have value in A1 & want value after 20 cells is it =a1+20 ????
Formulas dealing with text data
Compound Rate of Return
IF statement with lists and dropdowns
XIRR function
ytd sum by selecting month
Excell Workbook problem
Combo Box
Adding a fixed date to a cell
Links to 2nd closed worksheet fail when using offset function ??
Nested if
Delete rows if Col C has a 0 value in it.
Is there such a function?
How do you copy RANK w/o it changing the range?
Is there a (non-binary) "if x then enter y" forumula?
Random Name Generation
Averaging and Rounding problem
My formula won't work
Multi Criteria then sum
How to input additional text to multiple of existing cells that has text
OR & IF Functions Together
intellimouse
filename pointer
My formula does not work!
Why is XL lying to me??
More- AutoFill with Non-Seqeuntial Cell References ?
for each problem
Summing with multiple criteria
Currency format
getting name value in cell from If formula
EXCEL: FLOOR/SPACE RATIO CALCULATION
Lookup data from multiple sheets
Need help with RANK function
CHI SQUARE TEST
I NEED HELP with the SPELLNUMBER Function
Problem writing Excel formulas via ODBC
Need Help with an IndexMatch
formula to calculate the average of a range basing on condition
validation rule
How do you convert (change) a column into a row?
Problem with Frequency() formula
Function or formula needed
convert numbers to text.
Find first data
List Unique Occurences and Count
select records with a specific value
Out of Ideas, need help with Auto Fill
Formula to count number of days in range which are less than today
Rounding
Loosing Zeros
Date calculation
match multiple criteria & return value from array
i change a source and the other cells wont change
convert 500.00 to Five Hundred
add "0" to the beginning of each value
EXCEL
Indirect, Concatenate, & ?
Finding possible sums to match a figure
Macro to omit blank cells needed
Transfer A Row From Sheet 1 To 2
How to filter on a date field during mail merge
finding an answer
how can i test whether cell contains keyed constant or a formulae
How do I hide rows in excell 2003, and see the + sign to open?
remove a drop-down list
Using the IF function
Can this be done?
how do u copy a formula in over 100 cells and have it adjust
IF Functions
Need to Count number of occurrences and get percentage of total
how to merge 2 worksheets and highlight differences
summing up daily data in a monthly compilation
HOW DUPLICATE TEXT ON ALL PAGES OF WORKSHEET FROM ONE CELL
Pivot Tables
Sharing a workbook
CountIf function
if function that i dont get
HELP - Room booking spreadsheet hell
LookUp and Concatentate
How to sum the last 5 non-blank cells in a row?
Pivot Table
Conditional Lookup on Multiple Criteria
Simple formula help
Simple formula help
Sharing of one single Excel file/workbook
How to write a formula that will prevent appearance ERROR MESSAGE
countif
HOW DO I CORRECT A CONDITION IN WHICH ALL FORMULAS ACT LIKE TEXT?
skip blank rows when pasting formulas
Pulling my hair out, need some help building a formula
Copy Code Needed
Formula indicator in cells???
How do I get stock quotes in Excel without text?
count no. of entries in range for a day
Return a unique value
totaling difficulties
Insert Animated picture like GIF
VLOOKUP function
Attachments
Excel Function to Match Power Trendline in Chart?
Re: replace "#DIV/0!" error with blanks
=IF(TRIM(RIGHT(D4,1))="X",MID(D4,1,LEN(D4)-1),D4) ? remove error
If OR Vlookup???
Formating the text of a formula?
function to show if two fields in a column have the same data.
How do i unlock protected worksheets?
Array Formula, noncontigous range
How can i count pasted values in Excel?
RE: Roundup to the nearest number that is divisible by 3
Still could use help on a tough VLOOKUP
IF from a range of cells
Match and Concatenate ??
Help! Need Product: Feet/InchesXFeet/Inches=DoubleDecimal SQ.FT.
Problem with nested IF_OR statement
problem lookup function
Get aveages for last few days
How can I convert an 8 character Hex word to binary for a lookup?
How can i get autoformat name of range in excelsheet?
How do I setup criteria in DSUM to sum values NOT equal (<>)
Data from closed workbooks (pull func, indirect.ext, etc ....)
Compare List and Show Mismatched
Calculating starting balance
Comparing data on 2 workbooks
Prevent A Macro From Running If SpreadSheet is Filtered
countif question
Year-to-date return
Problem adding a range using Sumif function.
RIGHT of character
Lookup Match
Problems with PULL function, INDIRECT.EXT and so forth
Auto increment over multiple worksheets
format cell to capitlize
VLookup
Limit to the number of items in a cell
Hiding columns using a formula
Cond Format:re color 2 cols, skip 2 cols
SumIf based on two criteria
Need formula to count number of books sold
Extending a balance sheet
IF Function returns False instead of 0
I want to use if based on two cells (if... and)
Hyperlink-Programable replacement of Text with Its Actual Address
Pivot Tables
Appending excel worksheets
Find min/max in 2 combined columns
Function to find row with most current date
Lookup help needed
Is there a template for creating outline in Excel as opposed to W
Counting Across Multiple Ranges, Based on Condition
Array Function Question
Compare 2 columns & format row
Adding cells based on condition
Converting a link to values to multiple cells.
Improve visibility of Excel AutoFilter Filter selections
IF function
format cell to recall client name
conditional formatting
Cell Calculations
Worksheet e-mailing
How to dynamically reference a dynamic named range
how do i MAX to display the person who got MAX
left click on a cell and more cells are highlighted
Another of Excel's idiosyncrasis
Semi transparent chart fill
HOW DO YOU CREATE DROP DOWEN MENUS IN EXCEL?
Sorting dates
Help creating single cell Pop-up
Matching Date From Two Groups
julian dates in Exel
Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number)
How to match sort and lineup 2 sets of data
Ref from table - complete
Re: How do I caluclate an Annual Percentage Rate in Excel?
How do I allow users to make a choice in a worksheet?
How do I calculate APR for interest-only loans
I need to return the name of a worksheet in another worksheet cell?
Help with Excel Macro.
Display count of rows
Autoexec Macro
How to setup a hyperlink to an indirect function?
Sumif where sum range is more than one column?
Problem with function "Worksheet_Change"
How to represent an empty cell in excel formulae?
Conditional Format to highlight blank cell
Setting a reminder up
COUNT IF NOT EQUAL TO ZERO
"E" for even numbers. "O" for odd numbers.
Help with Formulas please!!!
not equal to zero
Trend Forecast Help
The ROUND function
lists and validation
Moving formulas
If (cell a2 is greater than 1, but less than B2 - C2, "X") how do
calculating hours
Excell linked to outlook contacts
How can I make a cell mandatory and only accept a Y or N?
need Excel function like INDIRECT but can't open all spreadsheets
Result in Cell is Wrong
Dynamic Formula?
Control Toolbox
IF Function