EXCEL筛选A再筛选B
筛选A：
=COUNTIFS('Sheet1'!$A:$A,"知网")
筛选A再筛选B：
=COUNTIFS('Sheet1'!$A:$A,"知网",'Sheet1'!$B:$B,"论文")
“EXCEL筛选A再筛选B” 的相关文章
齐白石
...
寻找gpedit.msc
@echo offpushd "%~dp0"dir /b %systemroot%\Windows\servicing\Packages\Microsoft-Windows-GroupPolicy-ClientExtensions-Package~3*.mum >gp.tx...
计算指定时间内的点击量
SELECT SUM(hits) AS total_hits FROM jz_article WHERE addtime >= 1725120000 AND addtime ...
医师添加不了的解决方案
数据库错误：Field 'id' doesn't have a default valueINSERT INTO jz_doctor解决办法：ALTER TABLE `jz_doctor` CHANGE `id` `id` INT(11) UNSIGNED NOT NULL...
PowerShell命令修改文件创建和修改时间
Get-ChildItem "文件名称" | ForEach-Object { $_.CreationTime = "2024-11-12 15:32:56"; $_.LastWriteTime = "2024-11-12 15:32:56"...
发表评论
