Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mdro
  • Content: Threads
  • Order by date
  1. mdro

    Time linked formula

    Hi all, I work with an investment firm. I have a target cell pulling information from a stock quotes application on a continuous basis. I want the target cell to only pull that information once per day at 1PM rather than continuously. I'm wondering if there is a command that can be added...
  2. mdro

    CSV Problem

    I have a CSV file that needs to be uploaded into an order management system. The CSV file contains a column full of fees to be charged to clients. The cells are formatted as general so $100.00 is simply shown as 100. The problem I'm running into is when the file is loaded into the OMS, it...
  3. mdro

    Excel: Filter Shortcut

    I need to filter for the same values each month. I was wondering if there was a quick way to filter without having to select the values individually from a drop down menu. The specific values I will be filtering for are loginIDs so they will remain constant over time. Thanks!
  4. mdro

    Excel - matching text from another column

    I have a spreadsheet that contains a list of items on lease. The list is by item description, but I need an aggregated list by asset class. Most of the items are printers or storage units. So I would like to create a column that looks for the words "laserjet", "storage", and "GB". If it sees...
  5. mdro

    Excel - IF Statement: You've entered too many arguments.

    Hello, I am working on a spreadsheet that allocates costs based on information pulled from a pivot table. The spreadsheet matches the userID and product symbol from the target worksheet with the related cost found in the pivot table. The formula I have in place is...

Part and Inventory Search

Back
Top