View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kim Shelton at PDC Kim Shelton at PDC is offline
external usenet poster
 
Posts: 16
Default Create a List by formula from other data

I have a list of data that was created by formulas in column AH rows 3
through 134. It either states false in the cell or it has find the data
which is a job number like 6021. I want to create a list from that list so
that my list is only the job numbers and I will only have the number of rows
that I have job numbers for. So if out of the cells 3 through 134 I only
have 6 jobs numbers - I want a list of just 6 example:
6021
6022
6023
6075
6080
without any extra rows for the false