SOLVED

Data in the correct order

%3CLINGO-SUB%20id%3D%22lingo-sub-1417822%22%20slang%3D%22en-US%22%3EData%20in%20the%20correct%20order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1417822%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20be%20able%20to%20see%20in%20what%20order%20for%20example%20the%20letter%20a2%20a3%20a%204%20a%206%20and%20a1%20is%20used%20in%20a%20vertical%20column.%3C%2FP%3E%3CP%3EIn%20this%20column%20are%20many%20other%20data%20without%20an%20%22a%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20someone%20can%20help%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1417822%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1417827%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20in%20the%20correct%20order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1417827%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F679877%22%20target%3D%22_blank%22%3E%40Jan_Z10myusername%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20post%20a%20small%20example%20dataset%20together%20with%20expected%20results%3F%20Make%20clear%20which%20cells%20within%20the%20worksheet%20are%20being%20used.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1417861%22%20slang%3D%22en-US%22%3ERE%3A%20Data%20in%20the%20correct%20order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1417861%22%20slang%3D%22en-US%22%3EHer%20is%20an%20example%20Data%20Result%203a6%2B%203a6%2B%204s1%2B%203a4r%2012vh4%2B%20311a35%2B%206so1%203a4r%2011b2%2B%206vp3%2B%20311a35%2B%20Every%20code%20with%20an%20a%20is%20selected%20an%20put%20in%20de%20correct%20order%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1417877%22%20slang%3D%22en-US%22%3ERE%3A%20Data%20in%20the%20correct%20order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1417877%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F679877%22%20target%3D%22_blank%22%3E%40Jan_Z10myusername%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%20but%20I'm%20afraid%20it's%20not%20clear%20which%20cells%20in%20the%20worksheet%20those%20entries%20are%20in.%20Can%20you%20clarify%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1417889%22%20slang%3D%22en-US%22%3ERE%3A%20Data%20in%20the%20correct%20order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1417889%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F676180%22%20target%3D%22_blank%22%3E%40Jos_Woolley%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EColumn%20A%20is%20the%20column%20the%20entrys%20are%20put%20in%20and%20I%20ope%20i%20can%20see%20in%20wich%20order%20all%20entrys%20with%20the%20letter%20a%20are%20used%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGrt.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1417919%22%20slang%3D%22en-US%22%3ERE%3A%20Data%20in%20the%20correct%20order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1417919%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F679877%22%20target%3D%22_blank%22%3E%40Jan_Z10myusername%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20afraid%20it's%20still%20not%20clear.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet's%20start%20again.%20Give%20me%20a%20%3CSTRONG%3Ebefore%3C%2FSTRONG%3E%20and%20%3CSTRONG%3Eafter%3C%2FSTRONG%3E%2C%20clearly%20specifying%20what%20values%20you%20have%20in%20what%20cells.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EBefore%20(what%20you%20have%20now%3CU%3E)%3C%2FU%3E%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecell%20A1%3A%20x%3C%2FP%3E%3CP%3Ecell%20A2%3A%20y%3C%2FP%3E%3CP%3Ecell%20A3%3A%20z%3C%2FP%3E%3CP%3E...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EAfter%20(what%20you%20want%20to%20see%3CU%3E)%3C%2FU%3E%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecell%20A1%3A%20z%3C%2FP%3E%3CP%3Ecell%20A2%3A%20x%3C%2FP%3E%3CP%3Ecell%20A3%3A%20y%3C%2FP%3E%3CP%3E...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBetter%20still%2C%20post%20an%20actual%20workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1417967%22%20slang%3D%22en-US%22%3ERE%3A%20Data%20in%20the%20correct%20order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1417967%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F676180%22%20target%3D%22_blank%22%3E%40Jos_Woolley%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20a%20list%20of%20data%20that%20I%20have%20made.%3C%2FP%3E%3CTABLE%20width%3D%2289%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E2b2%2B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E11b2%2B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E6s6%2B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E6s6%2B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E7b4%2B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E6s1%2B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E11rp%2B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E107a4p0%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E7b4-%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E2b4-%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E6sp1%2B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E107a4r-%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E12sp6%2B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E102a31b-%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E2s60%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E10vp3%2B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E2s60%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E2s5%2B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E2s60%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E6vh2%2B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E107a4d0%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E2s5-%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E2u%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E12sp1-%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E2vp2%2B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E106a6%2B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E12vp4%2B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E1011a2d%2B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E11s1%2B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E11vh4%2B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E107a4p%2B%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E7b40%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E11b40%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E6rp0%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E1011a3p0%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIk%20would%20like%20to%20know%20all%20the%20data%20with%20an%20%E2%80%9Ca%E2%80%9Din%20it%20in%20proper%20order%3A%20Result%3A%3C%2FP%3E%3CP%3E107a4p0%3C%2FP%3E%3CP%3E107a4r-%3C%2FP%3E%3CP%3E102a31b-%3C%2FP%3E%3CP%3E102a31b-%3C%2FP%3E%3CP%3E107a4d0%3C%2FP%3E%3CTABLE%20width%3D%2289%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2289%22%3E%3CP%3E1011a2d%2B%3C%2FP%3E%3CP%3E107a4p%2B%3C%2FP%3E%3CP%3E1011a3p0%3C%2FP%3E%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThese%20are%20dat%20of%20a%20volleybal%20game.%20Nr%2010%20is%20the%20setter%20and%20I%20want%20to%20find%20or%20there%20is%20a%20pattern%20in%20the%20way%20the%20setter%20plays.%3C%2FP%3E%3CP%3EA%204%20%E2%80%93%20A2%20%E2%80%93%20A%203%20are%20positions%20at%20the%20net.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGrt.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1418030%22%20slang%3D%22en-US%22%3ERE%3A%20Data%20in%20the%20correct%20order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1418030%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F679877%22%20target%3D%22_blank%22%3E%40Jan_Z10myusername%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%20Based%20on%20a%20range%20%3CSTRONG%3EA1%3AA35%3C%2FSTRONG%3E%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000080%22%3E%3CSTRONG%3E%3DIF(ROWS(%241%3A1)%26gt%3BCOUNTIF(A%241%3AA%2435%2C%22*a*%22)%2C%22%22%2CINDEX(A%241%3AA%2435%2CAGGREGATE(15%2C6%2C(ROW(A%241%3AA%2435)-MIN(ROW(A%241%3AA%2435))%2B1)%2FSEARCH(%22a%22%2CA%241%3AA%2435)%5E0%2CROWS(%241%3A1))))%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20copied%20down.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1418534%22%20slang%3D%22en-US%22%3ERE%3A%20Data%20in%20the%20correct%20order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1418534%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F676180%22%20target%3D%22_blank%22%3E%40Jos_Woolley%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help.%3C%2FP%3E%3CP%3EAfter%20copy%20%2F%20paste%20there%20was%20an%20error%20message%3C%2FP%3E%3CP%3EMaybe%20I%20will%20have%20to%20translate%20%22count%22%20etc.%20into%20Dutch.%3C%2FP%3E%3CP%3EI%20will%20try%20that.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGrt.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1418666%22%20slang%3D%22en-US%22%3ERE%3A%20Data%20in%20the%20correct%20order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1418666%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F679877%22%20target%3D%22_blank%22%3E%40Jan_Z10myusername%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYes%2C%20of%20course%2C%20if%20you're%20not%20using%20an%20English%20language-version%20of%20Excel%20then%20you'll%20need%20to%20do%20that.%20I%20always%20use%20this%20online%20Excel%20translation%20tool%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fen.excel-translator.de%2Ftranslator%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fen.excel-translator.de%2Ftranslator%2F%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhich%2C%20in%20this%20case%2C%20gives%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000080%22%3E%3CSTRONG%3E%3DALS(RIJEN(%241%3A1)%26gt%3BAANTAL.ALS(A%241%3AA%2435%3B%22*a*%22)%3B%22%22%3BINDEX(A%241%3AA%2435%3BAGGREGAAT(15%3B6%3B(RIJ(A%241%3AA%2435)-MIN(RIJ(A%241%3AA%2435))%2B1)%2FVIND.SPEC(%22a%22%3BA%241%3AA%2435)%5E0%3BRIJEN(%241%3A1))))%3C%2FSTRONG%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20should%20also%20have%20mentioned%20that%20this%20won't%20work%20for%20you%20if%20you're%20using%20Excel%202007%20or%20earlier.%20I%20can%20provide%20you%20with%20an%20alternative%20formula%20if%20that's%20the%20case.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1420210%22%20slang%3D%22en-US%22%3ERE%3A%20Data%20in%20the%20correct%20order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1420210%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F676180%22%20target%3D%22_blank%22%3E%40Jos_Woolley%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDear%20Jos%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20translated%20the%20code%20and%20now%20it%20is%20working%20correctley.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGrt.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1420217%22%20slang%3D%22en-US%22%3ERE%3A%20Data%20in%20the%20correct%20order%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1420217%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F679877%22%20target%3D%22_blank%22%3E%40Jan_Z10myusername%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Jan%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGlad%20to%20hear%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJos%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

