Tables cells remove empty ones auto and reverse

Hello,

I have a table what gets in row a data from another file.
row a is about 200 long, and need to start with 50.
The empty ones he called 0.
I fixed the zero so that its empty.
Now i wanna sort with the filter on alphabet then he put the empty ones on top.
So i say don't filter the empty ones, So far so good.
But when the info changes en get row 51 he don't show on my sheet, so i must say to the filter get the empty ones press ok the put out the empty ones now i can see row 51.
I make this sheet for some one who doesn't know excel so can excel do this last steps automaticly.

Greetings

Is this an excel question, or an Access question? You have it in the Access forum.

Thread moved.

Why do you think that? Please be patient. It's early evening on a Bank Holiday Monday in the UK.

I moved this thread to the Formulas & Functions section (see post #4) - your unnecessary duplicate was closed.

Look up above!

Forum > Microsoft Office Application Help - Excel Help forum > Excel Formulas & Functions > Tables cells remove empty ones auto and reverse

I dont see where you uploaded your file?
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Thanks, it is there now

Yes, it's a slow burn ...

Thanks for the workbook.

The only way to do this is to deselect the blank rows. Excel will put a blank cell ahead of any letter of the alphabet when ordered A-Z.

See my edit to post #17.

I don't understand what you are saying - sorry.

but if its get new data it dont show until i select it

What does this mean?

The top and bottom of it is that unless you somehow filter out the blanks, you will not be able to sort your names A-Z with the names at the top - Excel just won't allow it.

I am not at all clear about what it is you are trying to achieve.

If I understand correctly you want the names and corresponding data to be arranged in alphabetical order.
To do that I propose using the following formula as modeled on sheet 3:

Formula:

Please Login or Register  to view this content.

Test by adding a name to one of the blanks in the range A7:A17 on sheet 2.
Let us know if you have any questions.

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools drop down in the ribbon above your first post. I hope that you have a blessed day.

I can't replicate the issue that causes the blank cells to display the #Name error. Could you upload a sample that shows this happening?
Let us know if you have any questions.