Hi there - I am copy and pasting data from a website (player statistics) and have a Median(IF statement set up that works great, however I am having issues when typing my player name (which is used as the 'if'). I have no worries when copying the player's name and pasting from the raw data into the a3 cell the reference is currently set up for, but if I type the player name (exactly the same, time and time again), I get #NUM! error on the pending formulas because the initial median(if formula cannot find the player in the raw data - even though it is absolutely there.
I also have issues when searching the raw data for players names. Often times they will not show up - leading me to think that there is obviously something askew in the raw data names, however I have no way of finding it and have combed through with my arrows keys to count spaces etc.
Any help would be greatly appreciated!!
I also have issues when searching the raw data for players names. Often times they will not show up - leading me to think that there is obviously something askew in the raw data names, however I have no way of finding it and have combed through with my arrows keys to count spaces etc.
Any help would be greatly appreciated!!