Suppose I have...
A1 B1 C1 D1 E1...
B1 C1 & D1 are populated, E1... are empty
I want the contents of D1 to appear in A1
In other words, right-most populated cell value appears also in A1
How do I do that? ...Jim Thompson
-- | James E.Thompson, CTO | mens | | Analog Innovations, Inc. | et | | Analog/Mixed-Signal ASIC's and Discrete Systems | manus | | Phoenix, Arizona 85048 Skype: Contacts Only | | | Voice:(480)460-2350 Fax: Available upon request | Brass Rat | | E-mail Icon at