I've been using Mr J. Walkenbach's "trick" on how to create a "list" from a
"summary table" but that was with Office 2003 and I can't get it straight
with Office 2007.
This how I used to do it (with Office 2003):

Does anybody have the answer to this:
I have a worksheet with a "Date Column" and a "Model No. Column" I
want to be able to check the entire two columns using a formula and
have the worksheet count the no. of "model no.s" that are equal to X

Further to Petes successful resolution of my earlier query (thanks
again Pete) I am now looking for the following info:
where A = Date Column (date)
where B = Model Column (text and number)

How do you assign a macro to a command button?

I've been going through past Qs without a solution
I have a spreadsheet with multiple columns and rows.
I need multiple criteria to be met (all true) and then have the whole row
extracted to a new worksheet, whilst ignoring blank entries.  Below is an

text string: xxx-23xz-34L or can be xxx-23exv-24R0
using the formula below, how do I put it such that if it finds an R
than it puts R else if L then it puts L.
IF((MID(G6,FIND("R",G6,1),1))="R","R","L")

Hi.  Using xl2000 on XP.
I've written the formula =IF(ISNA(GETPIVOTDATA(threewtpt,$A$2&" "&
$A4&" "&$C$16))=TRUE,0,GETPIVOTDATA(threewtpt,$A$2&" "&$A4&" "&$C$16))
When I enter a date in $C$16, referring to a field containing date

Is there a way (preferably not with VBA) to assign a date to a new record
when a cell is a certain value?  In this instance, when a particular cell
shows "Closed/Won/Lost" (selected from a drop down) I want to assign a date
automatically.

I collect stats for a sports team, and the sheet used tracks Goals (G),
Assists (A) and Shots (I) all in the same cell, with one cell per period.  
What I need to be able to do is track the number of times a "G" comes up in a
period for a team, as well as over all the periods of ...

I have a spreadsheet where the even numbered rows cell shading is grey and
the odd rows cell shading is white.  I use
I have numbers in my other columns where i.e. A2 is 001, A3 = 002, A4 = 003,
etc.  I need to update those numbers so I change A2 to = 020 and click lower

Is there a way to remove #N/A as a result from a formula, for example to
return a blank or zero result instead?

I poured over previous Qs with no help.
Status    Request    Date    M OR B    Site    PC    17"    19"    24"    A4
OPEN    376929    11-Dec-07    M    ORH                   
OPEN    404577    1-Feb-07    M    RIC                5   

I have 2 questions:
when I run a change event procedure on the worksheet, I need to unprotect
the sheet and protect is once it is done.  I have procedures to do that.  
They are:

I have a 4 dynamic columns of data that connects to an access database.
Code   Counts      Description    Quantity
pro1     2                                   1
pro2     1                                   1

i am trying to create a calculator of sorts in excel....rather, it is
going to calculate the value in dollars for a sick day buy back at
retirement.
i have no problem writing the formulas to calculate the differnt