Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am working on a spreadsheet for our track team. I am trying to get it so
the events that students are in are automatically shown when their name is entered in an event. For example: Cell B6 has an event. Cells B7 to B10 have names of participants. I want those names to be compared to the names in Column J. If the name is found the event in B6 is put into Column K, If there is already an event then it is put into column L and so on. In the end it there should be a all of our athletes names and the events they are in in the columns to the right of their name. Is this even possible using the functions or will it take programming. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Comparing Columns, Then copying data | Excel Discussion (Misc queries) | |||
using VLOOKUP to compare 2 columns to find new information | Excel Worksheet Functions |