esProc Desktopesproc-desktop.hashnode.dev·20 hours ago#34 - Remove Duplicates And Compute IntersectionProblem description & analysis: An Excel table has two columns of numbers, and there are duplicates in a column: AB12028230383304544558558 Task: First remove duplicates from the columns and then compute their intersection: D145258 Solution: Use SPL...Discussexcel
esProc Desktopesproc-desktop.hashnode.dev·Jul 25, 2024#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
Valcu Denisroyalcdkeys.hashnode.dev·Jul 21, 2024Selecting the Right Spreadsheet Software: A Detailed GuideSpreadsheet applications are essential tools for businesses, educators, and individuals. They facilitate data organization, analysis, visualization, and more. Whether managing finances or tracking project progress, spreadsheets offer a versatile plat...Discussroyalcdkeys
Vikas Guptavikasfeedingdotnet.hashnode.dev·Jul 20, 2024Excel to SQL Server Data Import: A Step-by-Step GuideAre you looking to transfer data from Excel to SQL Server but don't know where to start? Look no further! I’ve created a detailed step-by-step video tutorial that walks you through the entire process. https://www.youtube.com/watch?v=y1hYCoRJuBc Why...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