Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need to look to a table of data where column 1 represents employee name, and show all rows of that data where the employee name matches a certain value
Solved by K. L. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 15/03/2018 - 12:59
Hi
Excelchat Expert 15/03/2018 - 12:59
Welcome to got it pro
User 15/03/2018 - 01:00
Thanks
Excelchat Expert 15/03/2018 - 01:00
do you have any sample data so that i can help?
Excelchat Expert 15/03/2018 - 01:00
ok
Excelchat Expert 15/03/2018 - 01:01
A1?
User 15/03/2018 - 01:01
No. But lets start with this. In a separate tab I wast to bring back all rows that match Dean
Excelchat Expert 15/03/2018 - 01:01
ohk
User 15/03/2018 - 01:02
I want to bring back something like this
Excelchat Expert 15/03/2018 - 01:02
so you want to search all values against dean in sheet 1 and paste in sheet 2?
User 15/03/2018 - 01:03
Yes
Excelchat Expert 15/03/2018 - 01:03
but there are 2 rows of dean?
User 15/03/2018 - 01:03
Or lots of rows of Dean with other people in between
Excelchat Expert 15/03/2018 - 01:03
ohk
Excelchat Expert 15/03/2018 - 01:05
see columns F, G , H and I
Excelchat Expert 15/03/2018 - 01:05
we can do like this
Excelchat Expert 15/03/2018 - 01:06
get all data for dean in column F,G,H and I
Excelchat Expert 15/03/2018 - 01:06
does this help?
User 15/03/2018 - 01:06
Need to have it not have blank spaces
User 15/03/2018 - 01:06
I have a list of credit card charges for all of our employees in one file
Excelchat Expert 15/03/2018 - 01:06
since there are multiple rows of dean we cannot use proper vlookup also
User 15/03/2018 - 01:06
I need to separate that file into a separate file for each employee
Excelchat Expert 15/03/2018 - 01:06
hence this blank will come
User 15/03/2018 - 01:07
I know...:( That's my struggle
Excelchat Expert 15/03/2018 - 01:07
let me figure out this blank thing
User 15/03/2018 - 01:07
How can we get the blank not to come
User 15/03/2018 - 01:07
Thanks.
Excelchat Expert 15/03/2018 - 01:07
ok
Excelchat Expert 15/03/2018 - 01:07
figuring out
Excelchat Expert 15/03/2018 - 01:09
can we not remove this blank manually?
User 15/03/2018 - 01:10
Manually?
User 15/03/2018 - 01:10
Trying to avoid that
User 15/03/2018 - 01:10
I can sort the raw data by name if I need to
Excelchat Expert 15/03/2018 - 01:10
ok
Excelchat Expert 15/03/2018 - 01:11
so even if the blank come you can sort the data by name
Excelchat Expert 15/03/2018 - 01:11
so blank will automatically move down
Excelchat Expert 15/03/2018 - 01:11
will that help?
User 15/03/2018 - 01:11
??? not sure...how?
Excelchat Expert 15/03/2018 - 01:11
i mean in column f,g,h,and i when dean come
Excelchat Expert 15/03/2018 - 01:11
just sort them by name
Excelchat Expert 15/03/2018 - 01:12
and blank will move dow
Excelchat Expert 15/03/2018 - 01:12
like this?
Excelchat Expert 15/03/2018 - 01:12
will that not help?
User 15/03/2018 - 01:12
I would have to do that to 100 tabs...one for each employee.
Excelchat Expert 15/03/2018 - 01:13
then i guess that can be done using macro
Excelchat Expert 15/03/2018 - 01:13
vba code
Excelchat Expert 15/03/2018 - 01:13
where yo wll have to write a vba code and then run it once
User 15/03/2018 - 01:13
Can you help with that?
Excelchat Expert 15/03/2018 - 01:13
all the data will get sorted in that manner
Excelchat Expert 15/03/2018 - 01:13
i have no idea about vba code
Excelchat Expert 15/03/2018 - 01:13
but i know it can be done
User 15/03/2018 - 01:14
Is there anyone else who we can get to help with this?
Excelchat Expert 15/03/2018 - 01:14
this excel formula should also be pretty useful i guess
Excelchat Expert 15/03/2018 - 01:14
just that blanks are coming
User 15/03/2018 - 01:15
How about this...If I have a file where it is already sorted by name...
User 15/03/2018 - 01:15
Can I get excel to create a new tab for each break in name
Excelchat Expert 15/03/2018 - 01:16
i think that will also need a vba code
Excelchat Expert 15/03/2018 - 01:17
have a go through this
Excelchat Expert 15/03/2018 - 01:17
https://www.extendoffice.com/documents/excel/3196-excel-tab-name-equal-to-cell-value.html
Excelchat Expert 15/03/2018 - 01:17
this will help in vba code
Excelchat Expert 15/03/2018 - 01:18
please do give good rating
Excelchat Expert 15/03/2018 - 01:18
it really helps a lot

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.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc