I have a column of numbers. Every so often there is a blank cell with no number. I am trying to write a formula that will output the difference between the number right before a blank cell . . . and the number that followed the previous blank cell. Any ideas as to how to accomplish this in a faster/more productive way without manually doing this for each grouping is appreciated. Thank you.
Example.PNG
Hi kcrasch. Welcome to the forum.
I do not see how you are getting those numbers.
Since you already have a workbook with data please upload a sample workbook so we can see all of this in context.
If you do not know how to do this:
To attach a file to your post: (Please no pics or screenshots ... saves retyping data.),
- be sure to desensitize the data
- click “Go Advanced” (next to Post Quick Reply – bottom right),
- scroll down until you see “Manage Attachments”, click that,
- click “Browse”.
- select your file(s)
- click “Upload”
- click “Close window”
- click “Submit Reply”
The file name will appear at the bottom of your reply.
Dave
Here is an actual workbook with the type of numbers I need to generate. The numbers in the far right cell are the difference between groups of numbers in the far left cell.
E1: =IF(OR(B1 = "", B2 <> ""), "", B1 - INDEX(B:B, LOOKUP(9E+307, ROW(B$1:B1)/(B$1:B1="")) + 1))
Your choice of number formats in col B made the question needlessly cryptic.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks