tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment
Share this page:

MS Excel: Question & Answer

We've added this category to include some of our general Excel questions from viewers.

Hyperlinks

Buttons

Checkboxes

Radio buttons

Combo Boxes

Conditional Formatting

Visual Basic Editor

Integration with E-mail

Test for duplicates

Validation

Filters

Sorting

Freeze/Unfreeze Panes

Integration with Access

Time Calculations

Array Formulas

  • Use an array formula to sum values in Column A when value in Column B and Column C match criteria in Excel 2003 (or older)
  • Use an array formula to sum values in Column AB when value in Column E and Column AB match criteria in Excel 2003 (or older)
  • Use an array formula to sum all of the order values for a given client in Excel 2007
  • Use an array formula to count ranges of times in Excel in Excel 2003 (or older)
  • Use an array formula to count the number of children who will attend lunch in Excel 2003 (or older)
  • Use an array formula to perform a two criteria lookup in Excel 2003 (or older)
  • Use an array formula to count the number of rows that match 2 criteria in Excel 2003 (or older)
  • Use an array formula to count the number of occurrences when the value in column A is greater than or equal to the value in column D in Excel 2003 (or older)
  • Use an array formula to average values when 2 criteria are met in Excel 2003 (or older)
  • Use an array formula to calculate monthly attendance in Excel 2003 (or older)
  • Use an array formula to count the number of dates exceeding 12 months in Excel 2007
  • Use an array formula to count matches on multiple values in one column in Excel 2007
  • Use an array formula to count the number of rows when column F and column L match criteria in Excel 2003

Parsing

  • Create a formula to parse out BAG information and BOX information in Excel 2007

AutoCorrect

Miscellaneous