Microsoft Excel - How often do you use it?

[Coach]

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?

[C3HIEF3S]

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?

[eDave]

Excel is closed till Monday.

[digger]

Maybe
=exact(left(A2,5),left(B2,5))

[digger]

or


=lookup(left(A2,5),B$2:B$150)

[eDave]

Originally Posted by digger

or


=lookup(left(A2,5),B$2:B$150)

This one.

[digger]

=lookup(left(A2,5),C$2:C$150) and =left(C2,5)

[Discuss Thrower]

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.

[eDave]

Originally Posted by Discuss Thrower

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.

Love this.

[C3HIEF3S]

Looks like these guys have you covered

[KCUnited]

We’ve weened off Excel for the part. Most everything we do now happens in Alteryx.

[Rudy tossed tigger's salad]

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

[Discuss Thrower]

Originally Posted by Rudy tossed tigger's salad

Google sheets question

Is there a way to have an action(such as bold) to duplicate data from an entire row?

In other words, if I bold a name in the cell A4, B4-H4 will be duplicated in B30-H30

Just write a macro brah

[Rudy tossed tigger's salad]

Originally Posted by Discuss Thrower

Just write a macro brah

I will google it, thanks.

[C3HIEF3S]

Originally Posted by KCUnited

We’ve weened off Excel for the part. Most everything we do now happens in Alteryx.

My company is on this route as well, but only at our corporate HQ.

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.