LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 1st 16, 03:27 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
Formula for call out list Mcal45usn New Users to Excel 0 November 1st 16 03:19 PM
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 01:02 AM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017