Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ccoverne
 
Posts: n/a
Default Comparing and copying information from one cell to another

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing Columns, Then copying data jdb Excel Discussion (Misc queries) 1 December 16th 05 08:01 PM
using VLOOKUP to compare 2 columns to find new information Jessica Excel Worksheet Functions 3 July 19th 05 03:59 AM


All times are GMT +1. The time now is 06:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"