Sort by Icon is not working
My company recently upgraded to Outlook 2003. I used to
be able to look at my inbox and sort the emails by the
Icon column (which indicates whether the message is
unread, forwarded, replied to, or is an appointment,
etc). Now it only sorts out the appointments from all the
other messages but it won't sort the email messages by
icon (unread, replied to, forwarded) indicated by the blue
and purple right/left arrows.
Does anyone know how to turn the sorting back on so it
works the way it used to? I used to use this sorting
heavily to sort thru, file and delete the thousand...Sorting Subtotals
Thanks for the answers on my previous question. I ended up not using
them (those formulas are far too complex for a dabbler like me). I
created two columns to find the origin of either "http://" or "http://
www." (always "1" if found), multiplied that by either 7 or 11 to get
the starting position and then had a columsn for Max() of the previous
two columns. Then I did another column to find the trailing "/" and
then a Mid() with the values obtained in the preceding columns.
Not I have the domain names, and I can sort the table to get
Subtotals. What I&...Modification: Sort Pick Ticket by Bin Number?
I'm searching for software vendor that has already modified GP so that it
sorts the line items on the Pick Ticket by bin number.
Does any vendor have this modification?
Thanks, Dan L.
I believe this option already exists within GP.
When you print the pick ticket, one of the options is "Bin Sequenced". This
should sort the items by bin number.
Give it a try!
"Dan Lapp" wrote:
> I'm searching for software vendor that has already modified GP so that it
> sorts the line items on the Pick Ticket by bin number.
> Does any vendor have this ...How do I stop a Pivot Table from Sorting my data (Excel 2007)
The data in my Access database is in the order that I want it to be
but my Pivot Table insists on sorting it either Ascending or
Descending. I can't seem to turn this off...
If I right-click on the field name and choose Sort > More Sort
Options... > Manual (you can drag items to rearrange them) This
makes no difference!
If I choose PivotTable Options > Display > Field List: Sort in data
source order This again makes no difference!
Is there some trick I'm missing or is it simply impossible to preserve
the original data source order?
Excel...sort by date column
We have a worksheet that contains a colum with the date in it like
12/26/2007. We want to be able to sort by the month but anytime we try to
sort it sorts by the year. Is there an easy way to do what we are trying to
Insert a column next to this one (I assume the data is in column A). Use this formula: =MONTH(A1) and copy down
Sort both columns, using the new column as sort key
"CEV" <firstname.lastname@example.org> wrote in message news:email@example.com...
| We have a worksheet that contains a colum with the date in it like
| 12/26/2007. We want t...alphabetical sort while ignoring preceeding numbers/symbols
Is it possible to do an alphabetical sort while ignoring preceeding numbers
and symbols? That is, sort based on the first letters in a string of
On Sat, 1 Oct 2005 16:10:02 -0700, "silver fox" <silver
>Is it possible to do an alphabetical sort while ignoring preceeding numbers
>and symbols? That is, sort based on the first letters in a string of
You can use a "helper column". In an adjacent column, insert a formula similar
to =LEFT(A1,2). Then select both columns and sort on the helper ...text sort
I have some text in each cell in a column. The first few words in the cell
are in bold and the rest are normal text. Is there anyway I can move all the
non-bold text from column A into column B, and leave the bold text in column
If you have the same number of characters made bold in each row, then you
might use data > Text to columns > Fixed width, and set the column break
where you want them.........otherwise, if you don't have too many rows, you
might go in and manually insert a semicolon, or comma or something between
the bold and normal text ,(or one may already exi...Sort Columns in Excel 2007
Is it possible?
I cannot seem to find a way.
Data menu, Sort. There's an Options button in the Sort dialog.
HTH. Best wishes Harald
"Saxman" <john.h.williamsREMOVETHIS@btinternet.com> wrote in message
> Is it possible?
> I cannot seem to find a way.
Do you mean sort left to right rather than up and down? If so, do Data -
Sort - Options - Sort left to right, select the row you want to sort by and
click OK. HTH Otto
"Saxman" <john.h.williamsREMOVETHIS@btinternet.com> wrot...Currency format in sort
I am working in Excel 2003. I have numeric data in column A that gets
sorted. I would always like currency format in the first cell (A2) under
the heading in A1. If I apply the format to A2, but then sort, the number
with the currency format from A2 moves around and the new number in A2 no
longer has currency formatting. Is there a way to lock in the format for
cell A2 and still be able to sort? I don't want to have a separate column
for the dollar sign.
I couldn't do it.
But if you do this a lot, maybe you could record a macro when you:
select your data
sort b...Sort Protected Sheet with Header Columns
I'm trying to get a spreadsheet to sort by clicking on the Header
cell. I found the following code and it works when the sheet is
Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Application.EnableEvents = False
If Not Intersect(ActiveCell, _
Range("A13:AT13")) Is Nothing Then 'Range with column headings
ActiveCell.CurrentRegion.Sort Key1:=ActiveCell, Header:=xlYes
Application.EnableEvents = True
But, when I protect the sheet and try to run the following code,
Sub Worksheet_SelectionCh...Email Sorting
I have a column with email addresses. I'd like them grouped and sorted
by email address.
Copy addresses to an unused column. Choose Data/Text to Columns. Select
Delimited, Click Next, check Other and enter @, click Next. Select the
first column and choose the "Do not import column radio button". Click
Sort on the column of domains.
In article <1171379816.938911.73700@k78...Sorting Contacts
How do I set-up the contacts on Outlook '97 so that it arranges the entries
by company rather than by individual? The help option talks as changing the
"File As", but I can't find this option.
Can you help?
...Outlook XP Contact Sort
Transferred .pst file to new computer. Contacts sorted properly (last,
first) in "Contacts" view, however when trying to send e-mail using contact
list, the list shown is sorted first, last. I know that the
Tools>Options>Contact Options" routine is only supposed to "fix" new
entries, but how do I correct existing entries?
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 5/18/2004
Willy <firstname.lastname@example.org> wrote:
> Transferred .pst ...Sort and exclude certain words
I work in a public library and frequently export lists of books from
our online catalog to Excel, so that I can manipulate the data in
My problem in sorting in Excel is this: Our library catalog excludes
words like "The" "A" or "An" at the beginning of a title when sorting.
Excel, however, does not.
Is there any way I can sort on a field in Excel and have it ignore
certain words at the beginning of a string?
jds217's Profile: http://www.exc...Sorting files in a folder
I have a folder with *.jpg files and *.AVI files. I would like to
group or sort these files so that all the jpg files are separated from
the AVI files. Within those two groups, I would like the second sort
criteria to be by the Date Taken or Date Created in ascending order. In
XP, you could sort by file type - but, unless MS changed the name, I
don't see how to do this. If I can only sort the AVI files in a sort
or group - then change to the jpg files (all by date), that's OK. Can
Right-mouse click on empty spac in that folder, and all options are open
for ...Disconnected ado recordset can not apply filter and sort
I created a disconnected ado recordset when a form is open:
Private Sub Form_Open(Cancel As Integer)
Dim formrst As ADODB.Recordset
Set formrst = New ADODB.Recordset
'append 3 fields
.ActiveConnection = Nothing
.CursorLocation = adUseClient
.Fields.Append "Fname", adBSTR
.Fields.Append "Lname", adBSTR
.Fields.Append "Age", adBigInt
'append some values to the recordset
.Fields("fname") = "Tom"
...Workaround for sorting activities by date!!
I have a workaround for sorting activities by date that does not involve
telling your sales people to type the date on the subject line!
This is in depth and is not supported in any way. If you don't understand
how to create triggers and views in SQL Server then do not attempt this.
First thing's first... Make a backup of your CRM database.
Create a new user defined function as follows:
CREATE FUNCTION [dbo].[DateFormat] (@date datetime)
RETURNS char(10) AS
RETURN ('[' + CONVERT(char(8), @date, 2) + ']')
Then find the view called "Activity". L...Sorting/Grouping
I have a problem with Acc2003, it worked fine with acc97.
1) I have a report with Sorting/grouping section and I want that every group
should start a new page. I set the Force New Page to Before Section. Now
with acc2003 the first page is blank.
(the After Section with the Keep Together doesn't work either)
Thanks in advance
>I have a problem with Acc2003, it worked fine with acc97.
>1) I have a report with Sorting/grouping section and I want that every group
>should start a new page. I set the Force New Page to Before Section. Now
>...Sorting Data that feeds into other formulas....
I have a workbook (Excel 2003) and I am having trouble with a particular
sorting issue. On page 2, column GL contains specific data that feeds into
formulas used in Page 1. When I sort my data on page 2 it changes the
formula totals on page 1.
What I want to do is have the ability to 'lock' the data on page 2 so that
after I sort it doesn't change the totals in my formulas using the Page 2
For example on Page 1, one of my cells reads the following formula:
='Rep Stack Ranking'!GL$12+'Rep Stack Ranking'!GL$13+'Rep Stack
Rank...Sorting multiple columns as 1 list alphabetically?
Can anyone help with a solution for something i'm trying to achieve in
I have a long list of names that spread many cells down as well as
several columns across and i'm trying to sort the entire list into
alphabetical order. I know I can sort one column at a time but that is
not what i want to achieve. I need to be able to select all of the data
and sort it into alphabetical order (with the a's starting in the first
cell of the first column and the z's finishing in the last cell of the
last column). What I really need to do is be able to link columns so
that the data i...Sorting data in a table by the header of a column?
Is there a way to get excel to sort the data in a table by clicking on the
header of a column like a windows folder does?
No. You have to go to data/sort..tell it you have a header, and the
pick the columns you want to sort by
dfeld71's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2145
View this thread: http://www.excelforum.com/showthread.php?threadid=37449
Not from the column labels A, B, etc. but from within the column of data
that should be the primary sort,...Sorted by Name Views ('SortOrder')
Please, if it is not too much trouble add some kind of sorting capabilities
(sort order field maybe) to the Views (Filters). We have like 20 custom
filters/views and they all appear to be sorted by - nothing in particular.
That makes the whole Views/filters thing not working and the people trying to
use them very frustrated.
If you can add "ORDER BY Name..." to the SQL query for the Views that would
make the product a little less uncomfortable to use.
You CAN define a sort order for a view! Its a facility built in to the
Take a close look at the system custom...How to sort rows by Colors
can anybody help me out to sort the rows by Colors. like I have two colored
rows Light Green and Light Yellow and some are without colors. how do i sort
them that same colors come with eachother?
Sheikh, this is not a buit in function in excel, will be in the next
version, have a look here for a way to do it
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
&qu...Microsoft Excel Sort Problem
I have always been able to sort columns in micosoft
excel. I select auto format but when I go to the Data
area I cannot sort - the "sort" selection is in gray.
Please help! Thanks!
Is the sheet protected?
"VK" <email@example.com> wrote in message
> I have always been able to sort columns in micosoft
> excel. I select auto format but when I go to the Data
> area I cannot sort - the "sort" selection is in gray.
> Please help! Thanks!
How about...Sort on Tab Change
Is there a way to trigger sorting of a column, when I change tabs? I have a
dataset that I use for input and a different tab which is a leaderboard. I
want to sort the leaderboard by high score every time I change to that tab.
I currently have a macro button I click to sort by high score, then I have
to click the leadboard tab. I'd obviously like to click the leaderboard tab
and have the data sorted by high score. Just attempting to combine 2 steps.
step 1 - Sort input form by highscore
step 2 - open the leaderboard tab
right-click the ...