|
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
|
|
#1
04-25-2017, 10:09 PM
|
|||
|
|||
In the Apr 17 tab, I need the users name in Column B to also appear in Column P for each instrument used.
In P2: =IFERROR(INDEX($B$2:$B$200,MATCH(L2,$E$2:$E$200,0) ),"") Also, in the Q1 tab, I'd like to list the number of users in Column C and the initials of the users in Column D. What's wrong with the formulas you already have at Q1!C2:C8 or is it something else you mean? What do you want at Q1!D2:d8? 
|
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Read multiple xml files in excel - Column names and Tag - Column alignment | sumshen | Excel Programming | 0 | 04-17-2017 12:55 AM |
 Tool to know color names - powerpoint Mac - Accessibility
|
zaddig | PowerPoint | 1 | 11-05-2016 03:12 AM |
| Color Coding Users in Shared Calendar | reyrey1332 | Outlook | 0 | 08-26-2014 07:03 AM |
| Adding names to sheet for printing | WV8VFD | Excel | 4 | 12-01-2013 11:02 PM |
|
matching names in column A with names in column C
|
bob999999 | Excel | 1 | 04-28-2013 11:21 AM |
Windows 10 
Office 2016
Hybrid Mode