View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NJ Office Man NJ Office Man is offline
external usenet poster
 
Posts: 1
Default Alligning two columns

Hello,

I was wondering if there is a way or formula to allign two columns based on
equal fields. I have columns similar to below and want to align column 'b' to
its matching cases in column 'a'. I'm sure this is very simple but im kinda
new to excel, thanks for any help!

1 2
2 4
3 6
4 8
5 10
6
7
8
9
10