Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
getting a column name
please help me with this one ok? lets say i have two columns. in the first raw i have the names: a1= daniel a2=bill the next two rows are numbers b1=10 b2=20 c1=20 c2=40 what i need to do is to know who got the 20 in the previous row. so the cell c3 will be "bill" because in the "b" row bill got "20" as in the "c1" cell. it looks like that ----3-----2-----1---- ----------Bill---Daniel--a ----------20----10-----b ---bill----40-----20----c please help asap -- mordor ------------------------------------------------------------------------ mordor's Profile: http://www.excelforum.com/member.php...o&userid=23459 View this thread: http://www.excelforum.com/showthread...hreadid=498592 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
getting a column name
Try this in C3 ...
=INDEX($A$1:$A$2,MATCH(20,C$1:C$2,0)) You can also copy this along row 3 for other columns. Rgds, ScottO "mordor" wrote in message ... | | please help me with this one ok? | lets say i have two columns. in the first raw i have the names: | a1= daniel | a2=bill | the next two rows are numbers | b1=10 | b2=20 | c1=20 | c2=40 | what i need to do is to know who got the 20 in the previous row. | so the cell c3 will be "bill" because in the "b" row bill got "20" as | in the "c1" cell. | it looks like that | ----3-----2-----1---- | ----------Bill---Daniel--a | ----------20----10-----b | ---bill----40-----20----c | | please help asap | | | -- | mordor | ------------------------------------------------------------------- ----- | mordor's Profile: http://www.excelforum.com/member.php...o&userid=23459 | View this thread: http://www.excelforum.com/showthread...hreadid=498592 | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check COlumn - Excel VBA | Excel Discussion (Misc queries) | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |