 | As you create a list, one column will be the "Primary
Key", that is a column where no duplicates are allowed. As
a person enters data into a list, how can you check that the entry is not a
duplicate? |
|
I want to animate a graph. Each column of a
table represents a different "frame" of animation. |
|
Given a square table of
numbers. We all know how to Add by rows, and add by
columns. But how can you add across each diagonal?
January 2002 |
|
How many ways can you define a Range Name?
October 2001 |
|
Assume you have a workbook where each sheet
contains the budget for a department. There are many
sheets. You want to create a "Summary Sheet" that
lists each department and their budget totals. How do
you summarize from many sheets onto one? September
2001 |
|
Make a table of dates that are the THIRD FRIDAY of every
month. (This is the date of Options Expiration in the
Stock Market, so it is not an idle problem!!!) See
May 2001 |
|
When I use Autofilter a table, I want my totals to sum on only
the rows that pass the filter, i.e. the visible rows. Use
SumProduct in a worksheet and a User Defined Function to determine which
rows are visible. See April. 2001
|
|
I have a large table with repeated fields. I want this to look like an
Outline Report where the repeated fields are shown once. See
Feb. 2001. |
|
I have a list of 200 integers that vary
randomly from 1 to 100. How do I determine how many UNIQUE
numbers are in that list? See
Jan. 2001 |
