View Single Post
  #1   Report Post  
hims
 
Posts: n/a
Default HOW TO MATCH MULTIPLE COLUMNS WITH OR WITHOUT GAPS IN eXCEL ?

Can anyone suggest me ways to simultaneously sort and match multiple colums .
The multiple columns mostly similar values with few dissimilar ones. I need
to sort in such a way that adjacent cells show similar values and if a
particular value is missing a gap is created.
Thanks in advance