awesome !!!!!! Great !!!11 On Wed, Apr 4, 2012 at 10:20 AM, Maries <talk2mar...@gmail.com> wrote:
> 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> >> [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 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. >> >> -- >> 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
