Sorting and Eliminating Blank Cells in Formula range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a simple formula to compare 2 values and now I would like to
sort the cells Alpabetically but since they contain formulas. I would like to
find a way to place these values on a seperate worksheet and excel
automatically eliminate the blank cells.
 
Hi Santa's Helper,

on worksheet1, if your fomulas are on Column C.

1. insert a blank row on Row1
2. click column C header,
3. from menu, Data>filter>autofilter>non-blanks
4. select data on column C, click edit>copy

go to next worksheet2

5. on cell A2, click edit>pastespecial>values>enter
6. click column A header,
7. click autosort button (AZ) ..

take care of your original file, do this on another save-as workbook.
Merry Christmas.^2
 
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

SUMIF with criteria "<>" & "=" 4
Excel formula, sum the value cell and if empty cell left blank 0
Eliminating blank cells 7
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Sorting and Blank Cells 1
Excel VBA 1
formula finds values in apparently blank cells 1
help with formula for last input in column 6

Back
Top