LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 1st 16, 04:19 PM
Junior Member
First recorded activity by ExcelBanter: Nov 2016
Posts: 2
Default Formula for call out list


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?

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

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 02:14 PM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017