How can I alphanumerically sort data in Excel with an exception?

How can I alphanumerically sort data in Excel with an exception?
by

1 Answer

Answer :

answer:Under the Sort & Filter options there should be a “Custom Sort” item. Go to that, then in the resulting window, click the down arrow under “Order”. There should be a “Custom List…” item. In that resulting window you can add you own custom sort list with whatever order you want them to be. So, in your case, I would add all the LS, CH, and other items in alphabetic order, but then put PT at the top. Let me know if that works out for you.
by

Related questions

I'm sort of a heavy smoker. But with this new job (8 hrs per day,) I made the decision not to smoke except during my one break (30 minutes for lunch.) It isn't really bothering me at all. Anyone have any idea why?

Description : I'm sort of a heavy smoker. But with this new job (8 hrs per day,) I made the decision not to smoke except during my one break (30 minutes for lunch.) It isn't really bothering me at all. Anyone have any idea why?

Last Answer : Maybe you’re just over it. In any case, congratulations!

If you had to lay someone off from their job, what sort of approach would you take?

Description : If you had to lay someone off from their job, what sort of approach would you take?

Last Answer : the approach taken to laying someone off is usually very scripted due to legal issues. i’ve had the misfortune of laying people off, and am actually thankful i didnt have to craft my own approach to doing so.

"The Customer Is Always Right"- Did you grow up hearing this and assuming it was some sort of law of trade beween businesses and customers? Do you personally believe in this enough to act up in public and blurt it out when you feel you should get your way?

Description : "The Customer Is Always Right"- Did you grow up hearing this and assuming it was some sort of law of trade beween businesses and customers? Do you personally believe in this enough to act up in public and blurt it out when you feel you should get your way?

Last Answer : Having worked in retail for several years, I can assure you that the Customer is almost always wrong. ;) That said, it is often in the business' best interest to act as though the customer is right ... , though, the actually right customers didn't tend to be the ones to bring up that dreaded phrase.

How To Sort Data In Excel?

Description : How To Sort Data In Excel?

Last Answer : Training in Excel: Learning to use excel can be overwhelming with the number of options that exist to allow you take sort, manage, filter, and otherwise use data you have gathered. Taking the time to ... in excel:1. Highlight the columns you want to sort. Either select the items by hand by highlight

How can I make this sort of a ...script, in excel?

Description : How can I make this sort of a ...script, in excel?

Last Answer : You could simply graph them on the same chart. Once the sheet is set up that’s about all that would need to be done. You would not have any fancy transparency though. I would probably just write a small program in Java to do it.

Omitting columns in Excel 2010 sort?

Description : Omitting columns in Excel 2010 sort?

Last Answer : answer:highlight the columns you want to make disappear right click on one of them choose HIDE from the context menu,] Voila…

How do you sort columns of number/text mix in Excel?

Description : How do you sort columns of number/text mix in Excel?

Last Answer : answer:Make the numbers all 2 digits…. example-01 example-02 example-03 example-10 example-11 example-12 Then it will sort correctly.

How do I randomly sort a list of terms in Excel?

Description : How do I randomly sort a list of terms in Excel?

Last Answer : Randomly..well. Did you enter your terms randomly?

What sort of training do you need to be proficient at excel?

Description : What sort of training do you need to be proficient at excel?

Last Answer : beng1- Excel is not that difficult to master. First and foremost you need to be proficient in typing and can follow directions clearly. There is no prerequisite required. If you can follow along with the software you should have a competent grasp of the material in several weeks.

Why do many people hate on excellence and claim that, without exception, the elevated cost is created artificially for vanity alone?

Description : Why do many people hate on excellence and claim that, without exception, the elevated cost is created artificially for vanity alone?

Last Answer : answer:Do they? Is this a thing? I could take a stab at this, but it would be from a different angle. Some people might see a $1.5M price tag and chuckle - not because they don't think ... data. Instead, it's shit animated graphics and designed for people who apparently do not care about the data.

Are all vegetables' sprouts safe to eat or is/are there exception/s?

Description : Are all vegetables' sprouts safe to eat or is/are there exception/s?

Last Answer : answer:Not that I’m aware of unless sprouted in a toxic environment. You could always google each seed you want to sprout individually if you were concerned but seeing as all the sprouts we eat we also eat either in plant form and/or in seed form I would be very surprised.

