Question about Microsoft Office Professional 2007 Full Version for PC

# Have 1 row with seven columns with random data.want the figures to be in ascending or descending order in the row.How?

Posted by on

### Don Temp

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that gotĀ 5 achievements.

Sergeant:

An expert that hasĀ over 500 points.

Champion:

An expert who has answered 200 questions.

• Expert

Home paragraph group a/z The a/z stands for ascending decending order

Posted on Mar 04, 2011

• dinsejal Mar 05, 2011

Have 1 row with seven columns with random data.want the figures to be in ascending or descending order in the row.How?
REcd a comment from arfoob43 from your site .It was of no use.

×

### 6ya staff

SOURCE:

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### How to calculate median

Sort the data into ascending or descending order. If there's an odd number of data points then the median is the one in the middle. If there's an even number of data points then the median is the average of the two in the middle. Add the two together then divide by 2.

Mar 05, 2013 | HP 12c Calculator

### If there is an employee table containing salary column how to find the 3rd maximum salary in the salary column?

What software are you using? If you are using EXCEL, it's simple to select the column,
and then click 'Data' as 'SORT' and choose 'Descending', and then to pick the 3rd row in the ordered column.

Mar 30, 2011 | Microsoft Computers & Internet

### How to sort the number data in order in L1 for ex L1 -> L1 3 2 2 3 7 4 4 5 5 7 like that thanks

There are two functions available for sorting lists. Access them via [2nd] [List] "OPS".

SortA(list) sorts the list into ascending order.
SortD(list) sorts the list into descending order.

Jan 21, 2010 | Texas Instruments TI-84 Plus Calculator

### Hello i want to use h LOOK UP

Hi !!

How to implement Hlookup function:
• Select your data and sort it in ascending order
• Then type '=HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)'.
Lookup_value is the value to be found in the first row of the table. Lookup_value can be a value, a reference, or a text string. Table_array is a table of information in which data is looked up. Use a reference to a range or a range name. The values in the first row of table_array can be text, numbers, or logical values. If range_lookup is TRUE, the values in the first row of table_array must be placed in ascending order: ...-2, -1, 0, 1, 2,... , A-Z, FALSE, TRUE; otherwise, HLOOKUP may not give the correct value.
If range_lookup is FALSE, table_array does not need to be sorted. Uppercase and lowercase text are equivalent. You can put values in ascending order, left to right, by selecting the values and then clicking Sort on the Data menu. Click Options in the sort dialog box, click Sort left to right, and then click OK. Under Sort by, click the row in the list, and then click Ascending.
Row_index_num is the row number in table_array from which the matching value will be returned. A row_index_num of 1 returns the first row value in table_array, a row_index_num of 2 returns the second row value in table_array, and so on. If row_index_num is less than 1, HLOOKUP returns the #VALUE! error value; if row_index_num is greater than the number of rows on table_array, HLOOKUP returns the #REF! error value.
Range_lookup is a logical value that specifies whether you want HLOOKUP to find an exact match or an approximate match. If TRUE or omitted, an approximate match is returned. In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned. If FALSE, HLOOKUP will find an exact match. If one is not found, the error value #N/A is returned.
• If HLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the largest value that is less than lookup_value.
• If lookup_value is smaller than the smallest value in the first row of table_array, HLOOKUP returns the #N/A error value.
• If range_lookup is FALSE and lookup_value is text, you can use the wildcard characters, question mark (?) and asterisk (*), in lookup_value. A question mark matches any single character; an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.
• In the example in the Excel training video the sorted data represents the density of water at different temperatures. The left most column gives the temperature in degrees and the top column specifies the 'decimal' degrees
• We looked up the density of water at 5.4 degrees celsius using the Hlookupfunction.

Still have problems, Check this video on the you tube.

Hope this would help,

Thanks,
Anurag Shukla

Sep 04, 2009 | Microsoft Excel for PC

### Doesn't remember there's a Header Row

You can try to select all data (except for the entire row which contain your header) and try to sort thru columns. This can sorted in ascending or descending order.

Jul 17, 2009 | Microsoft EXCEL 2004 for Mac

### Autofilter ceases to work on large Excel 2003 spreadsheet

Sounds like there is a gap between the filter heading and the column data. That's the only time I've seen suggested data missing from the drop-down.

Jun 16, 2009 | Microsoft Computers & Internet

### The fate code

Here is the code: Enjoy

Fate

Cheatmode:
----------
Submitted by: Raziel_Soulreaver

Unverified. Press CRTL + SHIFT and the TILDE key (note this key is located differently
on PAL region keyboards). You should then have a prompt to enter the following codes.
Press ENTER to confirm the typed code.

Code Result
---------------------------
gold - will add large amount of gold to purse
god - will gain ten levels
fame - will add 1000 fame
descend - will descend one level
descend <#> - will descend # of levels
ascend - will ascend one level
ascend <#> - will ascend # of levels
Shrine of learning - summons shrine
Majic anvil - summons anvil
fate statue - summons statue
levelup - gain one level
heal - minor healing
experience - gain experience

<item name> summons specified item (any item);
example: town portal spell summons the "town portal spell";
superior sapphire summons "superior sapphire".

Cheats:
-------
Submitted by: DrakKnight

[Item Name] Summons an item near you. This cheat can summon artifacts, but not
flawless, superior, or exceptional versions of items

[Creature Name] Summons a creature near you. Any creature you summon this way will
exist as an enemy monster; however, typing "Cat" or "Terrier" will summon a pet
Levelup Gives you one experience level

Heal Restores all of your health
Gold Gives you 500,000 pieces of gold
God Gives you ten experience levels and eight to your pet
Dumpmap Creates a text description of the current map to a maze.txt file, which can be
found in the game's installation folder
Descend "#" Descend a "#" of levels (input a number and remove quotes)
Ascend "#" Ascends a "#" of levels (input a number and remove quotes)
Small Chest Shows up but there is nothing in it
Shrine Of Learning Creates a Shrine that when activated generates a random negative or
positive effect on character stats
Magic Anvil Creates an Anvil that when activated grants you a random Negative or positive
magical effect on an item
Fountain of Wellness Creates a Fountain that when activated replenishes Both Health & Mana
Fountain Of Stamina Creates a Fountain that when activated replenishes Stamina
Fountain Of Health Creates a Fountain that when activated replenishes Health
Fate Statue Creates a statute that when activated you get either a unique Monster or 2
Random Gems
Fountain of Mana Creates a Fountain that when activated replenishes mana
Chest Shows up but there is nothing in it
Large Chest Shows up but there is nothing in it
Storage trunk Shows up but can't be opened in town (This might work in dungeons)
Weapon Rack Shows up but can't be activated

---------------
Valkyr

Jan 25, 2009 | Computers & Internet

### Duplicacy in excel sheet

Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.
Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data
Select the entire data and do an auto filter
In column F filter the data by Duplicate and delete all these rows
What remains should be unique data

Dec 19, 2007 | Computers & Internet

### Changing data in table to rows

In what program? In Excel, you could simply select D,E,F and drag under A,B,C. Same with G

Aug 07, 2007 | Microsoft Office 2003 Basic Edition...

## Open Questions:

#### Related Topics:

39 people viewed this question

Level 3 Expert

Level 3 Expert