Question description:
This user has given permission to use the problem statement for this
blog.
This is going to be a bit weird but, I work at a cemetery and i was wondering if there was a way on excel for me to put all the people into a computer and sort them to the appropriate spot.
Solved by D. F. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
15/05/2018 - 05:17
hi
User
15/05/2018 - 05:17
hello
Excelchat Expert
15/05/2018 - 05:18
how are you doing
User
15/05/2018 - 05:18
good how about yourself?
Excelchat Expert
15/05/2018 - 05:19
doing good
User
15/05/2018 - 05:19
thats good
Excelchat Expert
15/05/2018 - 05:19
I read you rdescription
Excelchat Expert
15/05/2018 - 05:19
you asked to sort people into slots
Excelchat Expert
15/05/2018 - 05:19
what are the slots.. I think you want to build a excel from the start is that right
User
15/05/2018 - 05:20
the slots are the holes for the people, yes
Excelchat Expert
15/05/2018 - 05:21
Oh.. ok..
Excelchat Expert
15/05/2018 - 05:21
how many slots you have .. how would you decide the slot..
Excelchat Expert
15/05/2018 - 05:21
is it like the next available one?
User
15/05/2018 - 05:22
the is probably 5000+, we just want more of a data to help find where the people are placed easier
Excelchat Expert
15/05/2018 - 05:24
I think you would have to manually enter the 1st time .. for eg.. Alex - slot 1
Excelchat Expert
15/05/2018 - 05:24
then whenever needed you can find where there are placed like a directory
Excelchat Expert
15/05/2018 - 05:25
Something like this..
Excelchat Expert
15/05/2018 - 05:25
assuming you have 5000+ slots and not all are filled and you would have a book where you have kept all the records right
User
15/05/2018 - 05:26
yes but we just wanted to make it easier for the manager to just click on the name and it will show which spot they are in
Excelchat Expert
15/05/2018 - 05:26
yes tell me the slots for these 5 ppl
Excelchat Expert
15/05/2018 - 05:27
now
Excelchat Expert
15/05/2018 - 05:27
see the slot for zoe
Excelchat Expert
15/05/2018 - 05:27
[Uploaded an Excel file]
Excelchat Expert
15/05/2018 - 05:27
check this sample excel
Excelchat Expert
15/05/2018 - 05:28
on the top of first name or last name or even slot there is a down arrow
Excelchat Expert
15/05/2018 - 05:28
hen you click on it you can select what data you need to display..
Excelchat Expert
15/05/2018 - 05:29
so once you have entered all you data(which is now in a Book) into excel you can then manage to see who is placed in which spot
Excelchat Expert
15/05/2018 - 05:29
does that make sence?
Excelchat Expert
15/05/2018 - 05:30
Hello
Excelchat Expert
15/05/2018 - 05:31
are you there
Excelchat Expert
15/05/2018 - 05:32
Hello
Excelchat Expert
15/05/2018 - 05:32
Hello does this help you
Excelchat Expert
15/05/2018 - 05:34
hello are you there
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.
