Results 1 to 7 of 7

Formula to detect anomaly in data entered in excel sheet

Threaded View

  1. #1
    Registered User
    Join Date
    07-05-2012
    Location
    Tanzania
    MS-Off Ver
    Excel 2010
    Posts
    6

    Post Formula to detect anomaly in data entered in excel sheet

    I have an excel sheet used by an operator to enter details of fuel delivery for the fleet on daily basis.

    The fleet is of over 100 vehicles and equipment's.

    The problem I currently face is anomalies in data entry. The operators are making TYPO's while entry mileage/ODO meter of equipment.

    Is there someway in which i can use excel to detect errors,

    For example, If an operator enters a mileage of 145205 on Monday, the equipment refuels on Thursday, with mileage, 145225, but the operator enters 1452250.

    I am also attaching the Sample sheet with a month data for Three equipment's.

    The Column in shaded in yellow is the mileage column. Each equipment has a unique fleet number.
    Attached Files Attached Files

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: 06-12-2013, 07:41 AM
  2. Formula to Detect Last Cell in a Column with Data Entered
    By TylerJamison in forum Excel General
    Replies: 5
    Last Post: 06-29-2012, 03:52 PM
  3. Detect if InputBox password already entered in same instance
    By RedWing in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-17-2011, 01:54 PM
  4. [SOLVED] excel spread sheet wont caculate new data entered in ranges.
    By Art-needs-help in forum Excel General
    Replies: 3
    Last Post: 11-08-2005, 10:10 AM
  5. Replies: 2
    Last Post: 09-29-2005, 01:52 AM

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