So I am trying to complete a set of geoprocessing tasks on some large scale data for several states. Right now I am stuck on the last little stretch I need to get to my final rankings of this data. I have a column in a attribute table of a shapefile of normalized data called "Normalized_Linear", I want to take the min and max values for the entire attribute field "Normalized_Linear" and apply those numbers to two entire temporary attribute fields (Normalized_MIN and Normalized_MAX) for later calculations but I am not sure of how to go about this. Part of me wants to be able to just use field calculator and should be a simple quick little code block but I am not aware of how to pull this off or the min function in Calculate Field takes the minimum value of multiple fields (columns) for one row and not the overall min or max of the attribute column.
My next thought step is tho use the Statistics and find the min and max values for my Normalized_Linear attribute field but this then creates a standalone table of one row with columns of max and min, is there a way I can populate the temporary Normalized_MIN and Normalized_MAX automatically based off the value of another tables cell?