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
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
anthony akpankromate.hashnode.dev·Jul 13, 2024Linking HTML Forms Directly to Google Spreadsheet for Data CollectionIf you would prefer a video check it out on youtube at https://www.youtube.com/watch?v=OQ71aox42aI HTML forms are one part of the frontend development cycle that every web developer has had to deal with at one point or another in their career, and ...DiscussHTML5
esProc Desktopesproc-desktop.hashnode.dev·Jun 26, 2024In Excel, Re-arrange A Sequence N Times RandomlyProblem description & analysis: Column A is a random sequence. Cell B2 contains the parameter that represents the number of times of re-arranging members of the sequence. AB 1ItemsReplicates 2A2 3B 4C 5D We need to rearrange column A N t...Discuss·10 likes#Excel-tutorial
esProc Desktopesproc-desktop.hashnode.dev·Jun 18, 2024In Excel, combine multiple detail data columns into one row in each groupProblem description & analysis: The following Excel table has a grouping column and two detailed data columns. ABC1ObjectNameInfo212AGggtz44456312AGggtr99987412AKkkio66543512ABbvgf66643612AVvvhg888765712AFffgt8786FGggtf23232596FXxxde44321610P23Cccvb5...Discuss·10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Jun 11, 2024In Excel, Generate a List of All Days of the Month Where a Specified Data BelongsProblem description & analysis: In the following Excel table, the value of cell A2 is date. A 1Fecha 201/03/24 We need to generate a list of dates of the month where that date belongs. A 1WholeMonth 201/03/24 302/03/24 403/03/24 ...Discuss·10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·May 30, 2024Excel Get the Max and Min Values of Each Column in Each Group and Insert Them into Cells HorizontallyProblem description & analysis In the following table, the 1st column is the grouping column and there are N detail data columns after it. ZN_1N_2Q_12 A100200-100 A101-10-200 A102201-104 A99199300 B100011001300 B10041200-900 C2000-210022...Discussexcel
Srisrip.hashnode.dev·Apr 21, 2024Building an Online Bakery Infrastructure: A Pre-Cloud Era Journey 🌐🍰Sri's Story: Starting an Online Bakery the Traditional Way Meet Sri, a young entrepreneur with a dream of starting her own bakery. From the bustling city, she set out on a journey to turn her dream into reality. Here's how she did it in the pre-Cloud...DiscussCloud Computing
esProc Desktopesproc-desktop.hashnode.dev·Apr 18, 2024SPL XLL Practice: Almighty Text Splitting in ExcelText splitting is a common problem encountered in work. For common splitting with commas, semicolons, spaces, and other delimiters or regular fixed-width splitting, Excel’s “text to columns” function can be directly used for splitting. However, more ...Discussexcel
esProc Desktopesproc-desktop.hashnode.dev·Mar 14, 2024How to Automatically Extract Eligible Rows in ExcelWhen processing Excel data, there is an important requirement to filter and extract data that meets one’s own requirements. Of course, we can use Excel’s filtering function to filter and copy the data that meets the conditions. However, the Excel fil...Discussexcel