Microsoft Excel - How often do you use it?
For advanced users, tell us some of your tricks in terms of using the formulas and such.
For beginners, ask questions here, hopefully answers could be provided. As for me, my question to the experts/advanced users, Let's say if I have a spreadsheet with column A that has names, typically last name, first name and middle initial (example: Smith, Joe Steve). Column B has names that is typically the same as column A, except it would be missing the middle name or a misspelling on the first name (example: Smith, Joe). Column A would have say 450 names and Column B would have 150. How can a "near" match search be found, after utilizing the conditional formatting that highlights duplicate values? |
Can you post an example of some of the rows in the columns that you’re working with and what you want your end-result to be?
|
Excel is closed till Monday.
|
Maybe
=exact(left(A2,5),left(B2,5)) |
or
=lookup(left(A2,5),B$2:B$150) |
Quote:
|
=lookup(left(A2,5),C$2:C$150) and =left(C2,5)
|
It's been said that there is more fiction created in one day in Microsoft Excel than there will ever be created in Microsoft Word.
|
Quote:
|
Looks like these guys have you covered :)
|
We’ve weened off Excel for the part. Most everything we do now happens in Alteryx.
|
Google sheets question
Is there a way to have an action(such as bold text) act as a trigger? Maybe to duplicate data from an entire row? In other words, if I bold a name in the cell A4, can the data in B4-H4 be duplicated in B30-H30 |
Quote:
|
Quote:
|
Quote:
Excel is a must-know tool in the business world, but so often misused and isn’t practical for doing things such as in-depth data analysis.. When I was in school, I had professors in some data science courses I took dock students points for using Excel for anything (as simple as string-parsing on a column) on assignments. “Excel is a glorified text-editor”, a phrase I recall being said to us after such an instance happened. If you ever want to know if someone is bullshitting on their resume, test them on those Excel skills they always list that they have. I’d bet the majority of people wouldn’t even know what a VLOOKUP is. |
All times are GMT -6. The time now is 08:35 AM. |
Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2024, vBulletin Solutions, Inc.