Sorting Data

%3CLINGO-SUB%20id%3D%22lingo-sub-1221913%22%20slang%3D%22en-US%22%3ESorting%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1221913%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20set%20of%20data%20that%20is%20the%20results%20of%20physical%20performance%20tests.%20In%20the%20data%2C%20we%20have%20numbers%20that%20are%20how%20each%20person%20performed%20in%20the%20test.%20We%20also%20have%20text%20noting%20individuals%20that%20were%20injured%20at%20the%20time%20and%20therefore%20couldn't%20test.%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%2235%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2235%22%3E456%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E256%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EInj.%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E425%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EInj.%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E343%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E375%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E482%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E451%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E451%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3EWhen%20I%20sort%20the%20data%20in%20descending%20order%2C%20the%20cells%20containing%20%22inj.%22%20are%20always%20before%20the%20highest%20numerical%20value.%20My%20question%20is%2C%20how%20does%20excel%20evaluate%20the%20cells%20containing%20%22inj.%22%20in%20this%20type%20of%20instance.%20My%20internet%20searches%20have%20only%20yielded%20results%20for%20mixed%20numbers%20and%20text%20in%20the%20same%20cells.%20I'm%20mainly%20asking%20for%20my%20own%20edification.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1221913%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1221928%22%20slang%3D%22en-US%22%3ERe%3A%20Sorting%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1221928%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F579166%22%20target%3D%22_blank%22%3E%40jphillips12%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20Excel%20when%20compare%20any%20text%20is%20more%20than%20any%20number.%20You%20may%20do%20simple%20test%3A%20in%20A1%20any%20text%2C%20in%20B1%20any%20number%20and%20in%20C1%20%3DA1%26gt%3BB1%3C%2FP%3E%0A%3CP%3EResult%20is%20TRUE%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello everyone,

 

I have a set of data that is the results of physical performance tests. In the data, we have numbers that are how each person performed in the test. We also have text noting individuals that were injured at the time and therefore couldn't test. 

456
256
Inj.
425
Inj.
343
375
482
451
451

When I sort the data in descending order, the cells containing "inj." are always before the highest numerical value. My question is, how does excel evaluate the cells containing "inj." in this type of instance. My internet searches have only yielded results for mixed numbers and text in the same cells. I'm mainly asking for my own edification.

1 Reply
Highlighted

@jphillips12 

In Excel when compare any text is more than any number. You may do simple test: in A1 any text, in B1 any number and in C1 =A1>B1

Result is TRUE