Hi All,
Need formulas to copy data from Source Sheet ( StartEnd Change) to Target sheet (Sheet5) for all the values within excel workbook as below
Attached the Excel Sheet.
Thank You.
Hi All,
Need formulas to copy data from Source Sheet ( StartEnd Change) to Target sheet (Sheet5) for all the values within excel workbook as below
Attached the Excel Sheet.
Thank You.
Last edited by click2chaitu; 02-13-2020 at 07:48 AM.
Invalid attachments. Please see the instructions at the top of the page on how to attach the workbooks properly. Don't attach images, please.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I feel as if this is easiest accomplished by doing the calculations on the start end change sheet and then referencing those cells on sheet5.
For years (row 30): =COUNT(B2:B26)
For negative years (row 31): =COUNTIFS(B2:B26,"<0")
For positive years (row 32): =COUNTIFS(B2:B26,">=0")
Note that this assumes a value of zero would be counted as positive.
Columns B:E on sheet5 are populated using formulas similar to: =INDEX('StartEnd Change'!B$29:H$29,MATCH(A2,'StartEnd Change'!B$1:H$1,0))
Note that column E could be populated using: =C2-D2 providing the above note is true.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks