-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
johns
-
K
formatting between "(xyzxyz)" in one cell
All, I want to format parts of cells in a list like this: Each name is in one cell, one row each <colgroup><col></colgroup><tbody> AR:Central IL (Johns, Andrew) AR:MS South (Luther, Susan) AR:Chicago, IL (Martinez, Ben) AR:Memphis, TN (Glaser, Albert) AR:NE/IA (McGrath, Jason) I...- Kerry Newman
- Thread
- andrew arcentral cell johns text
- Replies: 5
- Forum: Excel Questions
-
D
Formula Help Needed.
If I want to count how many days someone worked based off the name in column B and the Day of the Month in Column C what kind of formula would I need? <colgroup><col span="3"></colgroup><tbody> <colgroup><col span="3"></colgroup><tbody> A B C Ticket Number Name...- DarrenF
- Thread
- formula jimmy johns johnson magic
- Replies: 3
- Forum: Excel Questions
-
D
Formula Assistance
I have 2 columns of time stamps that track when a case owner changes hands and would like to pull the last time stamp when the case was closed (In Bold - column E) and subtract it from the time the case was opened (In Bold - column C). Is it possible to search the first time for case # 12806301...- DarrenF
- Thread
- 10/1/2018 case jimmy johns time
- Replies: 1
- Forum: Excel Questions
-
M
Formula to return specific values in a table by date
Hi all I've been trying to work out how to get the results highlighted in red in this Sheet https://docs.google.com/spreadsheets/d/1GivPb-qhkexaGePD6sQor_y66N3TZbmX5in-jOz1olM/edit?usp=drivesdk Just trying to get John's Dept and sales results ordered by date. Not sure if it's an Index formula...- mattbarbera
- Thread
- date dept formula johns results
- Replies: 2
- Forum: Excel Questions
