Search results for query: *

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

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

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...

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...

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...

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...

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

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...

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

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...

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

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...

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...

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...

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...

Hello Folks, I am attampting to build an access database by importing excel spreadsheets with rows of record data. Some cells contain text and some strictly numbers. I am ultimately attempting to querry all cells for key words that may fall within any cell within the record. For example...

Thank you so very much John your suggestion worked perfect. Have a great day, JB

I am attempting to go through a large spreadsheet with a first column containing 12 digit id numbers. Within the 12 digit number is an identification trailer on the very last digit. I would like to sort the spreadsheet by grouping any 12 digit id number that ends in 1, 2 or 3. If I had an if...

Thanks everyone for the help with my lookup table. It works Great!

Gavin, I was still not able to get the Or function to work according to your suggestion: The format should be: Or(if(...),if(....)) And(if(...),if(....)) As an example should it be...