esProc Desktopesproc-desktop.hashnode.dev·3 hours ago#33 -Find The Differences Between Contents of Two CellsProblem description & analysis: In the following Excel table, cell A1 and cell B1 contain strings made up of vertical line-separated numbers and walled in by vertical lines at both ends: AB 1|55|56|60|99|120||55|56|62|100|121|130|210|312| Ta...Discussexcel
esProc Desktopesproc-desktop.hashnode.dev·Jul 24, 2024#32 - Find The First Cell Value Meeting The Specified ConditionProblem description & analysis: In the table below, the 1st column is subject and columns after it are test scores arranged in order. ABCDE 1Art03.676.27.8 2History3.786.217.29.8 3Maths5.66.36.68.9 Task: Specify a subject and a score and, ...Discussexcel
esProc Desktopesproc-desktop.hashnode.dev·Jul 23, 2024#31 - Write The First Lines of Multiples CSV Files to ExcelProblem description & analysis: There are multiple csv files of same structure in a certain directory: stock_301500.csvstock_320688.csv CODE,DT,OP,CL 301500,2023-06-02,71,67.8 301500,2023-06-05,79.35,72.61 301500,2023-06-06,75.8,77.65CODE,DT,O...Discussexcel
esProc Desktopesproc-desktop.hashnode.dev·Jul 23, 2024#30 - Align Rows of Data To A Specified ColumnProblem description & analysis: Table A-C has multiple rows of data, where certain rows are empty; and column C has duplicate values. Values of column E are unique; they correspond to certain values of column C, but there are inconsistent letter case...Discussexcel
esProc Desktopesproc-desktop.hashnode.dev·Jul 19, 2024#29 - Group an Excel table and Store It as Multiple Files According to Part of The Values of Specified CellsProblem description & analysis: The Excel table below is ordered by column A, whose values are strings separated by "-". The first part of column A represents the category. ABCDEFGHIJ 1AA-01-02972357769 2AA-01-038662212108 3AA-01-04323667988...Discussexcel
esProc Desktopesproc-desktop.hashnode.dev·Jul 18, 2024#28 - Combine Two Tables With Different Column HeadersProblem description & analysis: Here are two Excel "named ranges", which are Events1 and Events2 respectively. Starting from the 2nd row, both can be regarded as a table with column headers and some of their headers are same. Column1Column2Column...Discuss·10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Jul 17, 2024#27 - Group and Summarize A Table Where Every N Rows Consist of A Range by ColumnProblem description & analysis: Below is an Excel table. Every two rows form a range; and in each range, each pair of cells up and down is regarded as a piece of data that stores client and working hours that can be empty. ABCDEFG 1AlphaAlph...Discuss·10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Jul 16, 2024#26 — Get Two Numbers from Each of The Two Sets of Numbers and Let Them Equal A Specified ValueProblem description & analysis: We have two rows of numbers: ABCDEFG142111404209106420997442113204208228421087342114392885999089033548900184890192289000528903899 Get two numbers from each row (the two numbers can be the same) and make the sum of the...Discuss·10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Jul 15, 2024#25 - Write Continuous Numbers in A String of Numbers as IntervalsProblem description & analysis: In an Excel worksheet, a cell contains a string made up of an ordered integer sequence. There are missing numbers, and the sequence is not continuous: 1,2,3,4,5,6,7,8,9,13,14,15,16,17,18,25,26,27,28,29,30,31,32 We want...Discuss·10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Jul 15, 2024#24 — Repeat the Value of Each Cell N times According to the Value of the Neighboring cellProblem description & analysis: The table below has two columns, where column B is the number. We need to repeat the value of column A N times according to the value of column B and concatenate the results into one column. Solution: Use SPL XLL to ...Discussexcel