I was perusing my Questions For You and had 30 odd. I went in to read one question and when I went back to my Questions For You they were all gone with the exception of one. What happened?

Description : I was perusing my Questions For You and had 30 odd. I went in to read one question and when I went back to my Questions For You they were all gone with the exception of one. What happened?

Last Answer : answer:The last one. I deleted all your questions @tranquilsea. Actually, when questions reach a certain number of answers they drop out of the Questions for You' section. It seems to happen at this ... , but I have asked @augustlan about this myself. Off to delete other people's questions now :D

If you were forced to eliminate every physical possession from your life with the exception of what could fit into a single backpack, what would you put in it?

Description : If you were forced to eliminate every physical possession from your life with the exception of what could fit into a single backpack, what would you put in it?

Last Answer : Laptop, hunting knife, flask, a blanket and a change of clean clothes.

Shouldn't it be mandatory that Congress and the Senate fully participate in any Health Care System they deliver to the American public without exception?

Description : Shouldn't it be mandatory that Congress and the Senate fully participate in any Health Care System they deliver to the American public without exception?

Last Answer : I’d rather turn this around and say, shouldn’t the entire American public be entitled to the same level of coverage and care that is provided to Congress? After all it is a Government Program. If they don’t dread it for themselves, why do they dread it for us?

"The exception that proves the rule"?

Description : "The exception that proves the rule"?

Last Answer : answer:It’s a sarcastic extension of “There’s an exception to every rule.” Ergo, if there’s an exception, the rule must be true. Unfortunately, I couldn’t quickly come up with a bibliographic reference for you. Someone will be along shortly to oblige =)

If all humans in the entire world disappeared in an instant with the exception of you, what would you do and how would you live the rest of your life?

Description : If all humans in the entire world disappeared in an instant with the exception of you, what would you do and how would you live the rest of your life?

Last Answer : I'd probably kill myself.

Python Error : SystemError: error return without exception set -Web-Development

Description : Python Error : SystemError: error return without exception set -Web-Development

Last Answer : answer:

What is the exception of light ?

Description : What is the exception of light ?

Last Answer : Answer : As a result of overlapping two light waves emanating from a coherent source, the luminosity of a point increases and the intensity of another point decreases . This results in periodic light and dark ... 3. The two sources must be close together. 4. The two sources must be very fine.

Why is Platypus an exception in mammals ?

Description : Why is Platypus an exception in mammals ?

Last Answer : There are animals in the world that do not give birth even when they are mammals (mammals usually give birth) ; Instead, they lay eggs and hatch into babies. One such mammal is the platypus.

What is the exception of light ?

Description : What is the exception of light ?

Last Answer : When a wave travels through a medium with two colors of equal color and equal amplitude, the overlapping of the two waves results in a bright , sometimes dark surface of the medium. This phenomenon of light is called anomaly.

Which of these two freshwashes would be better ?? If I use Garnier Well Clear or Himalaya Kesar Freshwas , with the exception of Ga: Man: Econ Fight , then the problem will be , which of the two is best ?

Description : Which of these two freshwashes would be better ?? If I use Garnier Well Clear or Himalaya Kesar Freshwas , with the exception of Ga: Man: Econ Fight , then the problem will be , which of the two is best ?

Last Answer : First you have to understand what you want . Garnier Acno Fight basically works against pimples. Garnier Man Oil Clear Deep Cleansing Facewash, on the other hand, cleanses the skin from ... fresh. Creo menthol leaves feeling cold. Eliminates oily feeling. Provides essential hydration to the skin.

why is it that only on valentines day do couples show each other (respect for the exception) that they love each other ???

Description : because it's an inherited holiday that we haven't celebrated so far and now :)

Last Answer : because a lot of people are so busy in everyday life that they're potting their loves :) I personally don't have a valentine's day because it doesn't matter at all this day :)

Which one of the following groups of animals is correctly matched with its one characteristic feature without even a single exception

Description : Which one of the following groups of animals is correctly matched with its one characteristic feature without even a single exception

Last Answer : Which one of the following groups of animals is correctly matched with its one ... jaw D. Chondrichthyes : Possess cartilaginous endoskeleton

