Search Results for "Array Formula"
591 results were found in the following tip categories:
Excel Keyboard Shortcuts
- The Best Shortcut Keys in Microsoft Excel
- Combining Text from Different Cells
- Shortcuts to see the Help for the Syntax Function in Microsoft Excel
- Opening a Linked Workbook in Microsoft Excel
- Opening/Closing a Workbook(s)
Keyboard Formula Shortcuts
- Joining text using formula in Microsoft Excel
- Inserting/Editing Formulas
- Shortcuts to see the Help for the Syntax Function in Microsoft Excel
- Selecting cells that only contain Text in Microsoft Excel
- Applying Formatting Only to Cells Containing Text
- Calculate number of minutes between dates - time in Microsoft Excel
- Working Out a Person's Age in Microsoft Excel
Excel Data
Excel Time
- Entering the Current Time into a Cell
- Calculating the Difference Between Hours
- Rounding Hours Up
- Converting a Number to a Time Value
- Calculating Time Differences Between Regions of the World
- Calculate number of minutes between dates - time in Microsoft Excel
- Unnecessary Blank Characters in Cells in Excel 2007
- The Minus Sign Appears to the Right of the Number in Excel 2007
- Set background color depending on value verification using VBA in Microsoft Excel
- Open data in two dimensional array and save in sheet using VBA in Microsoft Excel
- Generate total for dynamic area using VBA in Microsoft Excel
- Convert negative values treated as text using VBA in Microsoft Excel
- Private Profile Strings using INI-files using VBA in Microsoft Excel
- Private Profile Strings using the Registry using VBA in Microsoft Excel
- Array variables using VBA in Microsoft Excel
- Display all installed fonts (Excel) using VBA in Microsoft Excel
Excel General
Working with Formulas
- Changing an Absolute Reference to a Relative Reference or Vice Versa
- Copying a Formula from a Cell While Keeping the Absolute Reference or Relative Reference
- Nesting Formulas
- Copying Formulas and Pasting Them in a Transposed Direction Without Changing the Relative References
- Moving Between Precedent and Dependent Cells
- Stepping into a Formula
- Avoiding Error Displays when Formulas Return Result Calculations
- Selecting/Formatting Cells Containing Errors
- Tracing Errors in Formula Results
- Circular References
- Pasting Values
- Formatting Cells Containing Formulas
- Displaying Formula Syntax
- Printing Formula Syntax
- Multiplying a Range by -1 in One Operation
- Performing a Quick Calculation in the Formula Bar
- Coloring One Record in Each Group in a Range
- Return the cell reference as text in Microsoft Excel
- Create a hyperlink from a string in Microsoft Excel
- Sum total stock value for any part in Microsoft Excel
- The Power Combination
- Validating Text Entries
- Preventing Duplicates While Entering Data
- Validating text entries in Microsoft Excel
- Copying and Pasting Validation list only in Microsoft Excel
- Manually Wrapping Text in a Cell
- Dividing a First Left Heading Title
- Combining Text and Formatted Values
- Combining Text and a Formatted Date
- Separating First and Last Names Using Formulas
- Entering the Current Date into a Cell
- Quickly Typing Dates into Cells
- Linking a Cell to a Text Box
- Add space between characters and numbers in Microsoft Excel
- Validating Text Entries in Excel 2007
- Preventing Duplicates While Entering Data in Excel 2007
- Protecting Cells Containing Formulas in an Unprotected Sheet in Excel 2007
- Use listboxes with multiple choices using VBA in Microsoft Excel
- List files in a folder with Microsoft Scripting Runtime using VBA in Microsoft Excel
- List files in a folder with Office 97 or later using VBA in Microsoft Excel
- Read information from a closed workbook using VBA in Microsoft Excel
- Add special symbols to the number format
- Format number in joining text with linked number in Microsoft Excel
- Adding special symbols to the number format in Microsoft Excel
- Adding Euro format to the number format in Microsoft Excel
- Applying colors to Subtotal rows according to the Subtotal level in Microsoft Excel
- Coloring Rows Based on Text Criteria
- Applying Colors to Maximum/Minimum Values in a List
- Coloring Even Numbered Rows in a List
- Inserting Special Symbols into Custom Formats
- Add a fancy line for Presentation
- Format even numbers
- Manually Wrapping Text in a Cell in Excel 2007
- Dividing a First Left Heading Title in Excel 2007
- Applying Formatting to Cells Containing Text Only in Excel 2007
- Color Unique Record in a Range in Excel 2007
Links between Worksheet and Workbooks
Excel Sorting
Summing
- Summing Rounded Numbers
- Fast Summation
- Summing values in vertical and horizontal ranges in Microsoft Excel
- Inserting Subtotals Quickly
- Extending the Range of the SUM Formula
- Summing Values at the Intersection of Two or more Ranges
- Summing data from a cell in a number of sheets in Microsoft Excel
- The SUMIF Formula – Using Comparison Operators ( ) as Criteria
- Totaling Two Ranges Using the SUMIF Formula
- Summing Using Text Characters as Criteria
- Summarize data according to criteria from the data table using Sumif formula, Offset formula and Combo Box in Microsoft Excel
- Summing a range containing errors and values in Microsoft Excel
- Summing using multiple criteria in Microsoft Excel
- Sum the largest two numbers in range in Microsoft Excel
- Summing Values from Cells in Different Sheets
- Summing Stock Lists
- Simplifying complicated multiplication calculations using the SUMPRODUCT function
- Using multiple criteria in SUMIF Function
- Avoiding the #VALUE! Error When Adding Cells That May Contain Blanks
- Summing Values from Two Ranges, Based on Two Criteria
- Summing matching values in multiple rows
- Summing Values from a List Containing Numerical and Textual Substrings
- Summing Annual Expenses by Respective Quarters
- Summing Values in a Range Containing Redundant Spaces
- Summing Values Based on the Criteria of a Non-Empty Adjacent Cell
- Summing A Dynamic Range of Numbers According To Criteria
- Summing Values In a Range Specified By Indirect Cell References
- Summing the Number of Hours an Employee Worked During a Two Week Period
- Separating Positive and Negative numbers and add Running Balance column
- Reversing The Order Of Values In A List
- Rounding Numbers that Meet Specified Criteria
- Ranking Numbers in a Dynamic List
- Counting the number of cells containing a substring
- Sum Total Sales Except for One Specified Item
- Dividing an Amount into Equal Payments While Avoiding Division / Rounding Errors
- Counting the Number of Values between Two Specified Values in a List
- Counting Rows that Match Specific Criteria for Each Column
- Retrieving Unique Values From A List
- Retrieving Every nth Value In a Range
- Finding Minimum / Maximum Values
- Avoiding Errors When Counting Date Values That Meet Specified Criteria
- Preventing a Vlookup Function From Returning an Error When an Exact Match Is Not Found
- Simplifying Formulas by Reducing the Complexity of IF Functions
- Calculating the Average of Every Nth Value
- Counting the Number of Values Between Upper and Lower Limits
- Finding the Largest Value from Two Different Lists, Subject to Specified Criteria
- Indicators for the maximal and minimal values
- Creating Formulas that Only Return Results from Non-Blank Cells
- Calculating the Average for Numbers Meeting Specified Criteria
- Checking For Duplicate Values Within A Range
- Retrieving an Item from a List that Meets Multiple Criteria
- Performing calculations based on multiple criteria, using SUMPRODUCT function
- Retrieving the Value of the First Nonblank Cell in a List
- Retrieving From List By Position
- Calculating an Average, Only Including Prices on Which There Was no Discount
- Nesting OR and AND Functions to Meet Multiple Criteria
- Ranking Salespeople According To Sales Figure
- Retrieving the Closest Larger and Closest Smaller Values from a List When There Is No Exact Match
- Finding the Largest Number among Those Meeting Specified Criteria
- Counting Rows of Even Numbers in Two Parallel Ranges
- Disregarding blank cells when performing calculations on a range.
- Ignoring Blank Cells Containing Invisible Spaces when Using Array Formulas
- Summing How Many Points Scored by a Specified Team in Specified Games
- Counting the Number of Players According to Their Score in a Particular Quarter
- Correcting Formatting Errors
- Rounding the Calculation of Retail Price and Sales Tax
- Counting the Number of Students who Answered "A" to the Second Question
- Checking For Sequences Within A Sorted List
- Extracting last Word
- Validating Data To Be Unique In A Range
- Random Selection from a List
- Avoiding #DIV/0! Errors when Dividing by Zero
- Ignoring #DIV/0! Errors when Performing Calculations
- Eliminating Errors Resulting from If Functions with Multiple Conditions
- Avoiding Errors when Counting Date Values that Meet Specified Criteria
- Avoiding Errors when Subtracting Times
- Preventing a VLOOKUP Function from Returning an Error when an Exact Match is Not Found
- Using a VLOOKUP Formula to Check If a Value Exists
- Checking If Matching Numbers Exist in Different Ranges
- Sorting Numbers in Ascending or Descending Order
- Sorting Numbers Based on Their Frequency within a List
- Reversing the Order of Values in a List
- Shuffling a List of Values
- Retrieving Unique Values from a List
- Retrieving List Values that Do Not Appear in a Second List
- Retrieving Values that are Common to Two Lists
- Creating a List of All Non-Blank Cells in a Column
- Retrieving Values from a List that are Greater than a Specified Number
- Checking for Sequences within a Sorted List
- Checking for Duplicate Values within a Range
- Identifying Duplicate Rows within a Range
- Determining and Indicating the Number of Times Each Value Has Been Entered in a List
- Transposing an Entire Range of Data into a Single Column
- Transposing a Column into Successive Rows of a Specified Length
- Transposing a Range in Ascending Order
- Transposing Values from Columns into Rows, and Vice Versa
- Calculating Average Annual Growth
- Calculating the Average Growth of a Child
- Finding Specified Items in a List and Averaging their Associated Values
- Excluding Exceptional Values when Calculating an Average
- Averaging Values that Correspond with the X Largest Values in a Dynamic Range
- Calculating the Average of a Range of Numbers, Excluding the Minimal Value
- Calculating the Lowest Common Multiple (LCM)
- Rounding Up / Down to the Nearest Multiple of a Specific Number
- Rounding a Value to Make It Divisible by a Specified Number
- Ranking a List of Numbers
- Calculating Commissions Based on Sales Rank
- Selecting a Set of Random Numbers, Avoiding Duplicates
- Adjusting Values Returned by the RAND Function
- Randomly Selecting a Value from a Range
- Calculating Net Sale Price According to Text Criteria
- Calculating the Proportion of Characters from One String that Appears in another String
- Calculating the Remaining Credit after Each Purchase
- Calculating Total Annual Payment Based on Cumulative Monthly Payments
- Placing the Previous Payment Date beside Each Pay Date in a List
- Restricting the Automatic Recalculation of Volatile Functions
- Calculating the Percentage of Cells in a Range that Contain a Specified String
- Calculating the Absolute Difference between Each List Value and the Minimum Value in the List
- Determining Divisibility
- Multiplying Values from Two Matrixes that Occupy Corresponding Addresses
- Converting Decimal Fractions to Fractions of a Specified Number
- Simplifying Formulas by Defining Names for Often-Repeated Parts
- Calculating Total Income Tax
- Inserting/Editing Formulas in Excel 2007
- Nesting Formulas in Excel 2007
- Changing an Absolute Reference to a Relative Reference or Vice Versa in Excel 2007
- Copying a Formula from a Cell While Keeping the Reference in Excel 2007
- Copying Formulas and Pasting Them in a Transposed Direction without Changing the Relative References in Excel 2007
- Pasting Values in Excel 2007
- Displaying Formula Syntax in Excel 2007
- Printing Formula Syntax in Excel 2007
- Displaying Formulas and Values of the Same Cells in Excel 2007
- Stepping into a Formula in Excel 2007
- Moving Between Precedent and Dependent Cells in Excel 2007
- Circular References in Excel 2007
- Iteration in Excel 2007
- Tracing Errors in Formula Results in Excel 2007
- Use Name in a Formula in Excel 2007
- Saving a Frequently Used Formula/Numeric Value in the Name, Refers to Box in Excel 2007
- Automatically Updating a Range Name Reference in Excel 2007
- IFERROR Function - New Function in Excel 2007
Excel Tools
Cells, Ranges, Rows, and Columns in VBA
- Compare two worksheet ranges using VBA in Microsoft Excel
- Compare two worksheets using VBA in Microsoft Excel
- Automating the Insertion of the Euro Symbol
- Use AutoCorrect to enter special symbols in Microsoft Excel
- Counting the Number of Cells Containing Text in a Range
- Comparing Lists Using the COUNTIF Formula
- COUNT Formulas
- Count the number of cells in a range containing all types of Errors in Microsoft Excel
- Count how many numbers are in series of numbers when a certain criteria is set in Microsoft Excel
- Count the number of values between a lower and upper limit in Microsoft Excel
- Count the number of times dates in certain month appears in range in Microsoft Excel
- Counting the Number of Items Sold Every Half Hour
- Counting Unique Numeric Values or Unique Data in a List
- Creating Progressively Incremented Counting Criteria
- Counting the Values that Match Criteria in a Filtered List
- Creating a Summary Table of a Student Questionnaire
- Counting the Number of YES Responses in a Student Questionnaire
- Counting Unique "X" and "O" Occurrences in a Matrix
- Creating a Counting Grid
- Applying colors to Subtotal rows according to the Subtotal level in Microsoft Excel
- Applying Colors to Subtotal Rows
- Coloring Two Subtotal Levels in Different Colors
- Applying Colors to Subtotal Rows in Excel 2007
- Coloring Subtotal Levels in Different Colors in Excel 2007
- Array Formulas – the Technical Side
- Counting Based on Multiple Criteria
- Count the number of cells in a range containing all types of Errors in Microsoft Excel
- Find the maximum numerical value in a list based on a criteria in Microsoft Excel
- Find the minimum positive value in Microsoft Excel
- Find the minimum numerical value in a list based on a criteria in Microsoft Excel
- Count the number of times dates in certain month appears in range in Microsoft Excel
- Simplifying Formulas by Reducing the Complexity of IF Functions
- Calculating the Average Difference between List Price and Sale Price
- Counting the Number of Combined First and Last Names Matching Criteria in a Dynamic Range
- Ignoring Blank Cells when Performing Calculations
- Checking for the Presence of Specified Values Within a Range
- Finding the Score that Was the Nth Highest for a Specified Team
- Calculating the Average Value in Every Nth Column, Excluding Zeros
- Rounding Time Intervals to the Nearest Specified Time Increment
- Array Formulas in Excel 2007
- Decide what an INPUTBOX is supposed to return using VBA in Microsoft Excel
- Fill a ListBox with unique values from a worksheet using VBA in Microsoft Excel
- Fill a ListBox-control with values from another workbook using VBA in Microsoft Excel
Excel Worksheet, Workbook
- Quickly Selecting a Range in the Workbook
- Create a hyperlink from a string in Microsoft Excel
- Recovering Data from a Corrupted Workbook That Cannot Be Opened
- Opening/Closing a Workbook(s) in Excel 2007
- Recovering Data from a Corrupted Workbook That Cannot Be Opened in Excel 2007
- Using a Range Name in a Formula
- Saving a Frequently Used Formula/Numeric Value in the Define Name Dialog Box
- Automatically Updating a Range Name Reference
- Calculating the Quarter Number
- Add space between characters and numbers in Microsoft Excel
- Forecasting Daily Budget
- Ignoring Blank Cells when Performing Calculations
- Avoiding the #VALUE! Error when Adding Cells that May Contain Blanks
- Watch Calculation Results Immediately in Excel 2007
Excel Summing
- Summing Values from Different Sheets for the Same Cell Address
- Creating a Summing Formula that Automatically Adjusts to a Dynamic Range
- Summing the Absolute Values of All Numbers in a Range
- Summing Subtotals Only from Range
- Modifying a SUMPRODUCT function to Return a Sum Rather than a Count
- Summing Rounded Numbers
- Summing Numerical Substrings
- Summing Values Using Indirect Cell References
- Summing Across Multiple Sheets
- Summing from Closed Workbooks
- Summing Corresponding Values in Multiple Columns
- Summing Sales Amounts According to Product Category and Customer Name
- Summing Total Sales, Based on Quantity & Price
- Summing How Many Points Scored by a Specified Team in Specified Games
- Summing Expenses Accumulated to a Specified Month
- Calculating Monthly and Accumulated Income, Based on Specified Month
- Summing Groups of Every N Values in a Row
- Summing the Last N Values in a Column
- Summing the N Largest Values in a Range
- Creating a List in which Each Number is the Sum of the Previous N Numbers
- Fast Summation in Excel 2007
- Counting Values that Appear Only Once in
- Counting the Number of Times a Specified Substring Appears within a Range of Strings
- Counting the Number of Cells Containing Text
- Counting the Number of Cells Containing Text
- Counting the Number of Times a Substring Appears Within a String
- Counting the Number of Strings which Contain Numbers Meeting Criteria
- Counting Date Values by Specified Date Criteria
- Counting the Number of Dates with Matching Month Criteria
- Counting Time Values in Terms of Hourly Increments
- Counting the Number of Values Meeting Criteria, but Only for Every 3rd Cell in a Range
- Counting the Number of Values from Multiple Worksheets that Match Criteria
- Counting the Number of Unique Items Sold by Each Salesperson
- Using Date & Time Criteria to Count Entries in a Combined Date & Time List
- Counting the Number of Times Any of the Numbers in First List Appears within Second List
- Create a Custom Function
- Add cells in a range from all worksheets in the workbook using VBA in Microsoft Excel
- Add values from the previous or next worksheet using VBA in Microsoft Excel
- Count cells in a range from all worksheets using VBA in Microsoft Excel
- Weeknumbers using VBA in Microsoft Excel
- Look up unique values using VBA in Microsoft Excel
- Return every n-th item using VBA in Microsoft Excel
- Return random numbers using VBA in Microsoft Excel
- Worksheet functions in VBA macros using VBA in Microsoft Excel
Excel Pivot Tables
- Adding a Running Balance Calculation Column
- Retrieving Data from a PivotTable Report
- Adding/Deleting Subtotals
- PivotTable report - Adding a Calculated Field
- PivotTable report - Grouping the Date Field by Week Number
- PivotTable report - Grouping the Date Field by Quarters in a Fiscal Reporting Year
- PivotTable report - Adding a Data Field That Calculates the Difference Between Two Data Fields
- Show/Hide Subtotals in Excel 2007
- Grouping a Date Field by Quarters in a Fiscal Reporting Year in Excel 2007
- Inserting a Calculated Field in Excel 2007
- Inserting a Field that Calculates the Difference between Two Fields in Excel 2007
- Protecting the Sheet or the Cells in the Sheet
- Protecting Sheets / Cells in Microsoft Excel
- Limiting the Movement in a Protected Sheet
- Protecting Cells Containing Formulas in an Unprotected Sheet
- Formulas to calculate Loan payments in Microsoft Excel
- Create an Amortization Schedule in Microsoft Excel
- Rounding Numerical Substrings
- Averaging Sales Totals by Day of the Week
- Creating a Dynamic Inventory List Based on Daily Sales
- Calculating Canadian Mortgage Payments
- Conditional formatting depending on a cell comment using VBA in Microsoft Excel
- Add cells in a range from all worksheets in the workbook using VBA in Microsoft Excel
- Add values from the previous or next worksheet using VBA in Microsoft Excel
- Count cells in a range from all worksheets using VBA in Microsoft Excel
- Weeknumbers using VBA in Microsoft Excel
- Look up unique values using VBA in Microsoft Excel
- Return every n-th item using VBA in Microsoft Excel
- Return random numbers using VBA in Microsoft Excel
- Worksheet functions in VBA macros using VBA in Microsoft Excel
- Identifying and selecting the print area in a sheet in Microsoft Excel
- Hiding Errors in Cells Before Printing
Excel Date & Time Formulas
- Calculate Years, Months, Days elapsed from a certain date in Microsoft Excel
- Convert time to a serial value in Microsoft Excel
- Adding Time Values from Separate Hours and Minutes Columns
- Calculating Total Time Worked on a Specific Day
- Adding a Number to a Formatted Time Value
- Separating First and Last Names
- Finding the maximum value of all those meeting a certain criteria.
- Converting Time Values from One Time Zone to Another
- Calculating the Number of Business Days in a Specified Period
- Calculating the Number of Weekday Hours Between Two Dates
- Avoiding Errors When Subtracting Times
- Calculating the Week Number Corresponding with a Specific Date
- Calculating Hours Worked
- Calculating Absolute Difference between Two Time Values
- Entering Dates Quickly
- Calculating Number of Days, Weeks, Months and Years between Dates
- Calculating a Date Based on Year, Week Number and Day of the Week
- Finding the Last Day of a Given Month
- Calculating the Number of Business Days in a Specified Period
- Calculating a Project's End Date
- Calculating a Required Date According to Two Criteria
- Indicating Due Payments, Based on the Current Date
- Calculating the Date of the Nth Specific Day of the Month
- Eliminating Negative Values from Date Subtractions
- Avoiding Negative Values when Calculating the Number of Days between Two Dates
- Avoiding False Results when Counting Dates Matching Specified Criteria
- Calculating the Week Number Corresponding with a Specific Date
- Determining whether Two Given Dates Occur within the Same Week
- Finding the Number of Days in a Given Month
- Finding the Serial Number of the Last Day of the Month
- Adding a Specified Number of Months to a Date
- Converting a Month's Serial Number into Its Corresponding Name
- Calculating the Quarter Number for Calendar and Fiscal Year
- Converting a Date into a String, Indicating the Quarter Number and Year
- Determining Which Quarter a Specified Date Corresponds With
- Converting Older Dates to the Current Year
- Converting a Julian Date to a Calendar Date
- Entering Times Quickly
- Entering Times Quickly
- Adding Time Values
- Adding Text Values Representing Time
- Adding Time Values from Separate Hours and Minutes Columns
- Adding a Number to a Formatted Time Value
- Subtracting Times
- Converting Text Representing Minutes and Seconds into Numerical Values
- Converting Times to Decimal Values
- Calculating Military Time Intervals
- Converting Time Values from One Time Zone to Another
- Creating a World Time Converter
- Rounding Times Down to the Nearest 30 Seconds
- Rounding Times Down to a Specified Time Increment
- Rounding Hours Up
- Calculating a Building's Occupancy Rate at Specified Times
- Creating Date and Time Stamp
- Convert Date and Time from GMT (Greenwich Mean Time) to CST (Central Standard Time)
- Combining Data from Separate Columns into a Single Date and Time Value
- Converting Text, Which Represents Date and Time, Into Proper Date and Time Values
- Calculating the Number of Weekday Hours between Two Dates
- Separating Dates and Times
- Creating a Date and Time Matrix
- Creating a Timesheet
- Finding the First Login and Last Logout Times of Employees
- Calculating Total Time Worked on a
- Calculating the Number of Hours Worked Based on a System of Letter Codes
- Calculating Total Pay, Based on Hours Worked Per Day and Hourly Rates
- Calculating Daily Pay, Incorporating Variable Hourly Rates
- Determining Whether a Person Worked a Full or Partial Shift
- Determining Whether a Worked Shift Was Morning, Afternoon or Night
- Counting the Number of Shifts in a Specified Week that an Employee Worked Overtime
- Calculating the Number of Hours per Month, Allowing for Daylight-Saving Shifts
- Counting Vacation or Sick Days within a Specified Time Period
- Calculating Hourly Productivity
- Avoiding Errors when Using the And Function to Combine Multiple Conditions in Array Formulas
- Autoexpanding a Date Type Chart using Microsoft Excel
- Copying a series from one chart to another in Microsoft Excel
- Combine the VLookup and Match formulas in Microsoft Excel
- Combine the Index and Match formulas in Microsoft Excel
- Vlookup Formula – Organizing the Data Table
- Vlookup Formula – Eliminating Errors
- Index Formula vs. Vlookup Formula
- Retrieve information from a range in another Excel File when the Path & File Name strings stored in various cells.
- Using VLOOKUP and ISNA functions to find matching values in different sheets
- Retrieving a Price Value By Looking at Two Difference Data Tables
- Retrieving an Item from a List that Meets Multiple Criteria
- Retrieving A Value From A Reference Grid, Using Indexes Listed In Another Range
- Retrieving Sale Price Based On Item And Color Criteria
- Retrieving Values Using Range Names as References
- Retrieving Values Using References Based on Row and Column Numbers
- Retrieving Each Second Number from Two Lists
- Retrieving Values Using Range Names as References
- Retrieving Values Using Range Names as References
- Retrieving Values from Different Sheets Using the Sheet Name as a Reference
- Retrieving Values from another Sheet Using Date as Sheet Name Reference
- Retrieving a Specific Cell from Multiple Sheets
- Retrieving Values from another Excel Workbook Using Text References
- Retrieving the Price for a Specified Item and a Specified Brand
- Retrieving from List by Position
- Ranking Salespeople According to Sales Figure
- Retrieving the Player Who Scored the Highest Number of Points
- Retrieving File Name by Matching a Given Page Number in a Book
- Retrieving Grade Value for Corresponding Mark
- Retrieving the Most Frequent Occurrence for Each Category
- Retrieving the Last Value and the Last Character in a Row
- Retrieving the Last Value in a Dynamic List
- Retrieving the Value of the First Non-Blank Cell in a List
- Retrieving the Most Recent Payment Made by Client
- Retrieving the Closest Larger / Closest Smaller Values from a List when there is No Exact Match
- Retrieving the First Value in a List that is Greater / Smaller than a Specified Number
- Finding the Maximal / Minimal String, Based on Alphabetic Order
- Retrieve Value Using Case-Sensitive Lookups
- Retrieving the Minimal / Maximal Values from a Filtered List
- Retrieving Smallest Nth Value Match Within a List
- Finding Every Third Number and Returning the Largest of Them
- Retrieving the Nth Value in a Row / Column
- Retrieving Every Nth Value in a Range
- Retrieve the Distance between Any Two Cities from Distance Table
- Retrieving Matching Values From Not Adjacent List
- Retrieving an Item from a List that Meets Multiple Criteria
- Retrieving an Item from a List that Meets Multiple Criteria
- Retrieving Sale Price Based on Item and Color Criteria
- Retrieving a Price from a List that Matches both Category and Item Criteria
- Retrieving the Entire Row of a Matched Value
- Returning the Entire Contents of the Row Containing the Highest Math Grade
- Retrieving a Price Value by Looking at Two Difference Data Tables
- Retrieving the Column Header of the Next Non-Blank Cell in a Row
- Finding the First Value in a Row and Retrieving the Header for That Column
- Retrieving the Column Header that Corresponds with a Matched Value
- Retrieving the Column Header of the Largest Value in a Row
- Retrieving a Value from a Reference Grid, Using Indexes Listed in another Range
- Export data from Excel to Access (ADO) using VBA in Microsoft Excel
- Export data from Excel to Access (DAO) using VBA in Microsoft Excel
- Import data from Access to Excel (DAO) using VBA in Microsoft Excel
- Import data from a closed workbook (ADO) using VBA in Microsoft Excel
- Import data from a text file (ADO) using VBA in Microsoft Excel
- Transfer data from a recordset to a worksheet (ADO) using VBA in Microsoft Excel
- Use a closed workbook as a database (DAO) using VBA in Microsoft Excel
- Find if a character is in a cell in Microsoft Excel
- Find if a character is in a range in Microsoft Excel
- Find the most commonly repeated string in a column in Microsoft Excel
- Parsing text to the right of a search criteria - delimiter in Microsoft Excel
- Count the number of times in particular date a text appear in adjacent column in Microsoft Excel
- Using Cell Reference with Keyboard signs in the Criteria Range argument when using COUNTIF formula.
- Make LEFT Function recognize a number
- Calculating the Average of Every Nth Value, Excluding Zeros
- Removing Redundant Characters from a Range of Cells and Resetting the Format
- Avoiding Problems when Numeric Values are used as Text
- Counting number of unique entries in a specified range.
- Creating New IP Addresses
- Counting the Number of Excel Files in a List According to File Type and Date Criteria
- Altering results returned in case of an error.
- Retrieve Value Using Case-Sensitive Lookups
- Creating email address
- Restricting Cell Entries to Text Only
- Restricting the Number of Characters Entered into a Cell
- Preventing Duplicates When Entering Data
- Combining Text and Formatted Numbers into a Single Entity
- Combining Text and a Formatted Date into a Single Entity
- Combining Numbers that Have Leading Zeros
- Combining the Contents of Every N Number of Cells into One Value
- Encoding a Sequence of Letters
- Combining Text and Numerically Calculated Results into One Output String
- Adjusting a Formula to Return a Blank, Rather than a Zero, When Operating on Empty Cells
- Checking Whether Cells in a Range are Blank, and Counting the Blank Cells
- Removing Hidden Apostrophes from Imported Numbers
- Subdividing a Mixed String into Separate Cells Containing only Numbers or Characters
- Extracting the First N Number of Words from a String
- Converting Numbers with Trailing Minus Signs to Normal Negative Numbers
- Replacing Substrings with Numbers from Adjacent Cells
- Performing Numeric Operations on Substrings
- Searching a String for a Matching Word from another String
- Find the Alphabetically Lowest Letter in a List
- Identifying Numeric Values within a Range Formatted as Text
- Identifying the Case of Letters within Strings
- Finding the Relative Position of Numbers within a String
- Searching a String for a Specific Substring
- Determining Long Distance Phone Calls, Based on the Number Dialed
- Rearranging a String in Alphabetic Order
- Reversing the Word Order within a String
- Retrieving the Cell Address of the Largest Value in a Range
- Retrieving Each Row Number that Corresponds with Successful Matches in a Look Up
- Retrieving the Row Number that Corresponds with a Matched Value in a Look Up
Logical Formulas
- Simplifying Formulas by Reducing the Complexity of IF Functions
- Simplifying Formulas by Reducing the Complexity of IF Functions
- Create Conditional Formula
- Nesting OR & AND Functions to Meet Multiple Criteria
- Nesting OR & AND Functions to Meet Multiple Criteria
- Checking for the Presence of Specified Values within a Range
- List, change or delete external formula references (links) using VBA in Microsoft Excel
- Seperating Website Name or URL from Text
- How to eliminate N/A error result when using Vlookup formula in Microsoft Excel
- How to change error result calculation when using Vlookup formula to 0 or empty cell in Microsoft Excel
- Find the address of the max value in range in Microsoft Excel
- Control Excel from Word using VBA in Microsoft Excel
- Control Outlook from Excel using VBA in Microsoft Excel
- Control Word from Excel using VBA in Microsoft Excel
Other Q&A Formulas
- Calculate Average Speed in Microsoft Excel
- Find the maximum numerical value in a list based on a criteria in Microsoft Excel
- Find the minimum positive value in Microsoft Excel
- Find the minimum numerical value in a list based on a criteria in Microsoft Excel
- Get the value of the last non blank cell in a column in Microsoft Excel
- Generate a random value between two limits in Microsoft Excel
- Get the Row number of the last non blank cell in a column in Microsoft Excel
- Rounding numerical calculation results in Microsoft Excel
- Calculate commission percentage based on a commission schedule in Microsoft Excel
- How to find the minimum value in range while ignoring 0 value in Microsoft Excel
- Find duplicates items in combine columns in Microsoft Excel
- Find the value in the first non blank cell in range in Microsoft Excel
- Find the last numeric value in a range in Microsoft Excel
- Create Calculated Column(s) in Excel 2007
- Table Sorting Rules in Excel 2007
- Drawing Lines between Sorted Groups in Excel 2007
- Coloring Based on Text Criteria in Excel 2007
- Applying Colors to Top/Bottom Values in a List in Excel 2007
