Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi Experts,
I have the following problem which I need to solve and have no idea on which functions I can use: In sheet one I would like to get a name of a person which has 2 conditions in sheet two: Structure of Sheet 2 Name - adress - Condition 1 - tel - condition 2 A - none - A - OK - E B - None - D - OK - E C - OK - A OK - C D - false - D - OK - G E - n/a - A - OK - E In the First sheet I would like that in the first line the person who has as: Condition 1 : A Condition 2 : E Result woult be person with name A Than I would like to insert a line Find next person with Condition 1: A condition 2: E Result would be person with name E Any idea if this is possible? and how? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
Excel 2002: Auto Sum function not working in large Excel file | Excel Discussion (Misc queries) | |||
challenge! javascript function into excel function | Excel Worksheet Functions | |||
Excel Workday Function with another function | Excel Discussion (Misc queries) | |||
Can you nest a MID function within a IF function in Excel | Excel Worksheet Functions |