Can Excel List specific data from a list? NOT Autofilter??

W

wx4usa

I have a database in excel

Columns look like this...Account, date, amount, description

Can excel do a report for me that lists all transactions for an
account?
Ex. enter Account 12345 and then a list appears on a separate
worksheet.

NOT using AUTOFILTER?? Is that possible? With index match somehow??
 
S

Sheeloo

Nice to know. Pl. mark the post as answered to help other users with similar
requirment.
 
S

Sheeloo

Click on "Yes" to the question "Was this post helpful to you?" if you are
using the web interface.
 
D

David Biddulph

Sheeloo,

If you had looked at the message headers of wx4usa's message to which you
were replying, you would have seen that the message came via Google groups,
rather than via Microsoft's web interface to the newsgroups.

Please remember that it causes confusion to users to refer them to a
facility which doesn't exist on a newsgroup, and frequent references to such
a facility cause annoyance to other contributors accessing the newsgroup
directly.
 
S

Sheeloo

Hello David,

No, I did not notice that. I will take care in the future.

Don't you think marking a question as answered is important? If yes, then
what is the best way to handle it for those who are using newsreaders...?
 
D

David Biddulph

As one who uses a newsreader, then, no, I don't consider that marking a
question as answered is important, and if it were, I don't believe that
there is any direct way of handling it for those who are using newsreaders.
If those using the Microsoft web interface consider that feature to be
important, then presumably they might be able to mark something as answered
on behalf of the original questioner, but I would doubt whether it's worth
the hassle.

Perhaps the web interface should make it clearer that many answers will not
necessarily be tagged as such?
 
S

Sheeloo

David,

Got your point. It makes sense.

I will not ask the user to mark as answered in future.

Thanks,
Sheeloo
 
Top