Thread: Sorting rows
View Single Post
  #12   Report Post  
Old September 13th 13, 03:30 PM posted to microsoft.public.excel.newusers
Claus Busch Claus Busch is offline
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,647
Default Sorting rows

Hi,

Am Fri, 13 Sep 2013 14:04:47 +0100 schrieb Quilp:

The numbers, now out of sequence, are in column B


if the name of the CD or DVD is in column E and you will look for the
highest sequential number of the name in E1, then try:
=MAX(IF(E1:E1000=E1,B1:B1000))
and enter the array formula with CTRL+Shift+Enter.
If i still misunderstand your problem please upload a sample.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2