mod

Hi Everyone, This has been stumping me for about a week now and I need assistance. My work's scheduling program produces a horrible table to track schedules and I am trying to take the information it outputs and create a printable schedule from it. I have been able to do it for most of the...

I am preparing a cashflow model which has a column with years starting at say 2023 going on for several decades. I wish to make a periodic income in the adjacent column that starts in say 2025 then repeats every say 3 years. Could someone help construct a formula for this? The start year, the...

Hi there, I've got a set of numbers from 1 - 100 in cells A1 - J10, generated by VBA, and am needing to shade the cells containing numbers divisible by 7, but I have to use the Mod code. My current code is: Dim Counter_Row As Integer Dim Column_Row As Integer Dim val As Integer val = 1 For...

Hello All, I need a formula that looks back 11 weeks from a given date and returns the Sunday at the beginning of that week. - Example, 27/10/2022. 11 weeks prior is 11/08/2022 and the Sunday beginning that week is 07/08/2022. The formula would return 07/08/2022. I also need one that looks...

Hello! Perhaps you could help ... Column A value Column B item start date Column C item end date Need to sum only the values that have item duration divisible by 12. I believe it is a combination of SUMPRODUCT, MOD, DATEDIF and perhaps "--", but not sure how to put them together. I know...

I currently have a filter formula that works great to pull my data; however, I was wondering if there is a way to make it give show something different than what is pulled? Currently it pulls the date of install and I simply want it to be a check box. Is it possible to make that happen in the...

Maybe my search words are lacking what they need for me to find the answer, so I need help. I have a table like this, where you can see Mod "a" was duplicated on 2 rows. I was trying to write the code to where if it was matching in column A, pasteall skip blanks, but It's not working for me. Any...

Hi all, can someone help me to mod this so that when the rows identified are moved to another sheet the subsequent blank row is deleted from the source table, please? Sub Move_Closed()Dim Check As Range, r As Long, lastrow2 As Long, lastrow As Long Application.ScreenUpdating = False lastrow =...

<tbody> I need help with borders on this spreadsheet. This is a combination of several spreadsheets which I didn't build. This has 6 set columns. Each numbered task may contain 1 to 6 rows. I need to place a border around EACH task. There is data in column A for each task. Is it possible to...

I have the range below and would like to find the MIN to a range of cells for the MOD of the value. In H9 I'm looking for the MAX, but in H10 I would like the MIN. Here is the formula I'm using for the MAX. Is this the best method to use? Cells H6 and H7 are actually 0.00. I just have the...

I have a column of cells in which I need users to input their time spent on a project ( time input as [hh]:mm ) the hours are accumulated over a 6 month period so can exceed 24 hours - but I would like the times entered to be restricted to 15 minute intervals (eg. 60:00, 55:15, 43:30, 38:45...

eg mod(4,-13) gives -9 ....how does that work?

Hi All, I have two datasets which can vary in length: Employee (column A), and Funding Source (Column B) I would like to create a table (in columns F and G) which will generate all possible combinations of Column A and Column B. Ideally, this table would be sorted by column F, and then by Column...

<tbody> job task charge codes prices N34 cable mod plate 125 cable 40 N35 cable socket mod connect 10 N38 socket connect mod plate 15 N44 cable plate socket socket 25 mod 70 </tbody> hi i new to advance formulas and i need a formula to look at the...

Okay, so the context is that I'm trying to model the running of an e-wallet, where users are able to top up. So basic assumptions: 1. Average top up value ($): D 2. Average top up frequency (top up every X months): T Figures input a. Operational month, O : 0 1 2 3 4 5 ... b. New users that...

Hi guys, I am just wondering how I could fill a property let with a function. for example I got following function Function KW_DIN(Datum As Date) As Integer '''geklaut ;o) ''von Christoph Kremer, Aachen 'Berechnt die KW nach DIN 1355...

I really need help on this. So the idea is that I'm running a calculation of top-ups to an eWallet, so I have a. Average top up amount ($47.50, b7) b. Average top up frequency (once every X months, b8) c. Number of new users (varies each month, row19) d. Attrition rate (varies each month) e...

Im trying to fill 3 cells with the rgb values of the interior colour of the preceding cell, eg if cell A1 has a solid blue background then B1 would equal 0, C1=0 and D1=255. Found this code on this site; Function FillColorRGBArray(Target As Range) As Variant Dim N As Double, A(3) As Integer...

I am looking for an xl formula to calculate the check digit for a MERS MIN. They tell me it is a MOD 10 Weight 2 Algorithm.

Hi Someone worked from 10:00pm to 6:00am next day. I want to calculate the difference. So I tried A1=10 pm B1= 6 am C1=(A1-B1)*24 But did not work I watched a video and the guy said use =Mod((B1-A1),1) But did not explain why. I know what mod is used for but how this idea came from? Mod...