Hi all!
I currently have this setup (albeit with more columns in reality):
I would like to sort it by dates first, and then by the number after. However, I want this done, so it respects the date assortment before the number assortment, so it wouldnt for example put:
1 - February: 1
Before...
Hello Friends,
I need a formula for conditional format for below
Sample DATA manually entered
A ....B
414 John
420 Christian
421 Christian
414 Mike
456 Charlie
465 Charlie
456 John
A ....B
414 Mike (414 contains Mike so the cell should remain same)
414 Charlie (414 does not...
I use VLOOKUP to bring a person's name from a database into a form. In the database the name always has the format of christian name(s) followed by surname. There can be 1, or 2, or however many christian names.
The form requires that I enter surname in one cell and christian name(s) in a...
Good Morning,
I am able to export some data from a DOS program I use at work that includes names and hours on work orders completed. I want to be able to pull the total by name into a separate, sortable column. I appreciate your help in advance.
<tbody>
What I would like
Exported Data...
I have the following...
Range("A3").End(xlDown).Offset(0, 5).Select
ActiveCell.Copy
Range("U3").PasteSpecial
for the table...
<tbody>
Joe Golding (13-16)
Season
School
Conf
G
W
L
W-L%
SRS
SOS
AP Pre
AP High
AP Final
Notes
2013-14
Abilene Christian
Southland
31
11
20
0.355...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.