esProc Desktopesproc-desktop.hashnode.dev·Sep 11, 2024#62 - Search for A Specified String across The Whole TableProblem description & analysis: We have two Excel sheets, and there are same-structure tables in the two sheets. Sheet1 ABC 1Col1Col2Col3 2foo1NA 3bar2y 4baz3bar 5foo4z 6bar5NA 7baz6foo Sheet2 ABC 1Col1Col2Col3 2foo7bar 3bar8b...Discussexcel
Halimah Teniola Jamiutheteniverse.hashnode.dev·Sep 10, 2024Spreadsheet VS DatabasesA small business owner manages a growing online boutique. As her customer base expands, so does her challenges-tracking inventory, monitoring sales, managing customer details, and keeping an eye on employee schedules. You could already guess what her...Discuss·1 likedataanalytics
esProc Desktopesproc-desktop.hashnode.dev·Sep 10, 2024Split Words as Individual CharactersProblem description & analysis: An Excel table has a column of words: A 1EJ 2OU 3only Task: Split each of these words as individual characters and concatenate them into a column, as the following shows: B 1E 2J 3O 4U 5o 6n 7l ...Discussexcel
esProc Desktopesproc-desktop.hashnode.dev·Sep 9, 2024#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 6, 2024#59 - Split IP Addresses And Then Group RowsProblem description & analysis: An Excel table contains a column of standard IP v4 addresses: A110.12.20.30210.205.20.30310.178.20.30410.23.20.30510.167.20.30610.90.20.30710.134.20.30810.177.20.30910.200.20.301010.115.20.301110.48.20.301210.181.20.30...Discussexcel
esProc Desktopesproc-desktop.hashnode.dev·Sep 5, 2024#58 - Split Each Row into Multiple Rows According to The Specified RuleProblem description & analysis: Here is an Excel table: ABCD1CreditBankCodeBeneficiaryNameNarrationAmount2011BENSON MATHIASApril 2024 Salary72558.953057SAIFULLAHI RABIUApril 2024 Salary450004076ABDULKADIR AUWALUApril 2024 Salary550005001001ABDULKADIR...Discussexcel
Vadymsheetcast.hashnode.dev·Sep 5, 2024A Guide to Enterprise Web Application Development1. Introduction Web applications have become essential tools for modern enterprises, enabling businesses to streamline operations, enhance customer engagement, and drive growth. However, developing these applications often involves complex coding, hi...Discussspreadsheets
Vadymsheetcast.hashnode.dev·Sep 4, 2024What Are The Best Web App Builders?Building web apps has become more accessible than ever with various platforms offering intuitive, no-code or low-code solutions. Whether you’re a small business owner, a developer, or just someone with an idea, there’s likely a tool out there that ca...Discussexcel
esProc Desktopesproc-desktop.hashnode.dev·Aug 26, 2024#51 - Get Rankings of Excel Rows in Each Group While Retaining the Existing OrderProblem description & analysis: We have an unordered Excel table, where the 1st column is the grouping column and the 2nd column contains dates. AB 1Agent IDDate of Sale 2Agent107-12-2023 3Agent105-12-2023 4Agent209-12-2023 5Agent313-12-2...Discussexcel
Dominik KellerforLow-Code Software Engineeringfive.hashnode.dev·Aug 23, 2024Create an Asset Tracking System In 3 StepsAsset tracking can be an absolute nightmare. This guide will walk you through the process of creating a robust asset tracking system, so you can keep track of your resources. After finishing this article you'll be able to develop a system that provid...Discussasset tracker
