Kishan
2020-01-31 18:00
在单元格B12中尝试以下公式：
=transpose(filter(transpose(filter('Recipe Data'!B:BJ,(row('Recipe Data'!A:A)=1)+('Recipe Data'!A:A=B9))),len(transpose(filter('Recipe Data'!B:BJ,('Recipe Data'!A:A=B9))))))
相关问题
热门github
1
🤯 Lobe Chat - an open-source, modern-design AI chat framework. Supports Multi AI Providers( OpenAI / Claude 3 / Gemini / Ollama / DeepSeek / Qwen), Knowledge Base (file upload / knowledge management / RAG ), Multi-Modals (Plugins/Artifacts) and Thinking. One-click FREE deployment of your private ChatGPT/ Claude / DeepSeek application.
(翻译：LobeChat 是开源的高性能聊天机器人框架，支持语音合成、多模态、可扩展的（Function Call）插件系统。)
4
6
10
谢谢！这完美地工作了，这正是我想要的！Kishan和JPV，您太棒了！<3