HOW TO MATCH MULTIPLE COLUMNS WITH OR WITHOUT GAPS IN eXCEL ?

G

Guest

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
 
M

Myrna Larson

What is your definition of "similar"? Does it match any mathematical analysis
that Excel is able to perform?

When you say "similar", are you referring to values in the same column but
different rows, the same row but different columns, or a different row and
different column?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
column similarity 2
Sort multiple columns to look for gaps 6
Lookup changing data range in external workbook 5
Formula to Increment a number upon a match in an adjacent cell 9
How do I compare two columns of text data that are not exact 1
Match 2 columns + corresponding date? 1
Index and Match 8

Top