Thread: [Solved] Adding names of users from one column to another and color change to annual cap
View Single Post
 
Old 04-25-2017, 10:09 PM
xor xor is offline Windows 10 Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
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?
Reply With Quote