Excel Worksheet Functions [Archive]

Searching a string of text and displaying it's corresponding value
fire a macro if a cell gets a value > 0
Search 1 sheet for 4 or 5, copy that row and paste to another sheet
Simple Inventory sheet
[SOLVED] Match Function Error
Fill Down based on Sheet2
[SOLVED] cleaning cells..!
[SOLVED] How To Set a Range?
Extract Picture from Excel cell Comment, and add to VBA Control
copy html in clipboard as txt
using array formula correctly
Multiple Search Results of Multiple Criteria
Find the duplicated items for same Customers
Solving a duplicate output problem
formula
Comparing Columns to see if a new item has been added then insert new row and item
Multiplying multiple numbers in cells for 1 total.
IF only working in two cells
Changes in worksheet
Subtraction with only 5 Digits (Maybe MOD Function)
[SOLVED] Count,Sort - Formatting Problem?
Input data into Word through Excel
Comparing values in the same cell
[SOLVED] Addition with only 5 Digits
Excel VBA code HELP
[SOLVED] Possible Function? Moving Cell Contents.
Using BIDMAS, incorrect values.
[SOLVED] Looking up information from table
Display 600 without the zeros
HLookup formula
Excel Formula
Can't concatenate a cell address
"Unable to set FormulaArry property of the range class" - Error
formula from 3 fields
help optimising VBA macro to move and sort data for use in validation lists
[SOLVED] IF formula with multiple variables
Index and Vlookup?
Help with copying data from one file to another via a link
[SOLVED] Formula Does Not Copy, Previous Calculation Result Does
Return a percentage of amount of values in column
getting the number format of a column
IF statement for text
Inverse of Address Function
MID formula, try to solve #VALUE! error
[SOLVED] Labeling pairs of numbers PART 2
Need help Copy data from workbook1 to workbook 2 + 1 cell changing number on open
Custom function problem
Range VBA function have a way to identify cell co-ordinates
updating value in a range of cells
[SOLVED] Dragging Hyperlinks
Paste special using an array
[SOLVED] MATCH taking more then 1 cell of information
[SOLVED] copy based off another cell
Algebraic Formula
Sum across sheets using row and column criteria
Using a column in If Else statement
[SOLVED] Converting text-formatted dates into months
Extracting number from text
Modify Which Statistic is Performed with Drop-down
Remove HTML
[SOLVED] VLookup with refference from 2 different tables
Strikethrough cells with same Values
Grouping data in Excel using C#
Reference current date with desired number
[SOLVED] Categorize combinations of numbers-Lowest Median Highest
If function to separate the days from a date field
[SOLVED] List Summary from Series of Tabs
Please Help, Very simple for Experts
Return column of data by selecting index value from drop down list
switching work sheets within a workbook
Why no apostrophe before 0
[SOLVED] Update data but keep pivot table formatting
[SOLVED] Name for "the same" IN FORMULA
Same cell format, different hours value.
[SOLVED] Match/Return formula
Excel formula help please
[SOLVED] 0 as first number out of 3 numbers in a column
[SOLVED] Using the MAX function
[SOLVED] counting text in one column against a list of text in another.
=concatenate w/o assigning indv. cells
Extract the value of a cell without a cell reference
AutoFill method of range class error '1004' -excel 2003
search values "between" through macro
Formula referencing multiple columns
[SOLVED] Formula with 2 cell values, One value is a date
IF and AND fuction together
[SOLVED] fill in missing years in a range
Identifying decimal values > zero
Find value in one column, display the text from adjacent colomn
Removing all toolbar in Office 2007 using VBA
Pulling Data from unopened Excel Spreadsheets with external connections
[SOLVED] split cell contents
Compare if a day falls between 2 dates
Maximum value from a list of numbers and numbers with asterisks.
[SOLVED] Is there a fromula to clear a cell if any expecific txt is written?
copying from one row and deleting the other row
Using VLOOKUP instead of Nested IF Functions
Adding Data Validation Values
Merge & Center Macro Button
Cells.find to look for more than one value
[SOLVED] Webscawler, -spider
[SOLVED] Replace Cell Ref with its Name
Chain linking matrix multiplication function
[SOLVED] How to Sort Alphanumeric values
A series of weighted variables for a percentage ranking
formula not auto-computing
[SOLVED] Counting cells conditional on neighbouring columns
[SOLVED] Is there a way to update the pivot table as data is added to the original worksheet?
[SOLVED] labeling pairs of numbers
find function with a relative range
Error: Script to import large .txt file into Excel 2000
[SOLVED] Simplify Index Function
[SOLVED] Percentrank function problem
Embedded if statement not returning the catch all if false
[SOLVED] Sum values based on multiple criteria (comma delimited) in a single cell
Display specific entries in worksheet
Deleting Zero Rows
Want to easily change my polynomial trendline using linest
[SOLVED] Rearrange numbers
MAX Formulas and IF<> senarios
[SOLVED] Lookup and report Missing digits
Combining two IF arguments
[SOLVED] Work Out If Finish Date/Time is Late - Excel 2003
Find or Index - Doc Revision
Show input history
filtering and lookup
How to create this 01010101 array on the fly
Vlookup & Hlookup combining separate workboo
convert NetWorkDays to VBA
IF Statements
[SOLVED] can a vlookup return multiple values and how
Counting how many cells are greater than 0 on several worksheets
Can't Right Click
[SOLVED] Enter Today() in specified row
Time calculations
[SOLVED] Data Count
[SOLVED] Return Blank instead of $0.00 in sumifs
Add data labels to a barchart ONLY for items that are greater than #?
Text Mode Formula?
Conditional Formatting for Multiple Values
[SOLVED] Match Index
[SOLVED] Showing available times on staff rota
Create formula with multiple values.
put a value in a cell and increment surrounding cells
Music Note names and text
CountIf blank with two columns
[SOLVED] SUM then add 10 if 20
[SOLVED] Adding together two digits in a cell
Sum with Multi Criteria in Multi Column
totalling staff timesheets
[SOLVED] input and display data in cell in h:mm format without changing to time
Macro to Fire on Worksheet Selected
Formula Fails to Choose() From Name Range & Results To #Div/0
[SOLVED] Calculating totals from a date range on a rolling calendar year?
[SOLVED] VB Macro, FOR loop with conditional formatting
Extract and transpose data
[SOLVED] Sum categories at each change in value
[SOLVED] Generate three different results from one list
Moving Range Problem
Data Lookup from offline book with a formula
[SOLVED] how to stop cut and paste from wrecking my array formulas
[SOLVED] Search for text
[SOLVED] unique records and summing quantites
initial investment
Copying Multiple Cells in VB
help with an IF formula please
Hourlist and VBA isblank with offset to determine days.
[SOLVED] Rank based on score
[SOLVED] Making Data Permanent
Averaging the named values listed in another cell
[SOLVED] Summing cells which only have Strikethrough
Unhide / Hide Rows Based on Cell Value
[SOLVED] Concatenate TODAY() function
merge monthly data from multiple workbooks
[SOLVED] IF(ISBlank with Vlookup
[SOLVED] Duplicate data in column
[SOLVED] a formula to extend series
Match formula
IF Formula
Macro for Multiple Users
Vlookup Macro
Formula for calculating largest square to fit in a quadrilateral
Excel SUM Formula
[SOLVED] If? Iferror?
[SOLVED] How to show start and end of data ranges?
Today() and arrays
Sum Ranges in List
If help
Conditional Formatting
Bartlett's Test and Mann's Test
VLookup
Consolidate multiple rows of data
Formula to Arrange number's position
Calculating Service Hour
Formula to find matching number(s) position
Formula to find position of matching number
[SOLVED] Formula to find matching number
LOOKUP or IF formula ?
Formula from last entry in row
Using If/Then/Else statements with ranges of data
[SOLVED] How to find the first cell in a row with a date
Editing Excel Workbook Connections to Web
[SOLVED] Add or subtract from total
Freeze cells
formula to copy a row to another spreadsheet based on a single condition
Holidays and Networkdays
Select particular column
Conditionally apply a math equation to cell
[SOLVED] Count unique records for a specific date
[SOLVED] Conditional Formatting based on Now formula
[SOLVED] VLookup, Named Ranges and IF
Index Function
Workbook Links
Shift data into empty cells?
For n rows, determine if sum of column values matches criterion
[SOLVED] Excel function to visualize cell reference
[SOLVED] date conversion
Lookup a total from a range to use as part of a formula
formula to change ie 1995 - 1997 to 1995, 1996, 1997
[SOLVED] Determining variable on the basis of given values
Adding a start and finish date to a function counting no. of specific days in month
Using a cell value as a range name
[SOLVED] VLookup and Named Ranges
Return a value based on multiple criteria
Function to detect use of a function?
[SOLVED] End of Quarter Function
[SOLVED] Vlookup
[SOLVED] Vlookup Help
[SOLVED] combining formulas in a cell and concatenate
Populate cell with not previously chosen option among 2 possible options...
Copy certain cols from sheet1 to sheet2
Sort between Excel Sheets with locked cells
Nested lookup function
[SOLVED] average of lowest 3 of 5 scores >0
Comparing values from different sheets and inserting value from same row
SUMIF function
Combining Worksheet Data (macro)
[SOLVED] Sum for defined column
[SOLVED] Filtering Data Validation based on other cell value
[SOLVED] Multiple Sum Formula With Multiple Constraints
[SOLVED] Auto Populate
[SOLVED] Match and Index
[SOLVED] Countifs formula
If/index formula help
Pop Up Message !
[SOLVED] if statement using left and right conditions
[SOLVED] Formula Too Long
Text Formulae
[SOLVED] vlookup in descending order
Permutations calculation for test variations