Bruno,

USe data / autofilter and filter your list to show just 1, then copy and paste somewhere else, or to
show 0 then delete the rows with 0.

HTH,
Bernie
MS Excel MVP


"bruno" wrote in message
...
does anyone know how i can retrieve trading days only from a list of dates
and codes that are returned (1 or 0) when the date is not a holiday or
weekend/