determine

I am trying to post the below code into a column of a table so that it will determine if an employee is Valid or Not Valid when it comes to whether or not they accrue vacation. When I paste this formula into a VBA script I get a Run-Time 1004 error. I cannot determine why...The worksheet name is...

Hello, I'm in dire need. I need the median values for a set of data, using the pivot table functionality. Is there a way to use the pivot table tool to determine this, similar to how I can quickly identify the average, sum, min, max, etc? Thanks so much!!!

I'm hoping to get some advice on what functions are best to use or a subroutine to determine if a cell value is one value more (+1) or less (-1) any of the cell values in the row above it. If true, I simply want to identify it by placing the letter "A" in a cell, else, leave blank. The "A" or...

We're moving from Windows 7 Pro to Windows 10 Enterprise. I'd like code in my workbook to work under either environment, meaning I need to determine which environment a user is in and adapt my code accordingly. Thoughts?

Hi all, I'm trying to think of a formula to lookup values from a list to decide a right size product for an order. For example - this is the range...

I have some VBA in a workbook that I didn't create but need to edit. The issue faced is that at the moment it is referencing a count of the number of rows in column T to determine how many times to loop the printing (which is always 15 rows). However I want to use the value in cell U2 to...

I have a file with customer IDs and payments per month. How can I determine the best (adding the total amount) customer with the help of one formula? Thank you!

Hello, Trying to figure out what to search so I can figure out how to do this. I'm building a part number lookup, so it matches each number and returns information. So of the descriptions are multiple lines. How can I look at the next row and check for " " to determine if the offset...

I am in need of a formula that will look into column C (Last Used) and column H (Last Purchased) to determine if both dates are before 2015. If they are then an asterisk should mark the cell.

hi all.. how to determine date this below : start date : 1/1/2018 end date : ...? parameter : <= 6 month any help, thanks in advance... susanto.

Hello, I was recommended to this forum by a friend who spoke very highly of it, so I hope I've landed in the right place! I am looking to put together an excel sheet to predict the scores, win probability and cover probability of american football. I would like to do this for other sports as...

I have a line graph with a trend line and I was wondering is there a somewhat easy way to determine the beginning and end points on the trend line?

<tbody> Schedule Schedule Name %1 %2 %3 %4 %5 %6 %7 1 bla1 2 0 40 6 0 8 0 100 100 2 bla2 100 100 100 100 10 3 immediate 100 100 100 100 100 100 100 </tbody> Ok.. so this is a little complicated. I currently have an If statement written that says...

Hi Folks, It sounds simple but I couldn't find a proper way how to check if a workbook was opened by macro or by a user. To cut a long story short: I run a macro (it displays a userform) which opens several workbooks while running. How can I determine if a workbook is opened by a user during...

I need a WB to auto_close after Scheduled Tasks opens it but stay open when a user opens it manually. Is there a way to determine via VBA when a WB was opened by tasks (or, looking at the problem from another angle, not opened by a user)?

Win 8.1/Office 14 I have a worksheet with baseball inning-by-inning scoring on it with range names like innV1, innv2,...innH25, innH26 and WLT (for Win/Lose/Tie). I want to determine the team's winning percentage when it scores first (by inning). For example, if the visiting team (which bats...

hi i am reading a code and part of it is to determine an empty row, please see below. I could not understand it!! I tried to enter A1=10, A2=20, A3=30 I got 4. So row 4 is empty. So far so good. But when I did A1=10, A2=(empty), A3=30 I got 3 but row 3 is not empty. Is the code below makes any...

Hello I am trying to write a formula that will go through a column of numbers/receipt codes and will count how many times a set first two numbers appear (as the first two numbers determine a location) any help would be appreceiated as I am struggling to write this forumla correctly Thanks

hi all, anyone know this algoithm? i have this problem: have this subset: (5,13,9,12,22,50,18) (A1,B1,C1,D1,E1,F1,G1) and in A2, have this number: 36 How to determine wich elements of the set of numbers sum 36 in this case is: 13+18+5 Thanks

Hello, I was recently trying to determine a way to count the unique values of one column and use that to determine the count of Yes Answers from another column based on that. Ex. Column A|Column B 00000 |Yes 00001 |Yes 00000 |No So, I wanted to take the unique Values of...