Apply max of a column to all rows

[timioluwatimi]

Here is what my  data looks like. The "Rank" column was created using the multi-row tool. The next step is to apply the maximum rank by state to each  row by state as in the "Apply Max Rank" column. Any ideas how I can do this?

[Luke_C]

Hi @timioluwatimi 

Use a summarize tool to group by State and get the Max Rank. Then join back to the dataset on state. If you post the data itself (not a screenshot) I can help mock this up, just don't have the energy to re-type it all.

[Maskell_Rascal]

Hi @timioluwatimi 

To visualize the answer that @Luke_C provided, your workflow would look like this:

Attached is a mockup for you to try. 

Cheers!

Phil