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!

Recent content by jrobin9151

  1. jrobin9151

    Multiple IFs within an Array

    Skip, I re-arranged my spreadsheet and dramatically cut down on formula length. I threw in a helper column and added this formula: =IF(ISERROR(MATCH(L2,$Y$38:$Y$47,0)),1,0) Which looks to see if the job listed matches my master list. If not it puts a 1 in my helper column Then I added below...
  2. jrobin9151

    Multiple IFs within an Array

    Skip, Okay a foulup had occured in copy and pasting from your first post. My apologies.... The job types are from a selected list that I have in a combo box but the user can also enter other types. Hence, the variables.. so you are dead on, the requirments are a big problem. The end user...
  3. jrobin9151

    Multiple IFs within an Array

    Skip, thanks for hanging in there with me on this. - Yes, Under consideration are three columns of data In this logic, does it really matter what specific values are in column L? Are the relevant criteria 1) a specific value in column B and at least one value >=1 in column M? The answer is...
  4. jrobin9151

    Multiple IFs within an Array

    The spreadsheet is set up as such: Each row is a record Col A = Month Col B = Pay Period Col L = Job Type Col M = The number 1 is placed in the cell if its a gain, if it is a loss then a 1 is placed in column N I am attempting to add all of the gains OR all of the losses for a specfic pay...
  5. jrobin9151

    Multiple IFs within an Array

    Skip, Thanks but now the formula returns the number two. Using the dataset above I should end up with a 1. Because, cell B2 - "11_22" cell L2 is 200 and M2 = 1. I want the formula to disregard summing M3 and M4 because Cell L3 = 1515 and Cell L4 = 303 even tho all three are in the same...
  6. jrobin9151

    Multiple IFs within an Array

    Happy New Year All!!! The formula is not working. I'm trying to determine then number of staff not defined with a certain code in column L during a pay-period determined in colum B. As suggested by Macropod I put this formula in T30 as an array...
  7. jrobin9151

    Multiple IFs within an Array

    Happy Holidays all and thanks so much for your help. Macropod, your suggestion greatly reduced my formula and made it much more sensisble. I now have a last formula that I'm trying to constuct that will sum the 1's in column M that correspond to the selected pay period but are NOT a series that...
  8. jrobin9151

    Multiple IFs within an Array

    Higgins, you got me to thinking and i came up with the following formula, although long and ugly it works...
  9. jrobin9151

    Multiple IFs within an Array

    Higgins Thank You - I have 2003 edition of office and when I enter the sumproduct formula I get a #Value error. Why is this occuring?
  10. jrobin9151

    Multiple IFs within an Array

    I put together the following formula based on blogs out there and it works fine: {=SUM(IF($B$1:$B$500="11_22",IF($L$1:$L$500=303,IF($M$1:$M$500>=1,$M$1:$M$500))))} The formula looks to column B and when it finds the Pay period "11_22" it looks to column L for cells that have series 303 listed...
  11. jrobin9151

    Staffing Gains/Losses

    Skip, thanks. I need the names of the folks that were deleted and added. I think I have the formula correct for getting the persons name when they're added. But I don't have it right when they're deleted from the list. Attached is a sample of my spreadsheet...
  12. jrobin9151

    Staffing Gains/Losses

    Skip! So glad to see your still assisting folks. I've read and used many of your suggestions/solutions very successfully!!! We have half the fix to this issue. The match returns #N/A But then I need to add the name of the employee that was added or lost from the previous pay period. I've tried...
  13. jrobin9151

    Staffing Gains/Losses

    Excel 2003 running on windows xp. I am trying to create a report that will return the gains and losses in staffing. Each pay period a roster from HR is given listing the names and work locations of the individuals. I am posting each data set into a seperate tab in the workbook. On the main or...
  14. jrobin9151

    Select a radio button in Options Frame based on combo box selection

    MajP Thanks for helping me kick the rust off the pipes. It's been a long while since I've built anything in Access and it all came back to me. Changed the coding slightly(see below) the radio buttons became a shaded grey when retirment wasn't chosen making it confusing looking. Forcing the value...
  15. jrobin9151

    Select a radio button in Options Frame based on combo box selection

    ACCESS 2003, Installed on a Network. I know this is probably easy to do can't remember it though. I have a combo box with several selections in the dropdown. Further down the form I have an Options group with four radio buttons that I've assigned the numerical value 1-4. When a user selects...
See more

Part and Inventory Search

Back
Top