原表如下内容:

需要输出为以下格式表格:

方法如下:
- 将A列升序排列,C2单元格写入
=IF(A2=A1,B2&"/"&C1,B2),D2单元格写入=LEN(C2),结果如下:

原表如下内容:

需要输出为以下格式表格:

方法如下:
=IF(A2=A1,B2&"/"&C1,B2),D2单元格写入=LEN(C2),结果如下:
SSHFS是一个通过SSH连接到服务器的网络文件系统客户端。
SSHFS允许您使用SFTP挂载远程文件系统。 大多数VPS SSH服务器默认情况下都支持并启用此SFTP访问,因此SSHFS使用非常简单,无需在服务器端执行任何操作。
…Linux下推使用V2rayA,安装使用可参考V2rayA客户端使用实例
说明: 从V2Ray 4.27.0开始,请使用新版安装脚本,旧版安装配置实例仅供参考。
➜ ~ curl -O https://raw.githubusercontent.com/v2fly/fhs-install-v2ray/master/install-release.sh
➜ ~ bash ./install-release.sh
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 98k 100 98k 0 0 495k 0 --:--:-- --:--:-- --:--:-- 495k
info: Installing V2Ray v4.27.5 for x86_64
Downloading V2Ray archive: https://github.com/v2fly/v2ray-core/releases/download/v4.27.5/v2ray-linux-64.zip
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 644 100 644 0 0 5457 0 --:--:-- --:--:-- --:--:-- 5457
100 12.6M 100 12.6M 0 0 8316k 0 0:00:01 0:00:01 --:--:-- 10.2M
Downloading verification file for V2Ray archive: https://github.com/v2fly/v2ray-core/releases/download/v4.27.5/v2ray-linux-64.zip.dgst
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
100 649 100 649 0 0 2368 0 --:--:-- --:--:-- --:--:-- 2368
100 590 100 590 0 0 1053 0 --:--:-- --:--:-- --:--:-- 1053
info: Extract the V2Ray package to /tmp/tmp.gWzZRTMMij and prepare it for installation.
installed: /usr/local/bin/v2ray
installed: /usr/local/bin/v2ctl
installed: /usr/local/share/v2ray/geoip.dat
installed: /usr/local/share/v2ray/geosite.dat
installed: /usr/local/etc/v2ray/config.json
installed: /var/log/v2ray/
installed: /var/log/v2ray/access.log
installed: /var/log/v2ray/error.log
installed: /etc/systemd/system/v2ray.service
installed: /etc/systemd/system/v2ray@.service
removed: /tmp/tmp.gWzZRTMMij
info: V2Ray v4.27.5 is installed. //安装完成
You may need to execute a command to remove dependent software: dnf remove curl unzip
Please execute the command: systemctl enable v2ray; systemctl start v2ray
➜ ~ systemctl enable v2ray //添加systemd服务模块
Created symlink /etc/systemd/system/multi-user.target.wants/v2ray.service → /etc/systemd/system/v2ray.service.
➜ ~ systemctl start v2ray //开启v2ray服务
➜ ~ service v2ray status //检查v2ray服务状态
Redirecting to /bin/systemctl status v2ray.service
● v2ray.service - V2Ray Service
Loaded: loaded (/etc/systemd/system/v2ray.service; enabled; vendor preset: disabled)
Active: active (running) since Mon 2020-09-07 11:16:13 CST; 8s ago
Main PID: 25897 (v2ray)
Tasks: 6 (limit: 4566)
Memory: 4.7M
CGroup: /system.slice/v2ray.service
└─25897 /usr/local/bin/v2ray -config /usr/local/etc/v2ray/config.json
Sep 07 11:16:13 bwgcn2 systemd[1]: Started V2Ray Service.
Sep 07 11:16:13 bwgcn2 v2ray[25897]: V2Ray 4.27.5 (V2Fly, a community-driven edition of V2Ray.) Custom (go1.14.7 linux/amd64)
Sep 07 11:16:13 bwgcn2 v2ray[25897]: A unified platform for anti-censorship.
Sep 07 11:16:13 bwgcn2 v2ray[25897]: 2020/09/07 11:16:13 [Info] v2ray.com/core/common/platform/ctlcmd: <v2ctl message>
Sep 07 11:16:13 bwgcn2 v2ray[25897]: v2ctl> Read config: /usr/local/etc/v2ray/config.json
Sep 07 11:16:13 bwgcn2 v2ray[25897]: 2020/09/07 11:16:13 [Warning] v2ray.com/core: V2Ray 4.27.5 started
默认安装完成后,启用配置文件为/usr/local/etc/v2ray/config.json,但这个默认配置为空,因此需要自定义服务端配置。