How to Fix Misspelled Customer Names with Excel
Вставка
- Опубліковано 26 сер 2023
- In this video, we'll show you how to fix misspelled customer names using a PivotTable and the XLOOKUP function. Pivot tables are a great way to automatically view customer data in your data, and XLOOKUP is a handy tool for making sure you can focus on a common name for your customers.
Whether you're a business owner or a data analyst, this video is a must-see! We'll show you how to use Pivot tables to view customer data, and then we'll demonstrate how to use XLOOKUP to correct the "spelling" or format of customer names. With this information, you'll be able to quickly and easily fix customer data in your data!
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to
www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
That's so interesting. Have to watch it again though.
Glad you thought so!
This is good and can work in some cases. How about where the order of the names is inter-changed. I mean- assuming you want the order to be first name then second name and some names start with the last name then first name.
That might mean either an additional lookup or a concat of the data
Nice!
Hi Lachdanan, thanks for the comment!
Shortcuts: MOVING A ROW OR COLUMN :
highlight the row you want to move
hold down the shift key
Click on the border of the call and drag the row or column to its new location that’s it.
You will notice, as your dragging the BORDER of the row or column changes to indicate that you were moving the entire row or column.
Also, instead of copy / paste, select the cell you want to copy
Hold down the Cntrl key and drag it to its new location. This will leave the word or number in the cell and place a copy into the new cell
To duplicate into several open BORDERING cells, highlight the cell you want to copy and drag the fill handle down or to the side.
After creating the lookup table, an alternative to using lookup formulas would be to merge queries in Power Query. The advantage of using queries would be the ease of updating if more customer names are added.
Hi Neil Boisen Music, Thanks for the comment and adding to the thread!