Top value Hi, i have a table like this: john 4500 john 1200 mary 900 jim 5000 john 3700 mary 2300 jim 1400 And i need formulas to extract top 5 values: I need something like this: John 9400 jim 6400 .....etc Can this be done? Thanks! ... 3 Jun 2010 10:03 Allow multiple rows of worksheet tabs for complex spreadsheets "Jason" wrote: "Peter Gross" wrote: In complex Excel spreadsheets, the current single line for worksheet tabs is restrictive. I have a worksheet with over 60 tabs. A summary worksheet pulls data from all of the other worksheets. I solved my navigation problem by putting a hyperli... 3 Jun 2010 07:51 how do i write on the background of a spreadsheet I want to wite sample accross my spreadsheet however do not know how to do this ... 3 Jun 2010 08:57 how to put a number with more than 15 digits in a cell ... 3 Jun 2010 05:40 how to calculate histogram from yearly dataset How do I calcualte histogram of yearly dataset and compute the probability of distribution of the data. For example: Year Value 1920 311.9 1921 146.6 1922 339.6 1923 113.3 ... 3 Jun 2010 05:40 Excel macro Hi, i need a macro to copy from one cell the text below and to paste only the contenet of the parenthesis. Invoice currency (USD): I need to paste only USD. The currency can contain "USD, EUR' CHF,...etc" Can this be done? Thanks! ... 3 Jun 2010 03:30 Cannot empty the clipboard And if this .exe is NOT in the Processes list, THEN what? This clipboard error is driving me NUTS! "Bas V" wrote: I meant rdpclip.exe -- Bas V "Bas V" wrote: Goeie middag! I have problems also with this message in Excel 2007. Use taskmanager to end process called rd... 3 Jun 2010 01:20 If word from list selected adjoining cell to downfill with a code If a word is selected from a drop-down list, is there a formula I can use to colour code the adjoining cell? ... 3 Jun 2010 01:20 If or formula Trying to create a formula that will do the following: If a1="1", then vlookup ...........or if A1="2" then vlookup...... ... 3 Jun 2010 08:57 Blank cells not to compute I have cells that say if value is equal a certain points will be given if a tie 2 points are given by comparing the score in 2 cells. the problem the games have not been played and is already showing a tie so everybody is gotten their 2 points for the tie and 5 point for getting the score correct blank = blank... 2 Jun 2010 23:08