# Excel - IF Function Problem - Expert Solution

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
Excelchat Expert 15/05/2018 - 05:19
doing good
User 15/05/2018 - 05:19
thats good
Excelchat Expert 15/05/2018 - 05:19
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
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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.