Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / December 2005

Tip: Looking for answers? Try searching our database.

Extracting Data from a list

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
andrewc - 13 Dec 2005 13:24 GMT
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 colum
C that meets a crierion in both columns A and B - for example, IBM an
31/01/2005  

I'd really appreciate it if someone can show me a formula that will d
this!

Many thanks
CLR - 13 Dec 2005 14:08 GMT
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

> I am trying to extract data from a list which is set up as follows:
>
[quoted text clipped - 14 lines]
>
> Many thanks!
andrewc - 13 Dec 2005 15:31 GMT
Thank you both for your help!

Signature

andrewc

Ron Coderre - 13 Dec 2005 14:08 GMT
See if something like this works for you:

=SUMPRODUCT(--(A1:A6="Microsoft")*(B1:B6="31/12/2004"),C1:C6)

Does that help?

Regards,
Ron

Signature

Ron Coderre

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.