Sorting a column by using formula

  • Thread starter Thread starter Praise
  • Start date Start date
P

Praise

my sheet goes like this

Cell A1: Mr. abc
Cell A2: Mr. XYZ
Cell A3: Blank Cell
Cell A4: Blank Cell
Cell A5: Ms. Lee
Cell A6: Mr. PQR

The data in these cells is coming from another sheet. Now i Actuall
want to delete the blank cells in between this data i.e A3 & A4, an
get the outcome in another sheet. Can you pls help on this.
 
Praise,

As you have described the data, if we were to sort on column A, the
the prefix of Mr, Ms, etc will take precedence.

Ie your data will be :

Mr. abc
Mr. PQR
Mr. XYZ
Ms. Lee

Is this the order that you intended? If not, it will first be nesessar
to separate the name components. Are they currently stored separately?

How is the data sourced from 'another sheet', has it been copied an
pated or is it a formula lookup?

Please let me know
 
You must log in or register to reply here.

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

Blank Cells 3
if the numbers in sequence 11
Average Question 2
Copying of non-consecutive, columnar data into consecutive-columnarcells 3
Excel automatically changing my formula 7
Multiple If statemnets 9
Building closed workbook file path within an Index Function 6
Very strange behaviour of VLOOKUP in Excel 2010 4

Back
Top