Search results for query: *

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

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

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

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

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

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

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

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

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?

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

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

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

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

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

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