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 Rhinorhino 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: *

  1. scubafrog79

    Formula for checking cells for value and then subtract value

    I mistyped the formula the first time once I realized that I corrected my mistake. In the cell that I wanted the formula to work in is: B2-SUMPRODUCT((C12:N12<>"NO")*(C11:N11))
  2. scubafrog79

    Formula for checking cells for value and then subtract value

    I must have done something wrong with the formula the first time because it didn't work, but now it does. Thanks for the help
  3. scubafrog79

    Formula for checking cells for value and then subtract value

    Using the Excel image that you provided...
  4. scubafrog79

    Formula for checking cells for value and then subtract value

    What I want to do is get the sum of one row where I have a "NO" value on another row and then subtract that sum in another cell. Say I have a value of 1,000,000 in cell B2 Then further down in the spreadsheet I have 12 columns with data in two rows. In this example my value in cell B2...
  5. scubafrog79

    Excel - Cell always to be a certain value but use another cell's value in the formula

    Never mind I figured it out. =cell with value + SUM(1000000-cell with value)
  6. scubafrog79

    Excel - Cell always to be a certain value but use another cell's value in the formula

    How can I make the value of a cell be a certain amount but use the amount of another cell and then add the difference to the value I want. To make things simple. Let's say that I want the "target" cell to always equal 1 million but the other cell is 250K. How can I create a formula to grab...
  7. scubafrog79

    Flag record if there two different locations for that record in another table

    I have no choice, the data is in two different tables. I need to mark if the product is two different locations, in the product table only
  8. scubafrog79

    Flag record if there two different locations for that record in another table

    I am trying to create an update statement that will update a column. Here is the scenario. Let's say I have a bunch of products and I need to tag any of those products that exist in two different locations. Note the product can be in the same location more than once at times, I don't want to...
  9. scubafrog79

    Loop through a datasheet and change cell value based on two other cells

    I have a form that is shown as a datasheet view when it's loaded. During the loading of the form, I would like for it to do a "calculation" that if the "Refill Date" is greater than the "PA Date", it changes the "PA Required" to TRUE. But I need it to check all the rows as the form loads. I...
  10. scubafrog79

    Searching for a value in datasheet column

    Thanks, didn't realize Access had conditional formatting like Excel.
  11. scubafrog79

    Searching for a value in datasheet column

    I was wondering how I can look through a datasheet that is a sub-form to find a record based on date. So when I open my form, it looks at the sub-form and loops through the records and when it finds a row with today's date, it changes the background and font color but puts it back to the normal...
  12. scubafrog79

    Highlight row based on cell value in column

    I'm sure this has been asked several times but can't find anything on it. Here is my situation. I have a spreadsheet with data in columns A through L and in several hundred rows. I want to highlight each row from column A through L, if the value in column "J" is a specific text value, in the...
  13. scubafrog79

    Excel - VBA Code

    Hopefully I'm in the right forum. Here is what I'm trying to do. Below is an example of the workbook,the dates are in column A. When I open an Excel workbook, I want the focus to go to the date column. Using today's date, I want the focus to go to the cell that has the date of 09/30/2014...

Part and Inventory Search

Back
Top