| Home |
| Search |
| Today's Posts |
|
#16
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 --- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COPYING SUM/IF FORMULA | Excel Discussion (Misc queries) | |||
| Copying formula | Excel Worksheet Functions | |||
| copying the Hyperlink function result without copying the actual formula | Excel Worksheet Functions | |||
| Copying Formula | Excel Discussion (Misc queries) | |||
| Copying formula | Excel Discussion (Misc queries) | |||
Threaded Mode
