#1
|
|||
|
|||
From numbers in a column, sum only those that are consecutive.
I have a s/s for billing that I use when submitting claims in an application that only allows input for a single date, or, if dates are consecutive, I must sum the amounts in order to enter the line item.
For example: John Doe for the month of September 9/1/2022 $13.96 Amt Claim Line 1 = $13.96 9/8/2022 $13.96 Amt Claim Line 2 = $13.96 9/12/2022 $13.96) Amt Claim Line 3 = $27.92 9/13/2022 $13.96) 9/15/2022 $13.96 Amt Claim Line 4 = $13.96 9/26/2022 $13.96 Amt Claim Line 5 = $13.96 9/29/2022 $13.96 Amt Claim Line 6 = $13.96 Is there a formula I can use that will do this for me through the 500+ rows in my s/s? |
#2
|
||||
|
||||
You could do something like the attached with a helper column and a pivot table.
|
#3
|
|||
|
|||
What if the date goes from a Friday to a Monday... Is that consecutive?
|
#4
|
|||
|
|||
Paste a chunk of the raw data into a sheet and post it, if you can.
Does the data always come to you in raw text format? Is it separated with {tab}s? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Return column header from first cell from consecutive cells below a threshold | zara007 | Excel | 6 | 05-30-2018 07:07 AM |
Counting Consecutive Periods In Rows Using Numbers | Yaaseen23 | Excel | 18 | 03-24-2017 11:15 AM |
find and replace consecutive numbers | kpl_39 | Word | 1 | 06-07-2013 05:04 AM |
Spliting column with text and numbers | mjosic | Excel | 3 | 04-04-2012 05:56 AM |
Consecutive page numbers on multiple documents | georgeeasten | Word | 1 | 02-10-2011 02:12 AM |