View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.misc
Kingdazza Kingdazza is offline
external usenet poster
 
Posts: 8
Default Copying a row using a formula

Thanks Max have made the change

"Max" wrote:

Errata:
In Quote Log's U4, filled across/down:
=IF($G4<"yes","",IF(TEXT($K4,"mmmyy")=U$2,K4+ROW( )/10^10,""))


Should be:
=IF($G4<"yes","",IF(TEXT($K4,"mmmyy")=U$2,$K4+ROW ()/10^10,""))

(.. $K4, not K4. The all important $ sign was missed)

Here's the revised sample:
http://freefilehosting.net/download/40had

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600, Files:362, Subscribers:60
xdemechanik
---