sorting problem with text and dates

jyeat

New Member
Joined
Jul 20, 2007
Messages
1
I am trying to sort all kinds of data but am stuck as to how to do this. I have three main things i'm trying to accomplish.

1. sort the text files (cable type in my particular situation) by name then date (monthly)
2. count the number of times per month the cable appears.
3. apply the number per month in another table within the same worksheet


i have everything sorted by name and dates, and i can count manually how many times this occurs per month and then take that number and plug it in my other table but that isn't the point of excel! lol.. i didn't know if anyone knew a more efficient way around this

also, my cable type is obviously is entered in as text in excel but my date is also entered as text. I didn't know if it'd be best to change that to the numerical symbol or not

thanks so much!!
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,357
Office Version
  1. 365
Platform
  1. Windows
Why not use Data>Pivot Table...?

As for the date being entered as text, if that's the case then you won't get a proper chronological sort.
 

Forum statistics

Threads
1,181,102
Messages
5,928,072
Members
436,586
Latest member
latintxn

We've detected that you are using an adblocker.

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.
Go back
Top