Go to Data--Subtotals and subtotal by PO number and select the MAX function
in the dialogue box. That should show you the largest numbered PO for each
company.

Just make sure your data is formatted as a table. See here for more info:
http://office.microsoft.com/en-us/as...097981033.aspx

Dave
--
Brevity is the soul of wit.


"Gábor" wrote:

Hi,

i have a table with two columns: in column A are five different companies
and in column B are the numbers of outgoing invoices. i would like to find -
maybe by using vlookup function - the highest outgoing invoice nzmber at one
selected company. are there some kind of combination of formulas to solve
this problem?

thx in advance!