Which of the following represent the correct combination without any exception ?

Description : Which of the following represent the correct combination without any exception ?

Last Answer : Which of the following represent the correct combination without any exception ?

Which pair of characters are found without exception in all mammals

Description : Which pair of characters are found without exception in all mammals

Last Answer : Which pair of characters are found without exception in all mammals A. Hair and vivipary ... glands D. Mammary glands and internal fertilization

Which one of the following categories of animals, is correctly described with no single exception in it ?

Description : Which one of the following categories of animals, is correctly described with no single exception in it ?

Last Answer : Which one of the following categories of animals, is correctly described with no single ... are viviporous and possess diaphragms for breathing.

Which one of the following groups of animals is correctly matched with its characteristic feature without any exception ?

Description : Which one of the following groups of animals is correctly matched with its characteristic feature without any exception ?

Last Answer : Which one of the following groups of animals is correctly matched with its characteristic feature without ... . Mammalia : Given birth to young ones.

$ Viruses are not an exception to all theory ! During mitosis the number of chromosomes is reduced to a half.

Description : $ Viruses are not an exception to all theory ! During mitosis the number of chromosomes is reduced to a half.

Last Answer : $ Viruses are not an exception to all theory ! During mitosis the number of chromosomes is reduced to a half ... wrong D. If both As and R are wrong.

What is the octet rulewhich element is the exception?

Description : What is the octet rulewhich element is the exception?

Last Answer : Need answer

Is water an exception to the octet rule?

Description : Is water an exception to the octet rule?

Last Answer : It is one of many, many exceptions to the octet rule. Hydrogendoes NOT require 8 electrons.

What concept is considered an exception to Mendel's law of independent assortment?

Description : What concept is considered an exception to Mendel's law of independent assortment?

Last Answer : Gene linkage us considered an exception to Mendel's Law ofIndependent Assortment.

What is one exception of the full faith and credit clause?

Description : What is one exception of the full faith and credit clause?

Last Answer : What is the answer ?

What scripture describe a biologic law of reproduction for which no exception has ever been documented?

Description : What scripture describe a biologic law of reproduction for which no exception has ever been documented?

Last Answer : What is the answer ?

With the exception of glycine all amino acids found in protein are (A) Isocitrate dehydrogenase (B) Fumarase (C) Succinate thiokinase (D) ATPase

Description : With the exception of glycine all amino acids found in protein are (A) Isocitrate dehydrogenase (B) Fumarase (C) Succinate thiokinase (D) ATPase

Last Answer : Answer : B

Management by exception implies focussing attention on– (A) All variations (B) Normal variations (C) Abnormal variations (D) Randomly selected variations

Description : Management by exception implies focussing attention on– (A) All variations (B) Normal variations (C) Abnormal variations (D) Randomly selected variations

Last Answer : Answer: Abnormal variations

The ‘Principle of Exception’ states that management should– (A) Check everything without exception (B) Invariably take corrective action without exception (C) Accept exceptions in emergencies (D) Concentrate their attention on exceptions

Description : The ‘Principle of Exception’ states that management should– (A) Check everything without exception (B) Invariably take corrective action without exception (C) Accept exceptions in emergencies (D) Concentrate their attention on exceptions

Last Answer : Answer: Concentrate their attention on exceptions

The closed circulatory system is more efficient. Since blood circulates only inside blood vessels it can do it with more pressure reaching farther distances between the organs where hematosis happens and the peripheral tissues. In addition the circulatory speed also heightens making possible more oxygen supply to great consuming tissues, like the muscle tissues that then can perform faster movements. Animals with an open circulatory system (with the exception of insects that do gas exchange independently from the circulation) are generally slower and have a low metabolic rate.

Description : The closed circulatory system is more efficient. Since blood circulates only inside blood vessels it can do it with more pressure reaching farther distances between the organs where hematosis ... exchange independently from the circulation) are generally slower and have a low metabolic rate.

Last Answer : What is the difference between octopuses and mussels regarding their circulatory systems?

Open circulatory system is the one in which blood does not circulate only inside blood vessels but it also falls in cavities that irrigate tissues. In the open circulatory system the blood pressure is low and generally the blood (called hemolymph) has low cellularity. Arthropods, molluscs (the cephalopods are exception) and protochordates have open circulatory system. The Circulatory System - Image Diversity: open circulatory system

