Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning other cells with the same value in a column, but different row.
I have a chart of data that I'm using as my reference. I don't know
even know if this is the best approach. I have 2 challenges to get over, but if I get over one, I think I can get the 2nd one. The sample chart setup is as follows: A B C D 1 name1 date1 (Name return) (user defined role search) 2 name2 date1 (Name return) 3 name3 date2 4 name4 date3 5 name5 date2 Ok, now assume D1 is the user defined cell. If "date1" was the input vaue for D1, Column C needs to return the names of all those who have that date specified in D1. The obstacle I encounter is that Excel usually only sees the first one with "date1" listed and repeats that name or complete disregards any other names with the same date. If I were to choose "date2" then we'd encounter the same problem again. I'm not even sure if my approach is the best way, so I welcome any suggestions as well. Jackson |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Returning other cells with the same value in a column, but different row.
If I understand what you want, then in C1, enter:
=IF(B1=D1,A1,"") Copy this formula down as needed. HTH, Paul wrote in message ups.com... I have a chart of data that I'm using as my reference. I don't know even know if this is the best approach. I have 2 challenges to get over, but if I get over one, I think I can get the 2nd one. The sample chart setup is as follows: A B C D 1 name1 date1 (Name return) (user defined role search) 2 name2 date1 (Name return) 3 name3 date2 4 name4 date3 5 name5 date2 Ok, now assume D1 is the user defined cell. If "date1" was the input vaue for D1, Column C needs to return the names of all those who have that date specified in D1. The obstacle I encounter is that Excel usually only sees the first one with "date1" listed and repeats that name or complete disregards any other names with the same date. If I were to choose "date2" then we'd encounter the same problem again. I'm not even sure if my approach is the best way, so I welcome any suggestions as well. Jackson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning cells with the same value in a column, but on different rows. | Excel Worksheet Functions | |||
Highest value in column b returning column a | Excel Worksheet Functions | |||
Excel - returning column headers in a seperate column | Excel Discussion (Misc queries) | |||
Returning the Row and Column titles of a certain value | Excel Discussion (Misc queries) | |||
Returning the last item in column | New Users to Excel |