| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation from a list - Always case specific? | Excel Discussion (Misc queries) | |||
| List for AutoFilter and list for Subtotals have different meanings? | New Users to Excel | |||
| if specific value from list A equals one of the values from list b... | Excel Worksheet Functions | |||
| Want to Create a List in Excel 2002; Don't see List in Data Menu? | Excel Discussion (Misc queries) | |||
| Adding data in a list that meets a specific criteria | Excel Worksheet Functions | |||
Hybrid Mode
