Rohit Prakashrohitprakash249.hashnode.dev·Nov 20, 2024what i've learnt till today from past 5 months.well, i was learning alone from past 5 months. Technologies i’ve learnt :- REACT JS, NEXT JS, REDUX, NODE JS, MONGODB, EXPRESS ,RESTful API JAVASCRIPT ES6 ,MATERIAL UI, TAILWIND CSS ,HTML5 ,CSS3 ,BOOTSTRAP etc. I learnt these technologies solely from...Discusslearning
esProc Desktopesproc-desktop.hashnode.dev·Nov 20, 2024#100 — Deduplication of Row-Based Data — by Key ColumnProblem description & analysis: There is a data table: Task: Find out the data that are not duplicates and the first duplicate data in the Name column. Solution: Use SPL XLL and enter the following code: =spl("=E(?1).group(Name).(~(1))",A1:D7) The ...Discuss·10 likesexcel
esProc Desktopesproc-desktop.hashnode.dev·Nov 18, 2024#98 — Count Duplicates of Row-Based Data — by Key ColumnProblem description & analysis: Here below is a personnel data table: Task: Count the number of duplicate data (the judging basis is that the data in the Name field are the same). Solution: Use SPL XLL and enter the formula in the cell E2: =spl("=?1...Discuss·10 likes#Excel-tutorial
esProc Desktopesproc-desktop.hashnode.dev·Nov 15, 2024#97 — Count Duplicates of Simple MembersProblem description & analysis: Here below is a data table of names: Task: Count the number of duplicate names. Solution: Use SPL XLL and enter the formula in cell B2: =spl("=?1.conj().select(~==?2).count()",A$2:A$6,A2) Download esProc Desktop fo...Discuss·10 likesexcel
Ayanconnectedrhythms.hashnode.dev·Nov 14, 2024How Adblockers Work: A Deep Dive into Online Ad BlockingThe internet is filled with advertisements, from banner ads to pop-ups and video commercials. While ads support free content, they can sometimes be intrusive and disrupt the browsing experience. This has led to the widespread adoption of adblockers—t...Discusslearning
esProc Desktopesproc-desktop.hashnode.dev·Nov 14, 2024#96 — Identify Duplications of Row-Based Data — by Key ColumnProblem description & analysis: Here below is a personnel data table: Task: Identify whether there are duplicate data, if so, fill in 1 in the corresponding Dup field, otherwise fill in 0 (the identifying basis is that the data in the Name field are...Discuss·10 likesexcel
Ayanconnectedrhythms.hashnode.dev·Nov 13, 2024Web3 Marketplaces: Redefining the Way We Buy and Sell OnlineThe concept of Web3 represents the next evolution of the internet, often referred to as the decentralized web. It is built on blockchain technology and emphasizes user ownership, transparency, and decentralization. One of the most exciting applicatio...DiscussWeb Development
esProc Desktopesproc-desktop.hashnode.dev·Nov 13, 2024#95 — Identify Duplications of Simple MembersProblem description and analysis: Here below is a data table of names: Task: Identify whether there are duplicate names, if so, fill in 1 in the corresponding Dup field, otherwise fill in 0. Solution: Use SPL XLL and enter the formula in cell B2: =s...Discuss·10 likesexcel
Ayanconnectedrhythms.hashnode.dev·Nov 12, 2024What is an NFT? Unlocking the Digital Revolution of Non-Fungible TokensIn recent years, NFTs (Non-Fungible Tokens) have exploded in popularity, particularly in the world of art, entertainment, and collectibles. But what exactly are NFTs, and why are they creating so much buzz? In this article, we’ll explore the concept ...DiscussNFT
esProc Desktopesproc-desktop.hashnode.dev·Nov 12, 2024#94 — Intersection, Union, and Difference in the Case of Row-Based Data — Two Sets — by Whole RowProblem description: The following tables list the data of the products and salespersons that make the top 10 by sales in January and February: Solutions: Use SPL XLL to tackle the following tasks respectively. A. Find out the data of products and ...Discuss·10 likesexcel
