esProc Desktopesproc-desktop.hashnode.dev·14 hours ago#60 - Find How Many Times Two Specified Members Will Be Contained in A Series of SetsProblem description & analysis: Below is an Excel table recording the groups in a competition. In the range of C1:V13, every 6 columns corresponds to a table having 4 players, and 1-16 represents numbers of 16 players. ABCDEFGHIJKLMNOPQRSTUV118141112...Discussexcl
esProc Desktopesproc-desktop.hashnode.dev·Sep 4, 2024#57 - Concatenate Column Titles Corresponding to Empty CellsProblem description & analysis: An Excel table has column titles, and there are certain empty cells. ABCDEF1stat Astat Bstat Cstat Dstat Estat F2113XX4XXXX56XXX7XXXX8XX For each row, concatenate column titles corresponding to the empty cells with sl...Discussexcel
esProc Desktopesproc-desktop.hashnode.dev·Sep 3, 2024#56 — Get The Same Rows from A TableProblem description & analysis: The Excel table below has 4 columns. If we regard columns from the 2nd to the 4th as a whole, there are duplicates, as shown below: ABCD 1#ProductNon ConfDate 21AppleWorms4-Mar-24 33AppleWorms4-Mar-24 42PearW...Discussexcel
esProc Desktopesproc-desktop.hashnode.dev·Aug 29, 2024#54 - Combine Cell Values of Every 3 Rows under Each Column into One CellProblem description & analysis: The Excel table below has a nonstandard format – every 3 rows correspond to one record and under each row title, every 3 rows correspond to one column, as shown below: ABCDE1FruitBreedShoppriceqty2Musk3LimeLavonne144Me...Discussexcel
esProc Desktopesproc-desktop.hashnode.dev·Aug 28, 2024#53 - Get Desired Data Every N Rows And Combine Them Into One RowProblem description & analysis: We have an Excel table in a non-standard format. Each range of 2 rows 6 columns corresponds to 1 row 3 columns of the standard format. The standard format table will consist of the 1st column of the 1st row or the 1st ...Discussexcel
esProc Desktopesproc-desktop.hashnode.dev·Aug 27, 2024#52 - Get The Last Row of Each GroupProblem description & analysis: An Excel table has three columns, where ID is the grouping column, as shown below: ABC1IDDATEACTION21231/1/2024A31235/1/2024B41236/1/2024C545619/1/2024D64566/1/2024E74567/1/2024F Task: Find the row having the largest ...Discussexcel
esProc Desktopesproc-desktop.hashnode.dev·Aug 23, 2024#50 - Group And Summarize Rows And Add Different Words After Different CountsProblem description & analysis: An Excel table has two columns: AB 1Apples3 2Apples0 3Bananas1 4Bananas6 5Cantaloupe0 6Kiwis2 7Kiwis2 8Kiwis1 Task: Group the table by the 1st column, and add 1 if the 2nd column in the current group is...Discussexcel
esProc Desktopesproc-desktop.hashnode.dev·Aug 22, 2024#49 - Group An EXCEL Table And Concatenate Values of Rows Meeting The Specified ConditionProblem description & analysis: An Excel table has four columns, among which the 2nd one is the grouping column: ABCD 11a1yet 22a2done 33a3yet 44b1done 55b2done 66b3done 77b4yet 88b5done We want to group rows of the table by the 2nd c...Discussexcel
esProc Desktopesproc-desktop.hashnode.dev·Aug 21, 2024#48 - In An Excel Table, Find Rows Corresponding to The 1st And The Last Non-Empty Cells in Each ColumnProblem description & analysis: In the Excel table below, columns from the 2nd to the 6th have empty cells. ABCDEF 1StartDateQID1QID2QID3QID4QID5 210/03/2024 10:561yes32 310/03/2024 03:102no423 409/03/2024 19:253yes22 509/03/2024 11:404no1...Discussexcel
esProc Desktopesproc-desktop.hashnode.dev·Aug 19, 2024#47 - Sort An EXCEL Table According To Custom SegmentsProblem description & analysis: An Excel table has three columns: ABC 1A1B151 2A2B2721 3A3B3382 4A4B49 5A5B573 6A6B6577 7A7B791 8A13B13150 9A14B1449 10A17B17702 11A18B18705 12A34B3433 13A35B35409 14A36B36579 15A37B3710 We want ...Discussexcel
