+ Reply to Thread
Results 1 to 2 of 2

Track data completeness of Row Weekly

Hybrid View

  1. #1
    Registered User
    Join Date
    02-20-2018
    Location
    london
    MS-Off Ver
    excel 2010
    Posts
    14

    Question Track data completeness of Row Weekly

    Hi, i have rows full of data and have a percentage which gives me the data completeness of selected columns and their cells.

    I wanted to track this weekly to see the change weekly. Is there a way i can automate this percentage weekly so i can track the percentage increase??

    Essentially need to prepare a data completeness report to show there has been an increase or if there isn't i can show the percentage on the monday and then the Friday that week that the data completeness has increased enough

    appreciate help thanks

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Track data completeness of Row Weekly

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 05-14-2017, 01:40 PM
  2. Check data for consistency and completeness
    By Noah14 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-04-2014, 08:50 AM
  3. Ideas on how to track weekly trends from multiple files
    By Nurseryboy in forum Excel General
    Replies: 3
    Last Post: 08-03-2013, 04:03 AM
  4. Track weekly expenditure - difficult formula - please help!!
    By excelhelpme! in forum Excel General
    Replies: 2
    Last Post: 01-28-2012, 11:01 AM
  5. Track weekly overtime worked and available ytd
    By excelorfail in forum Excel General
    Replies: 3
    Last Post: 12-29-2008, 12:23 AM
  6. data completeness validation?
    By cashflowpro in forum Excel General
    Replies: 4
    Last Post: 06-13-2008, 07:16 AM
  7. Replies: 0
    Last Post: 04-06-2006, 11:45 AM

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