|
Can Excel List specific data from a list? NOT Autofilter??
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?? |
Can Excel List specific data from a list? NOT Autofilter??
Download http://www.contextures.com/ProductsList.zip from
http://www.contextures.com/excelfiles.html#DataVal for an excellent example of how to do what you want... -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "wx4usa" wrote: 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?? |
Can Excel List specific data from a list? NOT Autofilter??
On Oct 20, 10:48*am, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64)
& "hotmail.com" wrote: Downloadhttp://www.contextures.com/ProductsList.zipfromhttp://www.contextures.com/excelfiles.html#DataValfor an excellent example of how to do what you want... -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "wx4usa" wrote: 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?? that works great! Thanks |
Can Excel List specific data from a list? NOT Autofilter??
Nice to know. Pl. mark the post as answered to help other users with similar
requirment. -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "wx4usa" wrote: On Oct 20, 10:48 am, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote: Downloadhttp://www.contextures.com/ProductsList.zipfromhttp://www.contextures.com/excelfiles.html#DataValfor an excellent example of how to do what you want... -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "wx4usa" wrote: 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?? that works great! Thanks |
Can Excel List specific data from a list? NOT Autofilter??
On Oct 20, 11:17*am, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64)
& "hotmail.com" wrote: Nice to know. Pl. mark the post as answered to help other users with similar requirment. -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "wx4usa" wrote: On Oct 20, 10:48 am, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote: Downloadhttp://www.contextures.com/ProductsList.zipfromhttp://www.contextures...an excellent example of how to do what you want... -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "wx4usa" wrote: 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?? that works great! Thanks How do I mark as answered? |
Can Excel List specific data from a list? NOT Autofilter??
Click on "Yes" to the question "Was this post helpful to you?" if you are
using the web interface. -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "wx4usa" wrote: On Oct 20, 11:17 am, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote: Nice to know. Pl. mark the post as answered to help other users with similar requirment. -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "wx4usa" wrote: On Oct 20, 10:48 am, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote: Downloadhttp://www.contextures.com/ProductsList.zipfromhttp://www.contextures...an excellent example of how to do what you want... -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "wx4usa" wrote: 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?? that works great! Thanks How do I mark as answered? |
Can Excel List specific data from a list? NOT Autofilter??
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. -- David Biddulph "Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in message ... Click on "Yes" to the question "Was this post helpful to you?" if you are using the web interface. -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "wx4usa" wrote: How do I mark as answered? On Oct 20, 11:17 am, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote: Nice to know. Pl. mark the post as answered to help other users with similar requirment. -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "wx4usa" wrote: On Oct 20, 10:48 am, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote: Downloadhttp://www.contextures.com/ProductsList.zipfromhttp://www.contextures...an excellent example of how to do what you want... -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "wx4usa" wrote: 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?? that works great! Thanks |
Can Excel List specific data from a list? NOT Autofilter??
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...? "David Biddulph" wrote: 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. -- David Biddulph "Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in message ... Click on "Yes" to the question "Was this post helpful to you?" if you are using the web interface. -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "wx4usa" wrote: How do I mark as answered? On Oct 20, 11:17 am, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote: Nice to know. Pl. mark the post as answered to help other users with similar requirment. -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "wx4usa" wrote: On Oct 20, 10:48 am, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote: Downloadhttp://www.contextures.com/ProductsList.zipfromhttp://www.contextures...an excellent example of how to do what you want... -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "wx4usa" wrote: 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?? that works great! Thanks |
Can Excel List specific data from a list? NOT Autofilter??
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? -- David Biddulph "Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in message ... 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...? "David Biddulph" wrote: 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. -- David Biddulph "Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in message ... Click on "Yes" to the question "Was this post helpful to you?" if you are using the web interface. -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "wx4usa" wrote: How do I mark as answered? On Oct 20, 11:17 am, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote: Nice to know. Pl. mark the post as answered to help other users with similar requirment. -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "wx4usa" wrote: On Oct 20, 10:48 am, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote: Downloadhttp://www.contextures.com/ProductsList.zipfromhttp://www.contextures...an excellent example of how to do what you want... -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "wx4usa" wrote: 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?? that works great! Thanks |
Can Excel List specific data from a list? NOT Autofilter??
David,
Got your point. It makes sense. I will not ask the user to mark as answered in future. Thanks, Sheeloo "David Biddulph" wrote: 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? -- David Biddulph "Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in message ... 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...? "David Biddulph" wrote: 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. -- David Biddulph "Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote in message ... Click on "Yes" to the question "Was this post helpful to you?" if you are using the web interface. -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "wx4usa" wrote: How do I mark as answered? On Oct 20, 11:17 am, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote: Nice to know. Pl. mark the post as answered to help other users with similar requirment. -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "wx4usa" wrote: On Oct 20, 10:48 am, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote: Downloadhttp://www.contextures.com/ProductsList.zipfromhttp://www.contextures...an excellent example of how to do what you want... -- Always provide your feedback so that others know whether the solution worked or problem still persists ... "wx4usa" wrote: 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?? that works great! Thanks |
| All times are GMT +1. The time now is 09:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com