Home » Blogs » jawadbintahir's blog

Need help in calculation

jawadbintahir's picture
Submitted by jawadbintahir on 29 May, 2013 - 21:57

Dear All,
I am facing a problem. (sheet attached).

In given sheet, you can see the column of start, end and day. I need the difference of(B2 and C4) and answer will come on E4. as the day changes difference like (B8 and C12)changes, in this scenario. please advise any thing useful to sort attach sheet.

e.g.jpg
AttachmentSize
100172-56.xlsx111.05 KB
»

Solution

Submitted by Webby2013 on 10 June, 2013 - 22:06.

=IF(COUNTIF(A$2:A3,A3)
C2-OFFSET(C2,-COUNTIF(A$2:A2,A2)+1,-1),"")

»

Not sure if my last submission worked.

Submitted by Webby2013 on 10 June, 2013 - 21:54.

"=IF(COUNTIF(A$2:A3,A3)

»

Re: Need help in calculation

Submitted by Webby2013 on 10 June, 2013 - 21:52.

Paste this into cell A2, and copy it down.

=IF(COUNTIF(A$2:A3,A3)Let me know if this solves your problem! :-)

»
jawadbintahir's picture

Thank you

Submitted by jawadbintahir on 11 June, 2013 - 20:52.

i couldn't try this but thanks for help.. :)

»

It wont let me paste a simple formula in. ffs JOKE

Submitted by Webby2013 on 11 June, 2013 - 21:07.

<code>

=IF(COUNTIF(A$2:A3,A3)

<COUNTIF(A$2:A2,A2),

C2-OFFSET(C2,-COUNTIF(A$2:A2,A2)+1,-1),"")

</code>

This will work as you require, no pivot. Just paste into E2 and copy down.

»
Nick's picture

create a pivot table with row

Submitted by Nick on 6 June, 2013 - 11:27.

create a pivot table with row field PuDate, data fields Min of Start, and Max of End
... then you can simply subtract the data

»
jawadbintahir's picture

Problem Solved

Submitted by jawadbintahir on 11 June, 2013 - 20:50.

Thank you so much Nick..!! it's really worked

»