|
12-08-2018, 07:23 PM | #31 | |
MVP
Join Date: Oct 2011
Location: Michigan
Casino cash: $2917078
|
Quote:
Column D Formula: =IFERROR(CONCATENATE(TEXT(LEFT(C2,FIND(",",C2)-1),""),", ",TEXT(LEFT(MID(C2,FIND(" ",C2)+1,256),1),"")),"") What it will look like... Last edited by kccrow; 12-08-2018 at 07:36 PM.. |
|
Posts: 12,685
|
12-08-2018, 07:25 PM | #32 |
Thread I will end you.......
Join Date: Apr 2007
Location: Kansas City, KS
Casino cash: $1412608
VARSITY
|
__________________
Patrick Mahomes II MVP 2X Super Bowl MVP 3x Travis Kelce TE GOAT |
Posts: 9,063
|
12-08-2018, 07:26 PM | #33 |
Supporter
Join Date: Apr 2007
Location: Scott City KS
Casino cash: $1904734
|
I use that bitch every day.
A simple =(timeout-timein)*24 makes a timesheet with multiple entities a breeze. I use vlookup in a real simple purchase unit to application unit conversion. DaFace actually turned me on to the SUBTOTAL function actually allows you total a column after a filter has been applied. I have an incredibly reerunedly convoluted billing spreadsheet that converts a myriad of field activities to whether or not they are billable to a billion different entities. I should be doing that asshole on a database, but it's been a billion years since I've built one and I don't want to spend the money on access. I also have a remarkably difficult to set up but remarkably easy to operate conversion from Quickbooks report to banks cashflow statement that is pretty much a series of references. |
Posts: 56,963
|
12-08-2018, 07:40 PM | #34 |
MVP
Join Date: Oct 2011
Location: Michigan
Casino cash: $2917078
|
You could also separate it into more columns if you want... such as...
Column B Formula =IFERROR(CONCATENATE(TEXT(LEFT(A2,FIND(",",A2)-1),""),", ",TEXT(LEFT(MID(A2,FIND(" ",A2)+1,256),1),"")),"") Column E Formula =IFERROR(CONCATENATE(TEXT(LEFT(D2,FIND(",",D2)-1),""),", ",TEXT(LEFT(MID(D2,FIND(" ",D2)+1,256),1),"")),"") Column G Formula =IF(IFERROR(MATCH(IFERROR(CONCATENATE(TEXT(LEFT(A2,FIND(",",A2)-1),""),", ",TEXT(LEFT(MID(A2,FIND(" ",A2)+1,256),1),"")),""),$E$2:$E$16,0),0)<>0,"On Roster","Not On Roster") Looks like this: |
Posts: 12,685
|
12-08-2018, 07:42 PM | #35 |
MVP
Join Date: Oct 2011
Location: Michigan
Casino cash: $2917078
|
And oh.. yeah been using this shit every day for as long as I can remember...
|
Posts: 12,685
|
12-08-2018, 09:42 PM | #36 | |
Champs!
Join Date: Mar 2004
Location: Kansas City
Casino cash: $5728476
|
Quote:
__________________
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, 11:37 PM | #37 |
He's Mahomie!
Join Date: Aug 2001
Location: Jax, FL
Casino cash: $10023443
|
At work I use Excel daily. Pivot tables are the bomb. But at home I'm a Google docs guy.
__________________
99.9% |
Posts: 17,387
|
12-08-2018, 11:40 PM | #38 | |
MVP
Join Date: Oct 2011
Location: Michigan
Casino cash: $2917078
|
Quote:
My assumption is that you're maintaining an overall roster in Column C and you're entering names in Column A to see if they are on the roster. Reference a couple posts above to see the shorter version formatted correctly. |
|
Posts: 12,685
|
12-09-2018, 12:02 AM | #39 | |
Champs!
Join Date: Mar 2004
Location: Kansas City
Casino cash: $5728476
|
Quote:
I just wished it wasn't such a pain in the ass.
__________________
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-09-2018, 12:24 AM | #40 |
Gimme My Berries Back!
Join Date: Apr 2006
Location: None of your business
Casino cash: $3059963
|
Never.
Well not exactly never but mostly. Only used it a few times from someone's where I had to fill in something. |
Posts: 161,924
|
12-09-2018, 12:36 AM | #41 |
MVP
Join Date: Oct 2011
Location: Michigan
Casino cash: $2917078
|
You can do some sweet shit with macros as well if you want to. For instance, it could check to see if the name exists in the roster list and, if not, add your entry to the list. Gets a bit complex, but Excel can do much, much more than most people realize.
|
Posts: 12,685
|
12-09-2018, 12:44 AM | #42 | |
Champs!
Join Date: Mar 2004
Location: Kansas City
Casino cash: $5728476
|
Quote:
I can do the basic to intermediate stuff, but the stuff you posted earlier, that's way advanced for my knowledge. Yet, you're right, it does do a lot more than people realize, which is why I need to make time for it.
__________________
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-09-2018, 07:38 AM | #43 | |
Starter
Join Date: Jan 2004
Location: Lawrence
Casino cash: $2551995
|
Quote:
|
|
Posts: 953
|
12-09-2018, 09:34 AM | #44 |
Supporter
Join Date: Dec 2005
Location: Highlandville, MO
Casino cash: $3062247
|
I use a basic Excel spreadsheet for my business. I do service call work on network equipment. I use it to track my jobs, the mileage, the labor, the parts, who the work was for and the date paid. Comes in really handy for taxes. But the only functions that I ever use are the sum and the sort and filter.
|
Posts: 12,624
|
12-09-2018, 10:08 AM | #45 |
Politically Incorrect
Join Date: Feb 2009
Location: Scottsdale, AZ
Casino cash: $2361110
|
What the hell is Excel???
__________________
"The only difference between sex for free and sex for money is that sex for free costs you a WHOLE LOT more!" ~Redd Foxx~ "The men who drafted Patrick Mahomes" |
Posts: 50,869
|
|
|