View Single Post
  #5   Report Post  
tgdavis
 
Posts: n/a
Default

Thank-you! Is there any way to supress the #N/A that results for rows where
all the cells are blank?


"Aladin Akyurek" wrote:

=LOOKUP(9.99999999999999E+307,Range)

tgdavis wrote:
Please help me with a formula for the following return last entry in row to
col. g:

a b c d e
f g
1 6/7/05 8/3/05 7/2/05
7/2/05

2 5/2/05
5/2/05

3 7/13/05 8/6/05
8/6/05

4 6/7/05 9/13/05
9/13/05