Ask Your Question

How can I list all the clients w/phone #s first in a calc document?

asked 2018-12-03 16:05:41 +0100

lpet43 gravatar image

Not all clients in my calc document have phone numbers. I want to list those that do first.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2018-12-03 17:45:07 +0100

ebot gravatar image

Mark all columns and rows with clients, phones, etc. From the menu, select Data>Sort .... In the "Sorting" dialog box in the "Search criteria" tab, select "Sorting key 1" = "Phone" (it must be the column title). Select "Ascending" and OK.

edit flag offensive delete link more

answered 2018-12-04 13:24:00 +0100

BigRAl gravatar image

Assuming row 1 in your spreadsheet is used for column headings (you don't say or give an example):

Place the cursor in row 2 of the Phone # column and from the menu choose Data > Sort Descending.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-03 16:05:41 +0100

Seen: 74 times

Last updated: Dec 04 '18