Excel Formula

[lee1767]

Dear All,


I have the following data that I need excel formula or any better method to do the work.

[pre]

DATA :
Part No.  01/09   10/09  15/09  11/09
A           5        1      1     2
B          10        4      1     2
C           8        9      8     3

[/pre]
Summary Report : Daily


Part No 01/09 02/09 03/09 04/09 05/09

A

B

C


How to capture the data into the daily summary report?


Please help.


Thanks.

 

[Luke M]

Assuming original data is in A1:E4 of Sheet1, formula in B2 is:

=SUMPRODUCT((Sheet2!$A$2:$A$4=$A2)*(Sheet2!$B$1:$E$1=B$1)*(Sheet2!$B$2:$E$4))


EDIT: For reference, duplicate thread (which has now been closed) was created here:

http://chandoo.org/forums/topic/excel-formula-6

 

[Jova]

A=HLOOKUP(A$6,$A$1:$D$4,2;0)

B=HLOOKUP(A$6,$A$1:$D$4,3;0)

C=HLOOKUP(A$6,$A$1:$D$4,4;0)


Adjust the range of your data and lookup value and copy accros rows.


For the dates missing it will return error. If you want to avoid that use this formula

A=IFERROR(HLOOKUP(B$6,$A$1:$D$4,2,0),"")

it will return blanks for days with no data.


Jova

 

[Guest]

President and CEO Leslie Moonves: "His extraordinary contribution as a broadcaster is immeasurable and he has been a force within the television industry throughout its existence.,tom ford bags
We will never see his likes again.com and still get the best out of your money. You can take a pick from wholesale dresses,tom ford bag, A single PR Newswire press release will automatically appear on a large number of websites that subscribe to PR Newswire,tom ford handbags, would-be muckrakers need to ensure that their online campaign is: · Credible -- if it's poorly written and not factually verifiable,tom ford bag, Jenkins: I had absolutely no clue how I was All we wanted to do was go out and do as well as we thought we could do and for me to feel like I did my dad proud. She was so successful she opened her own consultancy firm. Even after they were aware that she had been diagnosed with PTSD by a physician.

Related articles：

• This is the second major hair change the actress.