| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorting rows based on the content of two columns
Dear Sir, You please convert the year format to "yyyy" or if you have typed yea as numbers sort them and use the formula so you will get full year data Example =CONCATENATE("20",C1) ' if C1 VALUE IS 04 will give 2004 I hope this will work for you. Regards S.Sures -- s_u_res ----------------------------------------------------------------------- s_u_resh's Profile: http://www.excelforum.com/member.php...fo&userid=1567 View this thread: http://www.excelforum.com/showthread.php?threadid=27202 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting and lining up data into columns based off content | Excel Discussion (Misc queries) | |||
| Highting rows based on content of cells | Excel Worksheet Functions | |||
| Delete Rows Based On Content | Excel Programming | |||
| Delete Rows Based On Content | Excel Programming | |||
| Hiding rows based on cell content | Excel Programming | |||
![s_u_resh[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
