1. T

    Using Excel to create a schedule table from given data table.

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

    Formula to repeat a value starting at x year and repeating y years

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

    Assistance Using VBA and Mod for Shading

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

    Formula Help

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

    SUMIF with MOD

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

    Changing data pulled with filter

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

    VBA: Merge duplicate rows into one row

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

    VBA mod

    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 =...
  9. H

    If cell contains data then format

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

    Finding the MIN of the MOD to a range of cells

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

    Data Validation - 15 Minute Intervals - Time Range

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

    how does mod work with negative numbers?

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

    Creating dynamic table off of two dynamic lists

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

    Lookup formula

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

    Sumproduct, Mod, Offset, If??

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

    Fill Property Let with function

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

    Sumproduct, Mod question

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

    Fill 3 columns with RGB value of preceding columns Interior Colour

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

    Formula for MOD 10 Weight 2 Algorithm

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

    time that crosses mid night

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back