View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
z.entropic z.entropic is offline
external usenet poster
 
Posts: 16
Default macro to delete the last value in each column

My worksheets have dozens of columns, each with up to a few thousand rows.
Both enumber of columns and rows varies from one data set tp another.

I'd like to have a macro that would delete the last value in each column,
but only if it's less than 90% of the penultimate value in that column.

Obviously, simply recording a macro with a Ctrl-Down key sequence in each
column will not work as the the last value is recorded as a static address,
but maybe using the OFFSET function would...

Help, please...

z.entropic