|
|
#2
08-19-2014, 01:21 AM
|
||||
|
||||
There is already a supervisor in B1, so all persons in col B have that supervisor. Problem solved ? I think there is something wrong there
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
#3
08-19-2014, 06:49 AM
|
|||
|
|||
|
The supr are listed in the top row with their employees below each name. All the employee names have been input in column B for this example.Column B would normally be empty. Is there a way to auto input the name of the supr for each person in Column A. The order of the employ name will change each day in column B but supr will stay the same. I have separated each group with a yellow highlight.
Hope I have not made this more confusing.
|
|
#4
08-19-2014, 11:06 AM
|
||||
|
||||
|
But why is there a supervisor in B1 ?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#7
08-19-2014, 02:50 PM
|
||||
|
||||
|
You have supervisqor names in B1:J1 but you want to find the supervisor name for persons in colB which are all under supervisor in B1...
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#8
08-19-2014, 03:07 PM
|
|||
|
|||
|
Hope to clarify
Ok in column B2,3,4 etc. I will be inserting emp names so I want to auto insert Supv name in Column A as I type in Column B.
Last edited by Excel; 08-19-2014 at 04:00 PM. Reason: Attach new spreadsheet
|
|
#9
08-20-2014, 03:36 AM
|
||||
|
||||
|
Try this in A2
Code:
=INDEX($C$1:$K$1,SUMPRODUCT((COLUMN($C$2:$K$17)*($C$2:$K$17=$B2)))-COLUMN($C$2:$K$17)+1)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#10
08-20-2014, 08:13 AM
|
|||
|
|||
|
OMG I so appreciate what you have done. I do have 2 issues. When I insert formula in A2 I get a REF! error. I do not get any results for the supr in column H.
#REF! IN A2 #REF! LW Nicole Cook FOR Column H Again thank you so much for your help thus far.
|
|
#11
08-20-2014, 12:04 PM
|
||||
|
||||
|
Care to post the sheet showing the problem?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#13
08-21-2014, 01:10 AM
|
||||
|
||||
|
All persons under the supervisor in col H are also in col G. XL finds two answers, and the formula does not work
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
#14
08-21-2014, 09:44 PM
|
|||
|
|||
|
Thank you for all your help. I still get the REF! error when I fill column A. I have to add about 20 more columns so I will have to adjust the formula and REF! error will have to show on sheet.
Again Thanks
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Pge numbers on pages and in TOC not matching
|
Marshalee | Word | 2 | 04-23-2014 10:40 AM |
|
Need help matching text to the Character Map
|
Bobosmite | Word | 1 | 07-12-2012 08:12 AM |
|
matching fileds in mail merge
|
estroh | Mail Merge | 3 | 01-19-2012 03:43 PM |
| avoid duplicete record and merge the record with the existed record | hemant.behere | Excel | 0 | 01-10-2012 02:53 AM |
| How to merge matching cells vertically? | Odiseh | Excel | 1 | 01-02-2010 02:41 PM |
Windows 7 32bit 
Office 2013
Linear Mode
