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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by PeanutB7

  1. PeanutB7

    Matching Two Columns From One Worksheet to Two Columns in Another While Returning a Value

    Sorry Skip - I did not see your earlier post. Thank you very kindly, J
  2. PeanutB7

    Matching Two Columns From One Worksheet to Two Columns in Another While Returning a Value

    Is there anyone that can provide advise on this formula? Thank you and have great day, J
  3. PeanutB7

    Matching Two Columns From One Worksheet to Two Columns in Another While Returning a Value

    Folks Thanks for the help. Worksheet 1 contains a Column A for location and Column B for a product item number (i.e., SKU). Worksheet 2 has the same two columns as well as an activity quantity Column C showing how many of the item numbers have been used in each location. I would like to...
  4. PeanutB7

    Matching Two Columns From One Worksheet to Two Columns in Another While Returning a Value

    I am working with one Spreadsheet that contains two worksheets. I am attempting to match two columns in spreadsheet one to two columns in spreadsheet two. A respective number would then be inserted as the output from Column C Spreadsheet 1 Column A Column B Location...
  5. PeanutB7

    Excel Formula Help PLEASE

    Skip - Thank you Sooooo much it works like a charm. What reference book or site would you recommend for these type of formulas? I have never found anythting in the Microsoft Help catalogues to answer these type of needs. Thank heaven for folks like yourself who are willing to share their...
  6. PeanutB7

    Excel Formula Help PLEASE

    Good Snowing Morning Folks, I am in need of a complicated formula for an excel worksheet. First off I need to scan a column of ID numbers that are sorted in ascending order in column A. For example 1234000, 1234001, 1234002, 1235000, 1235001, 1236000, 1237000, etc. If the ID number in...
  7. PeanutB7

    SImple Access Query

    Technical User I am not quite sure who you folks are or why you answer dumb questions like mine but THANK YOU SO VERY MUCH! I searched every help site I could and no one mentioned that maneuver. It worked brilliantly! Thank you again! John
  8. PeanutB7

    SImple Access Query

    Hello Folks, I have two tables inserted in a query that are linked together by last name. Table one has the last names with a designated title in a specific column labeled ID. Table two has the last names also, as well as many columns with a lot of assorted data. I need to add the title...
  9. PeanutB7

    Preferential Total

    xlhelp, I do not how and/or why but it is working like a champ. Thank you soooooo much for the needed assistance. Greatly appreciated, JB
  10. PeanutB7

    Preferential Total

    Hello Folks, I have a very large spreadsheet (139,000 rows cut into multiple worksheets) with columns of data that includes various line item costs and a corresponding ID number. The ID number repeats itself providing multiple line items per each ID number. This would be similar to multiple...
  11. PeanutB7

    Conditional Shading off a Cell in Xcel

    Thank you so much for you input and help. Your suggestion worked perfectly! Thanks again and much appreciated! JB
  12. PeanutB7

    Conditional Shading off a Cell in Xcel

    Could someone please help with a conditional formatting situation. I am trying to highlight a cell with green for "On Time" and a red highlight for "Not On Time." I am using the formula listed below: =IF(L8>0, "On Time","Not On Time") I would like to add the red/green highlight to the...
  13. PeanutB7

    How do I subtotal groups in Reports with Access

    fneily, Thanks for the prompot response. I have used the report wizerd and can achieve a summary report but at the cost of losing the detail that composes the subtotal. Is there a way to provide each record of detail per category with a subtotal below before moving onto the next category of...
  14. PeanutB7

    How do I subtotal groups in Reports with Access

    Hi Folks I am looking to subtotal each group in a report while stiull providing all of the record detail that makes up the subtotal. How would I go about doing that in an Access querry or report. I can create the querry which provides all of the records grouped by category. I just can not...
  15. PeanutB7

    Access Keyword Search Querry

    Duane Thank you so much for the answer but can I ask you to elaborate on the Access querry. I am not exactly sure what you meant by the SearchFields: [FieldA] & [FieldB] & [FieldC]. Is this what is to be put in the querry column. Can it be set up like a parameter querry where the user is...
See more

Part and Inventory Search

Back
Top