Petroleum Goodies: Excel List Navigator |
Posted: 04 Apr 2014 08:44 PM PDT Free Excel List Navigator: Navigate Your ListThis tool simply helps you to filter your data from list and show the selected data. It takes the data from sheet All List and dump the selected data to sheet Selected List. You can do operation from the selected data or simply show them on chart. This tool can be used for general purpose. In this spreadsheet we use an example to select individual well and show its production and calculate peak rates (oil and gas). How To Use This Tool?
Note: Don’t do any operation in sheet Selected List. Instead you can link to this sheet and do calculation in another sheet. Using VBA macro? Yes. Updates: v1: First release for Ms. Excel 2007+ (.xlsm) accepts more than 1 millions rows and for Ms. Excel 2003 (.xls) accepts more than 65 thousand rows. Download List NavigatorNote: There is a file embedded within this post, please visit this post to download the file.Related Posts: |
You are subscribed to email updates from Petroleum Goodies To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
Google Inc., 20 West Kinzie, Chicago IL USA 60610 |
No comments:
Post a Comment