Search results

Hi Luke Yes I have checked all the absolute references and they are the same in every row But I have 5 columns A,B,C,D,E and column F is the trophies column the formula I have is =COUNTIFS($A$2:$A$1250,$I3,$G$2:$G$1250,J$2) it wont allow me to go A$2:E$274. so I think it is not looking at...

Hi NARAYANKA 911 I have tried that formula you gave me to download and I have got it to do the first row Member 1 and that appears to be right i have checked it manually. But it does not do the rest Members 2,3,4,5,etc etc it just enter snippets and the rest of them are complete blanks (0)...

Hi Luke Well I have tried that formula just now and all I get is zeros(0).I have another formula which I made several months ago for finding pairs (how often 1 member played with another) i.e.member 1 playing with member 25,40,50,60,etc and that worked fine but it does not work on this...

Hi Luke M The data I am posting is the (Data Input) not the desired output. I am assuming it would end up as an array formula. something like this. -----1---2---3---4---5---6---7---8---9---10---11---12---13---14---15-Tophies Mems 1----2---0---1---0---3---0---2---1--etc...

Hi Luke no members 25,38,71,88,94 are just examples. The idea is to find out how many times they have won trophies 1,2,3,4,5 etc and the same with all the members. For example member 25 could have won trophy 1 say 3 times and trophy 4 Twice and so on for all the others.

Hi Last try at this ¬ Members¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬¬Trophies¬ ¬ A¬ B¬ ¬C¬ ¬D¬ ¬E¬¬¬¬¬¬¬¬¬¬¬¬¬¬F¬ ¬ 25 38¬71¬¬88¬¬94¬¬¬¬¬¬¬¬¬¬¬¬¬1¬ ¬ 18¬43¬95¬¬62¬¬¬7¬¬¬¬¬¬¬¬¬¬¬¬¬2¬ ¬¬1¬14¬57¬¬44¬¬184¬¬¬¬¬¬¬¬¬¬¬¬3¬ ¬ 41¬55¬32¬¬77¬¬15¬¬¬¬¬¬¬¬¬¬¬¬¬4¬ ¬ 10¬66¬81¬¬68¬¬98¬¬¬¬¬¬¬¬¬¬¬¬¬5¬ lets see if that works

Hi Luke One more try Members Trophies A B C D E F 25 38 71 88 94 1 18 43 95 62 7 2 1 14 57 44 184 3 41 55 32 77 15 4 10 66 81 68 98 5 HOPE THAT DOES IT.

Hi Luke M Well here goes with another effort lets see If I can get it right Members Trophies A B C D E F 25 38 71 88 94 1 18 43 95 62 7 2 1 14 57 44 184 3 41 55 32 77 15 4 10 66...

Hi NARAYANK991 Yes I have tried that but to no avail i had figures of 0,38 and one of 274 I don't think that is right somehow. All I want really is some way I can find out how many times members in columns A,B,C,D,E have won the various trophies in column F. I have 5 columns because to list...

Hi there it seems that when I put in the layout it just all crams up together but to try and give you the idea it is column A B C D E 8 26 28 31 82 and column F 1 I hope that comes out right

Hi Luke M and NARAYANK991 It seems as though my layout has got somewhat messed up it should be like this Members Trophies 8 26 28 31 82 1 13 4 8 20 33 2 7 16 19 83 126 3 1 61 20 17 30 4 3 14 94 20 76 5 5 So I...

Hi there I am new on here and also pretty new to Excel.I have a problem.I was wondering if someone Could help me out with this I am on a Golf committee and I have been given the task of finding Out the solution to this.We have some 2-3hundred members and we play for 15 different trophies A...