Results 1 to 4 of 4

Repetitive division problem

Threaded View

  1. #1
    Registered User
    Join Date
    03-23-2021
    Location
    Belgium
    MS-Off Ver
    16.45
    Posts
    6

    Repetitive division problem

    Hi!

    I am incurring a problem related to a division that has to happen for every week. I collected a dataset of the number of ship arrivals (port calls) per country and per week. This indicator is reported on a weekly basis but I would like to obtain a value for each day of that week by dividing this weekly number uniformly over the week.

    As this would be impossible to execute for 100.000 lines manually, I would like to know if there would be a way to automate this by using a formula or VBA.
    You can see in the attached document that there is column country, date, port calls 1x per week, per day. Now, the purpose is to go from the 'port calls 1x per week' to the column 'per day' by making use of an efficient and effective way.

    Thank you in advance!
    Dan
    Attached Files Attached Files
    Last edited by DanVG; 03-30-2021 at 10:23 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Problem with division
    By bralew in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-04-2017, 10:38 AM
  2. [SOLVED] Division problem
    By gregb1203 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-27-2013, 02:42 AM
  3. [SOLVED] A complex problem-replacing repetitive numbers with blank
    By pahari75 in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 03-01-2013, 11:33 PM
  4. problem with macro in a repetitive task
    By mahmoodn in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-03-2011, 09:20 AM
  5. Excel 2007 : Problem With #division/0!
    By baek2 in forum Excel General
    Replies: 8
    Last Post: 10-25-2010, 05:07 AM
  6. Division problem
    By hejs in forum Excel General
    Replies: 6
    Last Post: 02-22-2005, 05:48 PM
  7. [SOLVED] Division problem
    By Wondering in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 01-27-2005, 07:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1