Hi,
Here is an example of my spreadsheet: Excel example.xlsx
I would like to get all the bid/ask quotes for the different currency pairs in sheet 2 into sheet 1 sorted by the right date and time.
I need a formula which recognize the time + the currency from sheet 1 and search for it in sheet 2 then brings the right bid/ask quote back into sheet 1.
What kind of formula would you recommend?
Thanks for your time and help!
Last edited by EvoBob; 06-18-2013 at 02:31 PM.
go with this in Cell B3 on sheet1
=SUMIFS(Sheet2!C:C,Sheet2!$B:$B,CONCATENATE("=",Sheet1!$B$1),Sheet2!$A:$A,CONCATENATE("=",$A3))
I note that the formatting between your two sheets appears to be different so that the formula doesn't work.
To amend - select cell A3 on sheet 1 - hit F2 and then enter - repeat to the bottom of the row. This effectively activates the cells.
Not sure how you get the data into each sheet - so can't advise how you can avoid this issue in future - their are easy workarounds for this anyway.....
Hi Evobob,
See the attached file, green cells, select them all and drag down.
Formula:
Please Login or Register to view this content.
Excel example.xlsx
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks