Multi-row formula with a rank function

[legwu]

Hi,

I have a tricky situation where I need to perform a function on certain groups of the data. That is, if I group the data by a unique combination of fields, then I need to rank the values in a certain field and give the rank position.

I have attached an example of what I mean.

In this example, lets say I wanted to populate the 'Rank' column. This would show me which Branch sold the highest/lowest when grouped by Company Name and Code. Is there a multi-row formula I could use to do this?

My initial idea is to create a list of unique groups, run a macro using Filter, Sort and Record ID. Is there another way

Thanks,

Lincoln

[Aaron_Harter · Accepted solution]

Hi @legwu, 

This is a great use case for the Tile tool, where the Tile_SequenceNum will be your desired Rank:

 

[RolandSchubert · Accepted solution]

Hi @legwu ,

I think, Sort tool and Multi-Row Formula tool do the job ...I've attached a sample workflow.

Let me know if it works for you.

Best,

Roland

[alts2h · Accepted solution]

Hi

Check attached workflow

[legwu]

Thanks for the solutions all, they all work! I have never used the Tile function before, but it is very useful here aswell. Much appreciated.