Breaking ties using large and small functions, please read

%3CLINGO-SUB%20id%3D%22lingo-sub-1911178%22%20slang%3D%22en-US%22%3EBreaking%20ties%20using%20large%20and%20small%20functions%2C%20please%20read%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1911178%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20have%20a%20workbook%20that%20uses%20dates%20and%20has%205%20columns%20of%20data.%3C%2FP%3E%3CP%3EThe%20data%20(whole%20numbers)%20are%20listed%20in%20order%20as%20they%20appear%2C%20and%20there%20are%20repeats.%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20rank%20them%20by%20last%20appeared%20dates%2C%20but%20if%20these%20numbers%20happened%20the%20same%20amount%20of%20time%20I%20am%20getting%20stuck.%20It%20looks%20like%20excel%20will%20just%20give%20the%20same%20value%20as%201st%2C%202nd%20etc.%3C%2FP%3E%3CP%3EBoss%20says%20I%20can%20not%20add%20files%2C%20they%20are%20company%20property%20etc.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20suggestions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1911178%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1911548%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ties%20using%20large%20and%20small%20functions%2C%20please%20read%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1911548%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F108882%22%20target%3D%22_blank%22%3E%40Joe%20Weischedel%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHow%20about%20you%20create%20a%20small%20data%20sample%20with%20dummy%20data.%20We%20don't%20need%20to%20see%20the%20original%20if%20a%20sample%20workbook%20with%20dummy%20data%20has%20the%20same%20structure%20and%20shows%20the%20same%20challenges.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1912889%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20ties%20using%20large%20and%20small%20functions%2C%20please%20read%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1912889%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOk%2C%20here%20is%20a%20sample.%3C%2FP%3E%3CP%3EThere%20are%20repeats%2C%20and%20I%20am%20trying%20to%20break%20the%20ties%2C%20then%20list%20.%3CBR%20%2F%3ESo%2C%20if%20say%20300%20happens%20the%20same%20%23%20of%20times%20as%20400%2C%20I%20would%20want%20one%20to%20be%20%231%2C%20another%20%232%20etc.%3CBR%20%2F%3EThanks%20in%20advance%20for%20any%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi,

I have a workbook that uses dates and has 5 columns of data.

The data (whole numbers) are listed in order as they appear, and there are repeats.

I am trying to rank them by last appeared dates, but if these numbers happened the same amount of time I am getting stuck. It looks like excel will just give the same value as 1st, 2nd etc.

Boss says I can not add files, they are company property etc.

 

Any suggestions?

 

2 Replies
Highlighted

Hello @Joe Weischedel ,

 

How about you create a small data sample with dummy data. We don't need to see the original if a sample workbook with dummy data has the same structure and shows the same challenges.

Highlighted

@Ingeborg Hawighorst 

 

Ok, here is a sample.

There are repeats, and I am trying to break the ties, then list .
So, if say 300 happens the same # of times as 400, I would want one to be #1, another #2 etc.
Thanks in advance for any help