How to map two columns of values in Google Sheets with ChatGPT
Our new function = GPT_MAP() makes data mapping super easy! 🔛 Just select the columns you want to map and ChatGPT will automatically match similar values. You can even adjust the similarity threshold to make it more or less strict. Learn how to use it inside Google Sheets in this video.
📖 Function in this video
Syntax: =GPT_MAP(search_keys, range, [confidence], [stats]) - model by default: gpt-3.5-turbo
Confidence: set a similarity threshold. Must be comprised between 0 and 1.
Stats: "true" to display similarity score
▶️ PLAYLIST:
Discover all the functionalities of the GPT for Sheets and Docs add-on: • All about GPT for Sheets
📥 List of all available functions: https://gptforwork.com/help/gpt-for-s...
❗️ Do not hesitate to comment below or fill out this form with your questions and feedback , we'll be happy to answer: https://support.gptforwork.com/hc/en-...
------------------------------------------------------------------------------------------
GPT for Work is an AI assistant for Microsoft Excel and Word, Google Sheets and Docs. You can use it for all sorts of tasks: writing, editing, extracting, cleaning, translating, summarizing, outlining, explaining... and even analyzing pictures!
GPT for Work brings the power of OpenAI's latest models, including GPT-3.5 Turbo, GPT-4, GPT-4 Turbo and GPT-4 Vision into Microsoft Excel and Word, Google Sheets and Docs. It is like using ChatGPT directly in your spreadsheets and documents!
👉 Install for Microsoft: https://gptforwork.com/install-msft
👉 Install for Google: https://gptforwork.com/install-google
Our GPT functions are perfect for bulk operations in Excel and Sheets.
Our Word and Docs integrations are great for long form content.
💡 More resources and examples on our website: https://gptforwork.com/
🔔 Don't miss any new feature by subscribing to our channel: / @gpt4work
------------------------------------------------------------------------------------------
This channel is brought to you by TALARIAN: https://talarian.io/
Check out our other productivity tools for Google Workspace:
🚀 YAMM : https://yamm.com/
🔥 AWESOME TABLE : https://awesome-table.com/
🤖 FORM PUBLISHER : https://form-publisher.com/