View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] rumkus@hotmail.com is offline
external usenet poster
 
Posts: 22
Default No place for sum

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))))