A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » New Users to Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Formula for call out list



 
 
Thread Tools Display Modes
  #1  
Old November 1st 16, 03:19 PM
Mcal45usn Mcal45usn is offline
Junior Member
 
First recorded activity by ExcelBanter: Nov 2016
Posts: 2
Default Formula for call out list

Hello,

I have a workbook with 31 sheets (1 for each day of a month) then I have one sheet listing on A3:A161 names of specific individuals.

On each day, we recieve call outs (not coming in) from some of those individuals. I then record their name in that days sheet depending on order of call in A6:A44 (we usually get no more than 10 a day).

What im trying to do is, everytime I enter a specific name on the days sheet, i want a column where it is an updated tally of how many times they have already called in.

Example, if chris calls out on the 1st, 6th and 10th, When I enter his name on hte 10th, I want the next column to say "3" and then so on.

Is there anyway to do this?
Ads
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Run or Call a sub from the list of subs in a drop down. Howard Excel Programming 8 September 30th 13 04:09 PM
Call List Macro bldgmaterialguy Excel Programming 0 May 12th 10 08:53 PM
how do I put the do not call list in excel...does not fit scorm Excel Discussion (Misc queries) 2 August 23rd 06 05:22 PM
Call list length in formula steev_jd Excel Discussion (Misc queries) 2 May 17th 06 10:11 AM


All times are GMT +1. The time now is 10:29 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.