|
12-08-2018, 03:36 PM | #2 |
Let's Get Weird
Join Date: Apr 2013
Location: Austin
Casino cash: $9990098
|
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?
|
Posts: 15,229
|
12-08-2018, 03:38 PM | #3 |
Banned
Join Date: Jan 2013
Casino cash: $9998560
|
Excel is closed till Monday.
|
Posts: 53,803
|
12-08-2018, 03:45 PM | #4 |
Thread I will end you.......
Join Date: Apr 2007
Location: Kansas City, KS
Casino cash: $1412608
VARSITY
|
Maybe
=exact(left(A2,5),left(B2,5))
__________________
Patrick Mahomes II MVP 2X Super Bowl MVP 3x Travis Kelce TE GOAT |
Posts: 9,063
|
12-08-2018, 03:46 PM | #5 |
Thread I will end you.......
Join Date: Apr 2007
Location: Kansas City, KS
Casino cash: $1412608
VARSITY
|
or
=lookup(left(A2,5),B$2:B$150)
__________________
Patrick Mahomes II MVP 2X Super Bowl MVP 3x Travis Kelce TE GOAT |
Posts: 9,063
|
12-08-2018, 03:48 PM | #6 |
Banned
Join Date: Jan 2013
Casino cash: $9998560
|
|
Posts: 53,803
|
12-08-2018, 03:50 PM | #7 |
Thread I will end you.......
Join Date: Apr 2007
Location: Kansas City, KS
Casino cash: $1412608
VARSITY
|
=lookup(left(A2,5),C$2:C$150) and =left(C2,5)
__________________
Patrick Mahomes II MVP 2X Super Bowl MVP 3x Travis Kelce TE GOAT |
Posts: 9,063
|
12-08-2018, 03:52 PM | #8 |
"You like to drink?"
Join Date: Jun 2006
Location: "I like to drink."
Casino cash: $2846869
|
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.
__________________
Chiefs 2016 Opponents: Home: JAX, TEN, NO, TB, NYJ. Away: HOU, IND, ATL, CAR, PIT Chiefs 2017 Opponents: Home: BUF, MIA, PHI, WSH, AFC North. Away: NE, NYJ, NYG, DAL, AFC South |
Posts: 42,963
|
1 0 |
12-08-2018, 03:55 PM | #9 |
Banned
Join Date: Jan 2013
Casino cash: $9998560
|
|
Posts: 53,803
|
12-08-2018, 04:02 PM | #10 |
Let's Get Weird
Join Date: Apr 2013
Location: Austin
Casino cash: $9990098
|
Looks like these guys have you covered
|
Posts: 15,229
|
12-08-2018, 04:03 PM | #11 |
Cheat Death
Join Date: Nov 2007
Location: Land of Drincoln
Casino cash: $1878244
|
We’ve weened off Excel for the part. Most everything we do now happens in Alteryx.
|
Posts: 34,152
|
1 0 |
12-08-2018, 04:10 PM | #12 |
Better than Nelson
Join Date: Mar 2003
Casino cash: $10000400
|
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 |
Posts: 17,356
|
12-08-2018, 04:11 PM | #13 |
"You like to drink?"
Join Date: Jun 2006
Location: "I like to drink."
Casino cash: $2846869
|
Just write a macro brah
__________________
Chiefs 2016 Opponents: Home: JAX, TEN, NO, TB, NYJ. Away: HOU, IND, ATL, CAR, PIT Chiefs 2017 Opponents: Home: BUF, MIA, PHI, WSH, AFC North. Away: NE, NYJ, NYG, DAL, AFC South |
Posts: 42,963
|
12-08-2018, 04:17 PM | #14 |
Better than Nelson
Join Date: Mar 2003
Casino cash: $10000400
|
|
Posts: 17,356
|
12-08-2018, 04:31 PM | #15 | |
Let's Get Weird
Join Date: Apr 2013
Location: Austin
Casino cash: $9990098
|
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. |
|
Posts: 15,229
|
|
|