View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Lining up values

Can you upload a sample file & post a direct link to it here?
You could use:
http://www.freefilehosting.net/
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
wrote in message
...
Hello all,
I am attempting to sort data based on the values in three columns.
I have Column D, I, and N, which represent species codes of fish. The
three columns represent different sites (1, 2, 3). I need to line up
the species codes but not every code in (for instance) site one is
found in the other two. Is there a way to automatically insert blank
lines where the species codes don't line up? For instance, species
2134 is found at sites 1 and 3, but not at 2, so the species codes for
the three sites are not lined up. Thanks in advance for your help.

Mike