Hi I need assistance in finding the right formula to substitute the value to dates in <countif> [image: Alexei De Guzman][image: Just Joined] *Alexei De Guzman <https://thehub.thomsonreuters.com/people/0143599>* Apr 3, 2012 9:03 PM
Hi, I am trying to come up with the formula to pull up dates from a tracker for each individual. Example: *Name **April 1 **April 2 **April 3**April 4 *Alexei de GuzmanVLJoseph RoxasSLKelly FurioH *Name**VL**H**SL*Alexei de GuzmanApril 1Joseph RoxasApril 3 So I am making a summary tracker that will break it down by dates for each name. I have tried using Countif for a particular value but I have been looking for a formula to come up to pull it up by dates. I hope someone already knows the answer. Thank you very much. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
