Posted to microsoft.public.excel.misc
|
|
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
---
|