Hi,
I am trying to get the maximum number of full weeks if the name matches but it doesn't seem to work appreciate any help
Basically i have 2 tabs of data.
1st tab has
2nd tab
what i am trying to do is a Maxif formula to return the max full weeks from tab 2 in to column E in Tab one if the names match in column A of both tabs everytime i do it i get #Value or 0
I am trying to get the maximum number of full weeks if the name matches but it doesn't seem to work appreciate any help
Basically i have 2 tabs of data.
1st tab has
2nd tab
what i am trying to do is a Maxif formula to return the max full weeks from tab 2 in to column E in Tab one if the names match in column A of both tabs everytime i do it i get #Value or 0