วิธี Lookup ข้อมูล แม้สะกดผิดก็ยังหาเจอ ด้วย Power Query Fuzzy Merge

🧑🏻‍💻อบรมกับเทพเอ็กเซล

📂หมวดหมู่

• Highlights : บทความแนะนำ (92)
• Excel (271)
  • Excel ทั่วไป (164)
  • Pivot Table (15)
  • Excel Chart & Visualization (15)
  • Excel Advanced Formula (42)
  • Excel VBA (16)
  • Python in Excel (7)
  • Solver & Simulation (4)
  • Excel for Business (16)
  • Statistics and Maths (11)
  • Excel and Game (6)
• Power Query (70)
• Power BI (15)
• AI & Automation (37)
  • Automation (8)
  • AI Image & Video (23)
  • AI Chatbot (5)
• Programming (8)
• Personal (7)
• Resources (18)
• Uncategorized (2)

🏷️Tags

aggregate ai api chart combination concat data entry DDB filterxml function query group by ifs iterative lambda let machine learning marketing math matplotlib matrix MDETERM MINVERSE MMULT pandas parameter pi python regex rept rfm segmentation sequence simulation small solve statistics sumifs switch textjoin transpose unique VDB web scraping xirr xnpv