Home HowTo Blog TalkingData eBook Q&A Download Documentation Talking Data Official Website Official Website
  • SCUDATA
  • RAQSOFT
  • Login Register
    Desktop  •  360 Reference  •  166 Reply  •  0 Follow
    HowTo
    Follow
    Default Hot Nice Preferred Recent reply Post
    1 2 3 4 5 6 7 8 9 10 ... 15»
    • jinxing •    Desktop   •    217 View 217 View    •   2024-07-31 17:02:28

      Replace duplicate items with the specified text 

    • jinxing •    Desktop   •    175 View 175 View    •   2024-07-27 08:53:55

      Match the first part of the cell value 

    • jinxing •    Desktop   •    226 View 226 View    •   2024-07-26 08:34:40

      Get a random row from each group 

    • jinxing •    Desktop   •    341 View 341 View    •   2024-07-25 13:12:04

      Remove duplicates and compute intersection 

    • jinxing •    Desktop   •    149 View 149 View    •   2024-07-23 16:21:54

      Find the difference between contents of two cells 

    • jinxing •    Desktop   •    192 View 192 View    •   2024-07-22 18:08:11

      Find the first cell value meeting the specified condition 

    • jinxing •    Desktop   •    154 View 154 View    •   2024-07-19 16:26:32

      Write the first lines of multiple csv files to Excel 

    • jinxing •    Desktop   •    179 View 179 View    •   2024-07-18 18:05:11

      Align rows of data to a specified column 

    • jinxing •    Desktop   •    158 View 158 View    •   2024-07-18 10:13:01

      Group an Excel table and store as multiple files according to part of value of the specified cell 

    • jinxing •    Desktop   •    169 View 169 View    •   2024-07-16 16:16:37

      Combine two tables with different column headers 

    • jinxing •    Desktop   •    232 View 232 View    •   2024-07-16 16:13:58

      Group and summarize a table where every N rows consist of a range by column 

    • jinxing •    Desktop   •    193 View 193 View    •   2024-07-11 16:25:39

      Write continuous numbers in a string of numbers as intervals 

    • jinxing •    Desktop   •    197 View 197 View    •   2024-07-09 21:08:28

      Repeat value of each cell N times according to value of the neighboring cell 

    • jinxing •    Desktop   •    264 View 264 View    •   2024-07-08 11:02:42

      Expand multi-row text in a cell to multiple cells 

    • jinxing •    Desktop   •    229 View 229 View    •   2024-07-05 14:04:23

      Concatenate column values and perform grouping & aggregation 

    • jinxing •    Desktop   •    262 View 262 View    •   2024-07-04 21:37:43

      Summarize data every two columns under each category 

    • jinxing •    Desktop   •    250 View 250 View    •   2024-07-04 17:40:21

      Group rows and concatenate cell values 

    • jinxing •    Desktop   •    200 View 200 View    •   2024-07-01 11:22:29

      List positions of each character 

    • jinxing •    Desktop   •    210 View 210 View    •   2024-07-01 09:56:51

      Split & group text and perform distinct on each group 

    • jinxing •    Desktop   •    228 View 228 View    •   2024-06-26 10:21:11

      Split each cell value and expand it according to the specified rule 

    • jinxing •    Desktop   •    235 View 235 View    •   2024-06-24 21:21:00

      Import a txt file where separator is missing in a column to Excel 

    • jinxing •    Desktop   •    227 View 227 View    •   2024-06-24 21:15:45

      In Excel, re-arrange a sequence N times randomly 

    • jinxing •    Desktop   •    238 View 238 View    •   2024-06-24 17:00:03

      In Excel, parse hexadecimal numbers and make queries 

    • jinxing •    Desktop   •    236 View 236 View    •   2024-06-24 16:59:47

      In Excel, search a target value and hide columns to its right 

    • jinxing •    Desktop   •    250 View 250 View    •   2024-06-24 16:59:29

      In Excel, judge whether a word has duplicate letters 

    1 2 3 4 5 6 7 8 9 10 ... 15»

    Recent hot

    • 2.2 Rate of change
    • 2.3 Dispersion
    • 2.4 Main line
    • 2.5 Fluctuation amplitude
    • 2.6 Fluctuation frequency

    New group

    • Application  
    • NOTE  
    • Promote  
    • Guide  
    • YModel  
    • Desktop  
    • eBook  
    • Performance  
    • InSQL  
    • InFiles  
    • InReport  
    • HowTos  
    • json&xml  
    • Excel  
    • text  
    • SQL  
    • Report  
    • DraftBoard  
    • Q&A  
    • TalkingData  
    • News  
    • Download  
    • esProc  

    Contribute open source GitHub

    • 【Solo】 GitHub 上 Star 数最多的 Java 博客
    • 【Sym】 现代化的社区论坛系统
    • 【Pipe】 小而美的博客平台
    • 【Wide】 Golang 黑科技之在线 IDE
    About esProc SPL esProc Statistic
    © 2025 esProc Community Data computing&representation