Hello,
I have a column (Column A) with a formula that only returns values on certain rows otherwise it returns "". I need a formula for column B that subtacts the next value in the column skipping over the blank ("") ones.
For example
Column A : 5 ,"","","","",3,"","","",-2,"","","","","","",9
Column B : 2 ,"","","","",5,"","","",-11,"","","","","","",""
column B is what I would like to achieve where the B1 would be A1-A6, B6 would be A6-A10, and B10 would be A10-A17
Thanks in advance.
Last edited by Renegade115; 02-25-2019 at 06:02 PM.
This should work:
=IF(A1="","",A1-INDEX(A2:A$17,MATCH(TRUE,INDEX(ISNUMBER(A2:A$17),0),0)))
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks