+ Reply to Thread
Results 1 to 2 of 2

having lot of xcel problem

  1. #1
    Registered User
    Join Date
    08-21-2016
    Location
    sri lanka
    MS-Off Ver
    windows 7 ultimate
    Posts
    0

    having lot of xcel problem

    I am just training in a security office.we have guard duty from 10-12 ,12-2,2-4and 4-5 every day.we have 46 recruits in our billet.every one gets his duty chance after every 5 days.i am saving the dates of there guard dutiees before there names in a excel spread sheet.I want some 1 to tell me some formulas and table formats to find the recruits who filled 5days after there last guard duty!!!
    also i ordered the recruit names small to large order,2 of the recruits from small to large go for ROUNDS duty in a day ,so i need a way to find the next 2 guys in the same spread sheet!!helpme

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello avidu,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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. Help with Xcel IF formula
    By stephsa in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-11-2014, 12:50 PM
  2. [SOLVED] .txt to xcel conversion
    By N8237 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-13-2013, 07:16 AM
  3. Greetings Xcel xperts out there
    By Xcelnub in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 05-13-2013, 12:49 PM
  4. Greetings Xcel Gurus!
    By radarzdc in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-18-2012, 07:14 AM
  5. [SOLVED] xcel/Word 2007-mailmerge problem.
    By Bob Tourkow in forum Excel General
    Replies: 1
    Last Post: 07-25-2006, 04:35 AM
  6. [SOLVED] colums in xcel
    By **- kingdom -** in forum Excel General
    Replies: 2
    Last Post: 05-26-2005, 05:15 PM
  7. [SOLVED] xcel question
    By cokeemp in forum Excel General
    Replies: 2
    Last Post: 01-27-2005, 09:06 PM

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