|
|
#17
07-10-2017, 12:29 PM
|
|||
|
|||
Thanks
Thank you, I have applied it to the sheet and have changed the cell it is working off however I do not think it is fully working please see attached.
There are cells returning a Zero instead of 1 or 2 etc also as this formula essentially creates a new units column is it possible to have it return the sum as well as the individual numbers of the other cells or a zero if it has been summed? please see below. i.e. 12345 - units 2 - count 0 12345 - units 5 - count 7 58244 - units 1 - count 1 48125 - units 9 - count 0 48125 - units 9 - count 18 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Consolidating Rows with same Resource Name | OTPM | Excel Programming | 2 | 05-30-2017 08:30 AM |
 Consolidating various word docs in one
|
Max Downham | Word | 6 | 11-23-2015 05:07 PM |
| Consolidating Sentences into One Paragraph | ctsolar | Word | 4 | 12-16-2013 04:50 PM |
|
Consolidating data using Macro
|
mrjamez | Excel Programming | 2 | 05-22-2012 06:50 AM |
| Help with consolidating multiple records into one | wbiggs2 | Excel | 0 | 11-30-2006 01:02 PM |
Windows XP 
Office XP
Threaded Mode