Question description:
This user has given permission to use the problem statement for this
blog.
I have in the past used a function in Excel to create a To Do list and once you enter a date in the completed column, the entire row drops to the bottom of the list as it has been completed. The item is therefore not deleted from the list but simply goes to the bottom. Cant find anywhere how to use this function or what it is called.
Solved by K. C. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
30/08/2017 - 10:26
Hello Welcome, Thanks for choosing Got It Pro-Excel How may I help you today?
Excelchat Expert
30/08/2017 - 10:27
What function you are trying to use?
User
30/08/2017 - 10:29
No thanks
Excelchat Expert
30/08/2017 - 10:29
I will help you Sir
Excelchat Expert
30/08/2017 - 10:30
could you please write example in excell
User
30/08/2017 - 10:31
Do you need more information?
Excelchat Expert
30/08/2017 - 10:31
Yes
Excelchat Expert
30/08/2017 - 10:31
Sir
Excelchat Expert
30/08/2017 - 10:31
I can help you
Excelchat Expert
30/08/2017 - 10:32
but I need more clearly details
User
30/08/2017 - 10:38
Are you there?
Excelchat Expert
30/08/2017 - 10:38
Yes Sir
Excelchat Expert
30/08/2017 - 10:38
am waiting for your information
Excelchat Expert
30/08/2017 - 10:40
Is there anything else you want to know regarding this issue?
User
30/08/2017 - 10:41
Apologies - messages were not coming through
Excelchat Expert
30/08/2017 - 10:42
no problem Sir
User
30/08/2017 - 10:42
I will show you a sample
Excelchat Expert
30/08/2017 - 10:42
okey
User
30/08/2017 - 10:42
I want the items in the rows with a completed date entered to drop to the bottom of the list automatically. Can you help?
Excelchat Expert
30/08/2017 - 10:42
What do you want to do?
User
30/08/2017 - 10:43
That way only the uncompleted items will stay at the top to be complted.
Excelchat Expert
30/08/2017 - 10:46
Sir
Excelchat Expert
30/08/2017 - 10:46
you can add filter
Excelchat Expert
30/08/2017 - 10:46
select blank
User
30/08/2017 - 10:46
I dont know how to do that.
Excelchat Expert
30/08/2017 - 10:46
and find uncompleted works
Excelchat Expert
30/08/2017 - 10:47
As I understand in column E
User
30/08/2017 - 10:48
Yes
User
30/08/2017 - 10:48
When I filter and select blank then all my completed items disappear. I want them to stay on the sheet but at the bottam.
Excelchat Expert
30/08/2017 - 10:48
the dates mean that the items is completed
User
30/08/2017 - 10:48
yes
User
30/08/2017 - 10:49
But I want a date completed to remain so I can use the worksheet as a template for the to do list for the next year.
Excelchat Expert
30/08/2017 - 10:52
Sir an other way you can highlight by color the date
User
30/08/2017 - 10:53
How does that work?
Excelchat Expert
30/08/2017 - 10:53
then via filter you can search only "no fil"
Excelchat Expert
30/08/2017 - 10:53
Please highlight
Excelchat Expert
30/08/2017 - 10:53
dates
Excelchat Expert
30/08/2017 - 10:54
plz
Excelchat Expert
30/08/2017 - 10:54
please filter all colums
Excelchat Expert
30/08/2017 - 10:55
Plz
Excelchat Expert
30/08/2017 - 10:55
select from filter
Excelchat Expert
30/08/2017 - 10:55
Filter by color
User
30/08/2017 - 10:57
Yes - that works but it is not really what I am after. Thanks for you help.
Excelchat Expert
30/08/2017 - 10:58
What additionaly can I help you related to this issue?
User
30/08/2017 - 10:58
Thats all thank you.
Excelchat Expert
30/08/2017 - 10:59
Sir according to your logic we ca do only this operation
Excelchat Expert
30/08/2017 - 10:59
to find completed and uncompleted work
Excelchat Expert
30/08/2017 - 10:59
if everything is ok
Excelchat Expert
30/08/2017 - 10:59
Thanks for using Got It Pro-Excel
Excelchat Expert
30/08/2017 - 11:00
Please give your kind feedback for our service
Excelchat Expert
30/08/2017 - 11:00
Have a good day ahead
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
