PDA

View Full Version : List Last nonblank cell in comment box or popup



Endorphin
10-20-2008, 11:43 PM
Hi All,

After some fantastic help from GTO :bow: yesterday I am after abit more.
The attached spreadsheet as you can see will contain voltages and dates. What I am trying to do this time is to list the newest voltage & dates for each ID in a comments box or some other sort of popup window and list all IDs that contain no voltage/Date in another popup window.
Again, any help appreciated.

VBA is French to my English, Enough to get a coffee but no idea how to ask what pi to six decimal places is. :dunno

Neil

Endorphin
10-21-2008, 10:52 PM
Ok, found a code to find the last empty cell and put it in the last column of the sheet. Just after some code now to copy Columns YXZ to a comment but filter out everything that is NOT blank

=AVERAGE(IF((K9:AB9<>"")*(MOD(COLUMN(K9:AB9),2)=1),K9:AB9))