Description : Open circulatory system is the one in which blood does not circulate only inside blood vessels but it also falls in cavities that irrigate tissues. In the open circulatory system ... and protochordates have open circulatory system. The Circulatory System - Image Diversity: open circulatory system

Last Answer : What is a closed circulatory system?

What is true about viruses without exception? (1) They contain a core of RNA (2) They can infect bacteria (3) They cannot produce antibodies (4) They can multiply only in host cells

Description : What is true about viruses without exception? (1) They contain a core of RNA (2) They can infect bacteria (3) They cannot produce antibodies (4) They can multiply only in host cells

Last Answer : (4) They can multiply only in host cells Explanation: Viruses do not contain enzymes for energy production or protein synthesis. For a virus to multiply, it must invade a host cell and direct the host ... proteins, and copies of its nucleic acid, using the host cell's ATP to power the reactions.

Banks can not generally accept interest-free deposits. which of the following is an exception to this rule? A. Current Account B. Savings Account of Minors C. Deposit from Minority groups D. BSBDA E. None of the Above

Description : Banks can not generally accept interest-free deposits. which of the following is an exception to this rule? A. Current Account B. Savings Account of Minors C. Deposit from Minority groups D. BSBDA E. None of the Above

Last Answer : A. Current Account Explanation: Banks cannot accept interest free deposits other than in current account.

What is an Exception ? What are types of Exception ?

Description : What is an Exception ? What are types of Exception ?

Last Answer : Exception is the error handling part of PL/SQL block. The types are Predefined and user defined. Some of Predefined exceptions are. CURSOR_ALREADY_OPEN ... INVALID_CURSOR INVALID_NUMBER LOGON_DENIED NOT_LOGGED_ON PROGRAM-ERROR STORAGE_ERROR TIMEOUT_ON_RESOURCE VALUE_ERROR ZERO_DIVIDE OTHERS.

What is a predefined exception available in forms 4.0?

Description : What is a predefined exception available in forms 4.0?

Last Answer : Raise form_trigger_failure

What’s the C# syntax to catch any possible exception?

Description : What’s the C# syntax to catch any possible exception?

Last Answer : A catch block that catches the exception of type System.Exception. You can also omit the parameter data type in this case and just write catch {}.

Will the finally block get executed if an exception has not occurred?

Description : Will the finally block get executed if an exception has not occurred?

Last Answer : Yes.  

What is an exception?

Description : What is an exception?

Last Answer : A runtime error. 

What’s the C# syntax to catch any possible exception?

Description : What’s the C# syntax to catch any possible exception?

Last Answer : A catch block that catches the exception of type System.Exception. You can also omit the parameter data type in this case and just write catch {}.

Will the finally block get executed if an exception has not occurred?

Description : Will the finally block get executed if an exception has not occurred?

Last Answer : Yes. 

General exception of this code provides that nothing shall be an offence which is done by a) Under 18 years b) Under 16 years c) Under 10 years d) Under 7 years

Description : General exception of this code provides that nothing shall be an offence which is  done by  a) Under 18 years b) Under 16 years c) Under 10 years d) Under 7 years

Last Answer : d) Under 7 years

Which are the not causes of the interrupt: a. In any single device b. In processor poll devices c. Itis an external analogy to exception d. None of these

Description : Which are the not causes of the interrupt: a. In any single device b. In processor poll devices c. Itis an external analogy to exception d. None of these

Last Answer : c. Itis an external analogy to exception

The auditor is most likely to presume that a high risk of fraud exists if a. The client is a multinational companythat does business in numerous foreigncountries.b. The client does business with severalrelated parties.c. Inadequate segregation of dutiesplaces an employee in a position toperpetrate and conceal thefts.d. Inadequate employee training results inlengthy EDP exception reports eachmonth

Description : The auditor is most likely to presume that a high risk of fraud exists if a. The client is a multinational company that does business in numerous foreign countries. b. The client ... perpetrate and conceal thefts. d. Inadequate employee training results in lengthy EDP exception reports each month

Last Answer : Inadequate segregation of duties places an employee in a position to perpetrate and conceal thefts