I would like to be able to see in what order for example the letter a2 a3 a 4 a 6 and a1 is used in a vertical column.

In this column are many other data without an "a .

 

I hope someone can help me.

11 Replies
Highlighted

@Jan_Z10myusername 

 

Can you post a small example dataset together with expected results? Make clear which cells within the worksheet are being used.

 

Regards

Highlighted
Her is an example Data Result 3a6+ 3a6+ 4s1+ 3a4r 12vh4+ 311a35+ 6so1 3a4r 11b2+ 6vp3+ 311a35+ Every code with an a is selected an put in de correct order
Highlighted
Best Response confirmed by Jan_Z10myusername (Occasional Contributor)
Solution

@Jan_Z10myusername 

 

Thanks, but I'm afraid it's not clear which cells in the worksheet those entries are in. Can you clarify?

 

Regards

Highlighted

@Jos_Woolley 

 

Column A is the column the entrys are put in and I ope i can see in wich order all entrys with the letter a are used,

 

Grt.

 

Jan

Highlighted

@Jan_Z10myusername 

 

I'm afraid it's still not clear.

 

Let's start again. Give me a before and after, clearly specifying what values you have in what cells.

 

For example:

 

Before (what you have now)

 

cell A1: x

cell A2: y

cell A3: z

...

 

