Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting Data from a list
I am trying to extract data from a list which is set up as follows: A2 Microsoft B2 31/12/2004 C2 10 A3 Microsoft B3 31/01/2005 C3 11 A4 Microsoft B4 28/02/2005 C4 12 A5 IBM B5 31/12/2004 C5 66 A6 IBM B6 31/01/2005 C6 69 A7 IBM B7 28/02/2005 C7 72 Etc In one formula I would like to be able to extract the value from column C that meets a crierion in both columns A and B - for example, IBM and 31/01/2005 I'd really appreciate it if someone can show me a formula that will do this! Many thanks! -- andrewc ------------------------------------------------------------------------ andrewc's Profile: http://www.excelforum.com/member.php...o&userid=19613 View this thread: http://www.excelforum.com/showthread...hreadid=493013 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting Data from a list
Depending on what you want to do with the result...........one way is to
insert a new column A and concatenate the old A2 and B2 into the new A2, and copy down, then use a VLOOKUP formula to find that value and step over to the column you want....like =VLOOKUP(Microsoft&31/01/2005,A2:D100,4,FALSE) Vaya con Dios, Chuck, CABGx3 "andrewc" wrote: I am trying to extract data from a list which is set up as follows: A2 Microsoft B2 31/12/2004 C2 10 A3 Microsoft B3 31/01/2005 C3 11 A4 Microsoft B4 28/02/2005 C4 12 A5 IBM B5 31/12/2004 C5 66 A6 IBM B6 31/01/2005 C6 69 A7 IBM B7 28/02/2005 C7 72 Etc In one formula I would like to be able to extract the value from column C that meets a crierion in both columns A and B - for example, IBM and 31/01/2005 I'd really appreciate it if someone can show me a formula that will do this! Many thanks! -- andrewc ------------------------------------------------------------------------ andrewc's Profile: http://www.excelforum.com/member.php...o&userid=19613 View this thread: http://www.excelforum.com/showthread...hreadid=493013 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting Data from a list
See if something like this works for you: =SUMPRODUCT(--(A1:A6="Microsoft")*(B1:B6="31/12/2004"),C1:C6) Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=493013 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting Data from a list
Thank you both for your help! -- andrewc ------------------------------------------------------------------------ andrewc's Profile: http://www.excelforum.com/member.php...o&userid=19613 View this thread: http://www.excelforum.com/showthread...hreadid=493013 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
update data validation list with new entries?? | Excel Discussion (Misc queries) | |||
Dependent List (via Data Validation) Error | Excel Worksheet Functions | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
HOW DO I MAKE VALIDATION LIST CONTAING DATA FROM A DIFFERENT BO | Excel Discussion (Misc queries) | |||
subtotaling and manipulating a list of data | Excel Worksheet Functions |