Nice solution marries J
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Maries Sent: Apr/Wed/2012 10:20 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need assistance in finding formula to substitute the values to dates. Hi, PFA. Use below Array formula, =IFERROR(INDEX($B$4:$E$4,MATCH(B$9,OFFSET($A$4,MATCH($A10,$A$5:$A$7,0),1,1,4 ),0)),"") Regards, MARIES. On Wed, Apr 4, 2012 at 7:16 AM, rekha siri <rekha.siri2...@gmail.com> wrote: Hi I need assistance in finding the right formula to substitute the value to dates in <countif> Alexei De Guzman <https://thehub.thomsonreuters.com/people/0143599/avatar/46.png?a=13303> Just Joined <https://thehub.thomsonreuters.com/5.0.2/images/status/statusicon-47.gif> <https://thehub.thomsonreuters.com/people/0143599> Alexei De Guzman 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 Guzman VL Joseph Roxas SL Kelly Furio H Name VL H SL Alexei de Guzman April 1 Joseph Roxas April 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. <https://thehub.thomsonreuters.com/5.0.2/images/emoticons/happy.gif> -- 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 -- 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 -- 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
