多条件数据相同数量排序问题

客户名称大类性别款号颜色品名订单数量AWG服装男29190370浅灰羽绒服80AWG服装男29510169黑保暖长裤64AWG服装男29190370藏兰羽绒服60AWG服装男29190324黑羽绒服46AWG服装女28190379玫红羽绒服40AWG服装男29190324褐羽绒服36AWG服装男29190434深红羽绒服36AWG服装男29190434深兰羽绒服36AWG服装男29630727黑针织长裤32AWG服装男29630727深花灰针织长裤32AWG服装女28190379宝兰羽绒服32AWG服装男29051162桔红卫衣30AWG服装男29051162浅花灰卫衣30AWG服装男29051173宝兰卫衣30AWG服装男29051173枣红卫衣30AWG服装男29190353宝兰羽绒服30AWG服装男29190353黑羽绒服30AWG服装男29190365深兰羽绒服30AWG服装男29190365枣红羽绒服30AWG服装男29190432黑羽绒服30AWG服装男29190432深红羽绒服30AWG服装女28630759玫红针织长裤30AWG服装女28630759浅花灰针织长裤30AWG服装女28630772宝兰针织长裤30AWG服装女28051146浅花灰卫衣28AWG服装女28051146深红卫衣28AWG服装女28051159桔红卫衣26AWG服装女28051159浅花灰卫衣26AWG服装女28630772浅花灰针织长裤26AWG服装女28180889深红厚棉服24AWG服装女28051115宝兰卫衣24AWG服装女28051115浅花灰卫衣24AWG服装女28190402玫红羽绒服24AWG服装女28190420翠绿羽绒服24AWG服装女28190420桔红羽绒服24AWG鞋类男19370735黑兰棉鞋144AWG鞋类男19370673黑兰棉鞋120AWG鞋类男19370676兰红棉鞋120AWG鞋类男19370677兰黑棉鞋96AWG鞋类男19370680兰白棉鞋96AWG鞋类男19370673灰黑棉鞋72AWG鞋类男19370676灰兰棉鞋72AWG鞋类男19370738兰灰棉鞋72AWG鞋类女18370679灰紫棉鞋72AWG鞋类男19120879黑灰篮球鞋48案例是按照客户，大类对订量做排名AWG鞋类男19120893兰灰篮球鞋48AWG鞋类男19370669黑桔棉鞋48AWG鞋类男19370669棕黑棉鞋48AWG鞋类男19370735红白棉鞋48AWG鞋类男19370738棕黄棉鞋48AWG鞋类男19370912红黑棉鞋48AWG鞋类男19370912灰黑棉鞋48AWG鞋类男19392370灰红都市系列48AWG鞋类男19392370兰红都市系列48AWG鞋类男19115625灰兰跑鞋48AWG鞋类男19115625兰桔跑鞋48AWG鞋类男19115861黑红跑鞋48AWG鞋类男19115861兰跑鞋48AWG鞋类男19325288红黄休闲鞋48AWG鞋类男19325288灰黑休闲鞋48AWG鞋类女18370679兰白棉鞋48AWG鞋类女18370679紫白棉鞋48AWG鞋类女18370752红灰棉鞋48AWG鞋类女18370752紫灰棉鞋48AWG鞋类女18115861黑红跑鞋48AWG鞋类女18115861红绿跑鞋48AWG鞋类女18325113红休闲鞋48AWG鞋类女18325113灰月休闲鞋48FGC服装男29510178黑保暖长裤70FGC服装女28190452桔红羽绒服70FGC服装男29190370藏兰羽绒服60FGC服装男29190370浅灰羽绒服60FGC服装男29190409黑羽绒服50FGC服装男29190324黑羽绒服50FGC服装男29190341藏兰羽绒服50FGC服装男29190341黑羽绒服50FGC服装男29630752黑针织长裤50FGC服装男29190445深兰羽绒服50FGC服装男29630763中花灰针织长裤50FGC服装男29510169黑保暖长裤50FGC服装女28180891藏兰厚棉服50FGC服装女28180891橙色厚棉服50FGC服装男29180876深兰厚棉服40FGC服装男29190344黄绿羽绒服40FGC服装男29190353宝兰羽绒服35FGC服装男29190353墨绿羽绒服35FGC服装男29190409枣红羽绒服30FGC服装男29190464宝兰羽绒服30FGC服装男29350224黑针织套装（裤子）30FGC服装男29630725黑针织长裤30FGC服装男29630731深花灰针织长裤30FGC服装男29051162藏兰卫衣30FGC服装男29051162浅花灰卫衣30FGC服装男29190341暗红羽绒服30FGC服装男29630752深花灰针织长裤30FGC服装男29190353黑羽绒服30FGC服装男29190445桔黄羽绒服30FGC服装男29051129海兰卫衣30FGC服装男29180876海兰厚棉服30FGC服装男29180876深红厚棉服30FGC服装女28630764黑针织长裤30FGC服装女28051159浅花灰卫衣30FGC服装女28190402黑羽绒服30FGC服装女28190402玫红羽绒服30FGC服装女28190420桔红羽绒服30FGC服装女28630734黑针织长裤30FGC服装男29190464黑羽绒服20FGC服装男29190324褐羽绒服20FGC服装男29630703深花灰针织长裤20FGC服装男29630703深兰针织长裤20FGC服装男29051175浅花灰卫衣20FGC服装男29051175深花灰卫衣20FGC服装男29051175深灰兰卫衣20FGC服装男29630702深花灰针织长裤20FGC服装女28190429浅绿羽绒服20FGC服装女28051176藏兰卫衣20FGC服装女28051176桔红卫衣20FGC服装女28190359黑羽绒服20FGC服装女28190359米白羽绒服20FGC服装女28190415黑羽绒服20FGC服装女28190415桔红羽绒服20FGC服装女28051120深红卫衣20FGC服装女28190420翠绿羽绒服20FGC服装女28190452黑羽绒服20FGC服装女28051146浅花灰卫衣16FGC服装女28051146深红卫衣16FGC服装男29630731深兰针织长裤15订单吊牌金额排序1排序2排序3排序3辅助列方法1相同数量得到相同排序号，但会占用下面的位数3752011180.00000002方法2解决了方法1的问题，根据相同数量出现的顺序人为赋予其一个顺序，但前提是需要先对数据源进行整体排序1145622264.00000003方法3与方法2逻辑基本相同，由数据出现的行数赋予原数值一个新的参照值，好处是不需要提前做排序2814033360.000000043355244446.000000052156055540.000000062516466836.000000071940467736.000000081940468636.000000098288991132.0000001082889101032.0000001117248911932.00000012777012122430.00000013777012132330.00000014897012142230.00000015897012152130.000000161497012162030.000000171497012171930.000000181707012181830.000000191707012191730.000000201617012201630.000000211617012211530.00000022717012221430.00000023717012231330.00000024717012241230.00000025557225252628.00000026557225262528.00000027621427272926.00000028621427282826.00000029621427292726.000000301293630303524.00000031717630313424.00000032717630323324.000000331197630333224.000000341197630343124.000000351197630353024.0000003645936111144.0000003740680223120.0000003840680232120.000000393254444596.000000403254445496.000000412440866972.000000422440867872.000000432872868772.000000442296869672.000000451915210103348.000000462107210113248.000000471915210123148.000000481915210133048.000000491531210142948.000000501915210152848.000000511531210162748.000000521531210172648.000000531915210182548.000000541915210192448.000000551627210202348.000000561627210212248.000000572107210222148.000000582107210232048.000000591771210241948.000000601771210251848.000000611531210261748.000000621531210271648.000000631627210281548.000000641627210291448.000000651915210301348.000000661915210311248.000000671531210321148.000000681531210331048.000000691533011270.000000703493012170.000000712814033460.000000722814034360.0000007324950551450.0000007434950561350.0000007524950571250.0000007624950581150.0000007712950591050.0000007823450510950.0000007911950511850.000000808950512750.0000008123450513650.0000008223450514550.000000831756015151640.000000842396015161540.000000851746517171835.000000861746517181735.000000871497019193830.000000881497019203730.00000089777019213630.00000090837019223530.00000091777019233430.00000092777019243330.00000093777019253230.000000941497019263130.00000095777019273030.000000961497019282930.000000971407019292830.00000098657019302730.000000991317019312630.000001001317019322530.00000101717019332430.00000102717019342330.000001031497019352230.000001041497019362130.000001051497