|
12-08-2018, 04:36 PM | #16 |
Banned
Join Date: Jan 2013
Casino cash: $9998560
|
VLOOKUP will change your life.
|
Posts: 53,803
|
12-08-2018, 04:37 PM | #17 | |
Champs!
Join Date: Mar 2004
Location: Kansas City
Casino cash: $5728476
|
Quote:
As you can see, the left would have the full name while on the right, some will already have a full name (which can be easily found by using the conditional format for duplicate values). Others will have a partial due to missing middle initial/name or partial first name. My end result would be is to find column A (which is like roughly 25-50 names) and on column C, it would have a complete roster of who joined (in excess of 700 names), in a yearly cycle. Basically, I just want to find a functional or something that allows me to find the person's full name on the left to have a probability of matching the name on column C. For example, Feunutes, Shannon Arnold on the left is Feunutes, S. But because of Column C is larger, I don't want to have to use search and find each individual names independently/manually, if that makes sense?
__________________
Super Bowl IV, LIV, LVII & LVIII Champions 2020, 2021, 2023, & 2024 AFC Champions 1985 & 2015 Major League Baseball World Series Champions 1980, 1985, 2014, & 2015 Major League Baseball American League Champions 2015 American League Central Division Champs |
|
Posts: 53,225
|
12-08-2018, 04:41 PM | #18 | |
Banned
Join Date: Jan 2013
Casino cash: $9998560
|
Quote:
|
|
Posts: 53,803
|
12-08-2018, 04:42 PM | #19 | |
Champs!
Join Date: Mar 2004
Location: Kansas City
Casino cash: $5728476
|
Quote:
I tried to experiment it, but just can't seem to find the one that would help.
__________________
Super Bowl IV, LIV, LVII & LVIII Champions 2020, 2021, 2023, & 2024 AFC Champions 1985 & 2015 Major League Baseball World Series Champions 1980, 1985, 2014, & 2015 Major League Baseball American League Champions 2015 American League Central Division Champs |
|
Posts: 53,225
|
12-08-2018, 04:45 PM | #20 |
"You like to drink?"
Join Date: Jun 2006
Location: "I like to drink."
Casino cash: $2846869
|
Index + match is better.
__________________
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:54 PM | #21 |
Champs!
Join Date: Mar 2004
Location: Kansas City
Casino cash: $5728476
|
Okay, what is Index + match? How does that process work?
__________________
Super Bowl IV, LIV, LVII & LVIII Champions 2020, 2021, 2023, & 2024 AFC Champions 1985 & 2015 Major League Baseball World Series Champions 1980, 1985, 2014, & 2015 Major League Baseball American League Champions 2015 American League Central Division Champs |
Posts: 53,225
|
12-08-2018, 04:55 PM | #22 |
"You like to drink?"
Join Date: Jun 2006
Location: "I like to drink."
Casino cash: $2846869
|
Not to be glib but Googling how-to will be better than me trying to explain.. since I have to refer back to a finance-bro meme to replicate it.
But index+match has the same functionality of LOOKUPs but with better flexibility.
__________________
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, 05:00 PM | #23 |
Starter
Join Date: Feb 2009
Casino cash: $1561445
|
|
Posts: 890
|
12-08-2018, 05:02 PM | #24 |
Banned
Join Date: Jan 2013
Casino cash: $9998560
|
|
Posts: 53,803
|
12-08-2018, 05:14 PM | #25 | |
Cheat Death
Join Date: Nov 2007
Location: Land of Drincoln
Casino cash: $1878244
|
Quote:
|
|
Posts: 34,152
|
12-08-2018, 05:32 PM | #26 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
Casino cash: $1616899
|
What the hell did you guys do to the table formatting in this thread?
|
Posts: 52,019
|
12-08-2018, 05:34 PM | #27 |
Kind of a mod
Join Date: Aug 2005
Location: Donkey Land
Casino cash: $1616899
|
Found it. It was digger's fault. Fixed now.
|
Posts: 52,019
|
1 0 |
12-08-2018, 06:53 PM | #28 |
Veteran
Join Date: Apr 2007
Location: JoCo
Casino cash: $1250860
|
|
Posts: 3,452
|
12-08-2018, 07:01 PM | #29 |
Veteran
Join Date: Apr 2007
Location: JoCo
Casino cash: $1250860
|
Not only is it much more flexible, but way less of a drain on resources.
|
Posts: 3,452
|
12-08-2018, 07:08 PM | #30 | |
MVP
Join Date: Oct 2011
Location: Michigan
Casino cash: $2917078
|
Quote:
|
|
Posts: 12,685
|
|
|