int

Employee-Leave-Vacation-dashboard.xlsx Hey Folks, Please I need your help to fix one issue in the attached excel file. Sheet TEAM DASHBOARD, I want to add INT fuction to calculate only date from vacation & absence sheet without time. I'm looking also to get data from the 2 table ( Vacation &...

If in A1 I have the integer 1, and in B1 I have the integer 3, and in C1 I want to generate a random number from 1 to 5 which excludes the integers 1 and 3 from these previous two cells, how could I accomplish this? I looked over the below thread, but it was slightly different, and couldn't...

Morning Wizards, I am using this formula in VBA =INT((ROW(R[-14]C[-2])-6)/5)+R6C1 Is there a way of making the R[-14] part dynamic based on the number of rows from A6 and cell containing the formula. Thank you for your help

Hello, I am using sumproduct to create a summary table that adds the score for each day. The issue I have is that the time stamp for each day includes the time as well, whereas the summary portion of the spreadsheet has no timestamp. Therefore, the equality is false. Col F Col J...

I have six columns and 15,625 rows. My data is working with combinations of +2 to -2. In column A, I want to sequence my input data as +2,+1,0,-1,-2 and then repeat until row 15,625 In column B, I want to sequence it as five +2s, then five +1s, then five 0s, then five -1s, then five -2s. In...

I have a series of volumes of vaccine that I need to order regulary ranging from 40ml to 1750ml the vaccines come in bottles of 250ml, 100ml and 50ml. The quantities are listed in column H3 to H36 and the bottle sizes are listed J2 to L2. What formula can I put in so that it automatically...

My test case can be downloaded from http://home.comcast.net/~jasmith4/ExcelVBAroundBug/RoundBug.xls It's an Excel 2003 file, but the bug shows up in Excel 2007 and 2010 too. The bug has to do with VBA rounding numbers that end with one decimal digit, xxx.5 -- for example, if you round 0.5...