I've used sumif for table 1 to extract the data but want to create table 2 which only shows a teams win loss record against a specific team. Ideally I would like to select the ranges that cover the whole season and extract the wins and losses that Jacksonville have with Carolina for example. In turn I will do this with the rest of the teams as well.
Last edited by Laurence1965; 09-21-2011 at 09:03 AM.
Change B26 to say only "Carolina", then try similar formula to what you have:
and
Please Login or Register to view this content.
Please Login or Register to view this content.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Originally Posted by NBVC
Change B26 to say only "Carolina", then try similar formula to what you have:
andPlease Login or Register to view this content.
Please Login or Register to view this content.
Hello again,
Thanks for your response. I Changed B26 to just say Carolina and cut and pasted both of the codes. I then changed one of the results so that Carolina beat Jacksonville twice but the win loss boxes stayed at 1 1 instead of changing to 2 0. If we can get it to work it would be a perfect solution.
Sorry... still early in the morning
try:
andPlease Login or Register to view this content.
Please Login or Register to view this content.
That worked perfectly. Thank you very much for your help.
I hope that you have a good day.
Laurence
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks