LOOKUP, OFFSET question

Roc

New Member
Joined
Nov 25, 2005
Messages
32
Not sure what function required but here's prob.
Cell range T4-T3000 being filled from top down with external data updating every second (cells blank/empty prior to being filled). e.g after 1 sec 1 piece of data, 10 secs 10 pieces, 100 secs 100 pieces etc.
Need function to read most recent data from range which ignores all cells not yet filled. Having prob with blanks/ empty cells. Thx in advance.
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
Roc said:
Not sure what function required but here's prob.
Cell range T4-T3000 being filled from top down with external data updating every second (cells blank/empty prior to being filled). e.g after 1 sec 1 piece of data, 10 secs 10 pieces, 100 secs 100 pieces etc.
Need function to read most recent data from range which ignores all cells not yet filled. Having prob with blanks/ empty cells. Thx in advance.

If the data that flows in consists of numbers...

=LOOKUP(9.99999999999999E+307,$T$4:$T$3000)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,760
Messages
5,574,076
Members
412,566
Latest member
TexasTony
Top