After (what you want to see)

 

cell A1: z

cell A2: x

cell A3: y

...

 

Better still, post an actual workbook.

 

Regards

Highlighted

@Jos_Woolley 

This is a list of data that I have made.

2b2+

11b2+

6s6+

6s6+

7b4+

6s1+

11rp+

107a4p0

7b4-

2b4-

6sp1+

107a4r-

12sp6+

102a31b-

2s60

10vp3+

2s60

2s5+

2s60

6vh2+

107a4d0

2s5-

2u

12sp1-

2vp2+

106a6+

12vp4+

1011a2d+

11s1+

11vh4+

107a4p+

7b40

11b40

6rp0

1011a3p0

 

Ik would like to know all the data with an “a”in it in proper order: Result:

107a4p0

107a4r-

102a31b-

102a31b-

107a4d0

1011a2d+

107a4p+

1011a3p0

 

These are dat of a volleybal game. Nr 10 is the setter and I want to find or there is a pattern in the way the setter plays.

A 4 – A2 – A 3 are positions at the net.

 

Grt.

 

Jan

Highlighted

@Jan_Z10myusername 

 

Thanks. Based on a range A1:A35:

 

=IF(ROWS($1:1)>COUNTIF(A$1:A$35,"*a*"),"",INDEX(A$1:A$35,AGGREGATE(15,6,(ROW(A$1:A$35)-MIN(ROW(A$1:A$35))+1)/SEARCH("a",A$1:A$35)^0,ROWS($1:1))))

 

and copied down.

 

Regards

Highlighted

@Jos_Woolley 

 

Thank you for your help.

After copy / paste there was an error message

Maybe I will have to translate "count" etc. into Dutch.

I will try that.

 

Grt.

 

Jan

Highlighted

@Jan_Z10myusername 

 

Yes, of course, if you're not using an English language-version of Excel then you'll need to do that. I always use this online Excel translation tool:

 

https://en.excel-translator.de/translator/ 

 

which, in this case, gives:

 

=ALS(RIJEN($1:1)>AANTAL.ALS(A$1:A$35;"*a*");"";INDEX(A$1:A$35;AGGREGAAT(15;6;(RIJ(A$1:A$35)-MIN(RIJ(A$1:A$35))+1)/VIND.SPEC("a";A$1:A$35)^0;RIJEN($1:1))))

 

I should also have mentioned that this won't work for you if you're using Excel 2007 or earlier. I can provide you with an alternative formula if that's the case.

 

Regards

Highlighted

@Jos_Woolley 

 

Dear Jos,

 

I have translated the code and now it is working correctley.

 

Thank you very much,

 

Grt.

 

Jan

Highlighted

@Jan_Z10myusername 

 

Hi Jan,

 

Glad to hear it.

 

Cheers,

 

Jos