Multi-row formula with a rank function

Question

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

Rank example.xlsx

Aaron_Harter · Accepted Answer

Hi @legwu,

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

RolandSchubert · Accepted Answer

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 Answer

Hi

Check attached workflow