View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default No place for sum

select row 7 and below.
data sort by column B

" wrote:

Hi
Sorry. One more question.
How can I sort my list according to B column ? It is date.
(I mean with formula change)

On A7

=IF(sheet1!B2="nameA",ROW()-5,"")

On B7 and others

=IF(ROW(A1)COUNT($A:$A),"",INDEX(sheet1!A:A,SMALL ($A:$A,ROW(A1))))