| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple criteria
Hi, i have a complex database sheet, but a simple example will show you what
i need: database sheet A B C John 12.05.2008 12 Mary 01.02.2009 14 John 04.04.2009 9 Mary 27.02.2009 4 result sheet A B C John 12.05.2009 12 Mary 27.02.2009 4 I need a code that return datas from "C" if "A" and "C" match. Something like: =if(A<,B<,return C), or something with match, vlookup....etc, i don't know. Can this be done? Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple criteria
Hi,
could you please be more specific, I see John twice in column A with different data in column B and C and you bring only the first line ?? "puiuluipui" wrote: Hi, i have a complex database sheet, but a simple example will show you what i need: database sheet A B C John 12.05.2008 12 Mary 01.02.2009 14 John 04.04.2009 9 Mary 27.02.2009 4 result sheet A B C John 12.05.2009 12 Mary 27.02.2009 4 I need a code that return datas from "C" if "A" and "C" match. Something like: =if(A<,B<,return C), or something with match, vlookup....etc, i don't know. Can this be done? Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple criteria
Hi, i have many of John entry with diferent data in column B, and an id in C
column. In result database, i will write in A, John, in B i will write a date and in C, i need the id that i have entered in that day for John. If i need another id from another day, i will change the data in column B. The same for Mary. Thanks! "Eduardo" a scris: Hi, could you please be more specific, I see John twice in column A with different data in column B and C and you bring only the first line ?? "puiuluipui" wrote: Hi, i have a complex database sheet, but a simple example will show you what i need: database sheet A B C John 12.05.2008 12 Mary 01.02.2009 14 John 04.04.2009 9 Mary 27.02.2009 4 result sheet A B C John 12.05.2009 12 Mary 27.02.2009 4 I need a code that return datas from "C" if "A" and "C" match. Something like: =if(A<,B<,return C), or something with match, vlookup....etc, i don't know. Can this be done? Thanks! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple criteria
Hi,
I assume that you are entering the information in another worksheet and you need the id to be pulled from the original sheet (sheet1) so in column C sheet 2 enter =sumproduct(--(a1=sheet1!$a$1:$a$100),--(b1=sheet1!$b$1:$b$100),sheet1!$c$1:$c$100) I assumed that your range is from 1 to 100 change it to fit your needs If this was helpful please click yes, thanks "puiuluipui" wrote: Hi, i have many of John entry with diferent data in column B, and an id in C column. In result database, i will write in A, John, in B i will write a date and in C, i need the id that i have entered in that day for John. If i need another id from another day, i will change the data in column B. The same for Mary. Thanks! "Eduardo" a scris: Hi, could you please be more specific, I see John twice in column A with different data in column B and C and you bring only the first line ?? "puiuluipui" wrote: Hi, i have a complex database sheet, but a simple example will show you what i need: database sheet A B C John 12.05.2008 12 Mary 01.02.2009 14 John 04.04.2009 9 Mary 27.02.2009 4 result sheet A B C John 12.05.2009 12 Mary 27.02.2009 4 I need a code that return datas from "C" if "A" and "C" match. Something like: =if(A<,B<,return C), or something with match, vlookup....etc, i don't know. Can this be done? Thanks! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple criteria
Works super great!!
Thanks allot! "Eduardo" a scris: Hi, I assume that you are entering the information in another worksheet and you need the id to be pulled from the original sheet (sheet1) so in column C sheet 2 enter =sumproduct(--(a1=sheet1!$a$1:$a$100),--(b1=sheet1!$b$1:$b$100),sheet1!$c$1:$c$100) I assumed that your range is from 1 to 100 change it to fit your needs If this was helpful please click yes, thanks "puiuluipui" wrote: Hi, i have many of John entry with diferent data in column B, and an id in C column. In result database, i will write in A, John, in B i will write a date and in C, i need the id that i have entered in that day for John. If i need another id from another day, i will change the data in column B. The same for Mary. Thanks! "Eduardo" a scris: Hi, could you please be more specific, I see John twice in column A with different data in column B and C and you bring only the first line ?? "puiuluipui" wrote: Hi, i have a complex database sheet, but a simple example will show you what i need: database sheet A B C John 12.05.2008 12 Mary 01.02.2009 14 John 04.04.2009 9 Mary 27.02.2009 4 result sheet A B C John 12.05.2009 12 Mary 27.02.2009 4 I need a code that return datas from "C" if "A" and "C" match. Something like: =if(A<,B<,return C), or something with match, vlookup....etc, i don't know. Can this be done? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
| match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
| Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Linear Mode
