Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How to do opposite of LAG(), I need LEAD().
3,219 views
Skip to first unread message
Tim O'Rourke
May 6, 1999, 3:00:00 AM5/6/99
to
Does anyone know how to work around not having a LEAD() function, I.E. take
the value in the next cell and copy it here?
the value in the next cell and copy it here?
Any suggestions would be appreciated.
Tim O'Rourke
toro...@eidetics.com
Thomas Zapf-Schramm
May 6, 1999, 3:00:00 AM5/6/99
to
Sort your data in reverse order.
TZS
Tim O'Rourke schrieb in Nachricht <7gsr0b$c...@chronicle.concentric.net>...
Neila Nessa
May 10, 1999, 3:00:00 AM5/10/99
to
Tim,
CREATE nextcase = LEAD(yourvariable,1).
Neila
CREATE nextcase = LEAD(yourvariable,1).
Neila
Tim O'Rourke wrote in message <7gsr0b$c...@chronicle.concentric.net>...
Tim Daciuk
May 23, 1999, 3:00:00 AM5/23/99
to
Tim:
There is a LEAD function. It is in CREATE. Watch out, however, as it
seems (at least to my use) to demand a lot of memory.
There is a LEAD function. It is in CREATE. Watch out, however, as it
seems (at least to my use) to demand a lot of memory.
Sheesh...I have to keep my eye on you every minute!
Hope everything is going well.
Tim Daciuk
David Hitchin
May 24, 1999, 3:00:00 AM5/24/99
to
An easy way of getting LAG to do LEADING is to sort the data into
reverse order, use LAG, and then resort the data back to its original
order.
reverse order, use LAG, and then resort the data back to its original
order.
David Hitchin
0 new messages