stat

I'm working with data in the B column that contains either a "+" or a "-" and I need the information after that. Example values in B column: > §3 +60% STAT » (3 -15% STAT My current formula(s) in the C column are either: =TRIM(RIGHT(SUBSTITUTE(B1,"+",REPT(" ",LEN(B1))),LEN(B1)))...

I am trying to make a timesheet that calculates overtime with the following criteria... 1. Overtime is after 8hrs on any given day. 2. Overtime is after 40hrs/week...consideration to the after 8hr criteria to ensure not duplicating overtime. 3. The after 40hrs/week overtime criteria changes if...

If a company owns 15 locations across the country. They want to add new systems in each locations. Some locations require more than 1 system. Some of these locations are located in the South, NE, W and Midwest. the systems installed are as below: South - 10 systems NE- 1 systems West - 5...

Hi, I'm trying to work out some VBA to calculate the percentage of two integers..... not sure if I am doing the right thing. I have these two lines counting rows not blank Stat = Application.WorksheetFunction.CountA(Sheets("EMAIL TOOL").Range("G:G")) - 1 lstat =...

I call the local high school games on the radio and want my stat guy to have an excel sheet where he can type on the D&D, the YL, Player # and gain/loss yardage. When he enters that information I want to have the D&D & YL calculated for the next play depending on the result of the play prior. Is...

Ok I have an index(Match formula I'm using.... IFERROR(INDEX('Master Portfolio Sheet'!C$3:C$187,MATCH(1,INDEX(('Economic Macro'!$G$2='Master Portfolio Sheet'!B$3:B$187)*('Economic Macro'!$A18='Master Portfolio Sheet'!A$3:A$187),0),0)),"") I understand that this is making sure two variables are...

I have 2 columns (A and B) and each column contains 6 items. I need combination of both columns which give sets of 6 items however combinations can only have 4 items from one column. Can anybody please help me.