当前时间： 2026-06-21 13:58:09
分类：办公文件
评论(0)
Excel+WPS表格:通用型数据查询表小伙伴们好啊，今天咱们以Excel 2021版本为例，制作一个通用型的数据查询表。先看效果，从控件菜单中选择仓库名，就能快速提取出该仓库的全部记录：在标题右侧的空白列中输入以下公式，提取不重复的仓库列表。右键单击控件，设置控件格式。数据源区域选择刚刚用公式提取出的仓库列表区域，单元格链接选择一个空白单元格，比如 H1。设置完成后，适当调整控件高度，在控件中单击选择仓库名称，H1单元格的数值会随之变化。=FILTER(销售出库!A2:F630,销售出库!C2:C630=INDEX(I1:I11,H1))公式中的INDEX(I1:I11,H1)部分，INDEX函数以H1单元格中的数值为索引值，返回I列仓库列表中对应位置的仓库名称。FILTER函数以销售出库工作表的A2:F630单元格区域作为筛选区域，筛选条件为：销售出库工作表的C2:C630区域等于INDEX得到的仓库名称。接下来选中A2:A999，按下图所示步骤设置条件格式。目的是仅对有数据的单元格添加边框。单击控件列表中的仓库名称，就可以实时查看符合条件的数据了：
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2026-06-21 17:32:10 HTTP/1.1 GET : https://www.yeyulingfeng.com/a/778377.html
- 运行时间 : 0.121880s [ 吞吐率：8.20req/s ] 内存消耗：4,579.18kb 文件加载：145
- 缓存信息 : 0 reads,0 writes
- 会话信息 : SESSION_ID=b816ad14b186bd0669c1806df326b6a0
- CONNECT:[ UseTime:0.000608s ] mysql:host=127.0.0.1;port=3306;dbname=wenku;charset=utf8mb4
- SHOW FULL COLUMNS FROM `fenlei` [ RunTime:0.000698s ]
- SELECT * FROM `fenlei` WHERE `fid` = 0 [ RunTime:0.000488s ]
- SELECT * FROM `fenlei` WHERE `fid` = 63 [ RunTime:0.000298s ]
- SHOW FULL COLUMNS FROM `set` [ RunTime:0.000563s ]
- SELECT * FROM `set` [ RunTime:0.000250s ]
- SHOW FULL COLUMNS FROM `article` [ RunTime:0.000618s ]
- SELECT * FROM `article` WHERE `id` = 778377 LIMIT 1 [ RunTime:0.001525s ]
- UPDATE `article` SET `lasttime` = 1782034330 WHERE `id` = 778377 [ RunTime:0.005733s ]
- SELECT * FROM `fenlei` WHERE `id` = 64 LIMIT 1 [ RunTime:0.000404s ]
- SELECT * FROM `article` WHERE `id` < 778377 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000618s ]
- SELECT * FROM `article` WHERE `id` > 778377 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.000520s ]
- SELECT * FROM `article` WHERE `id` < 778377 ORDER BY `id` DESC LIMIT 10 [ RunTime:0.000903s ]
- SELECT * FROM `article` WHERE `id` < 778377 ORDER BY `id` DESC LIMIT 10,10 [ RunTime:0.003655s ]
- SELECT * FROM `article` WHERE `id` < 778377 ORDER BY `id` DESC LIMIT 20,10 [ RunTime:0.005096s ]
0.126702s
夜雨聆风
