|
|
#6
06-29-2020, 10:55 AM
|
|||
|
|||
merged cells are again the problem. Everyone on this board is saying the same thing - dont use them.
as a test in your file go to cell c1 and type =b1, this will show you want excel 'sees' (0 is am emtpy cell) so at row 21, excel can see that it contiains the merged data and therefore adds 1 to the number above, 22 is empty so it repeats the number above Last edited by Purfleet; 06-29-2020 at 10:56 AM. Reason: typo 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| help with formulae | Zoemoe | Excel | 3 | 07-02-2017 05:40 PM |
| How can I create multiple Formulae Easily | Chris Waller | Excel Programming | 0 | 09-01-2016 12:25 PM |
 formulae to combine excel records
|
H28Sailor | Excel | 7 | 03-31-2013 02:26 PM |
|
Use NUMPAGES in formulae
|
Friedebarth | Word | 1 | 11-30-2011 02:22 PM |
| Why wont my simple formulae work? | Florish | Excel | 4 | 02-17-2009 07:33 AM |
Windows 10 
Office 2019
Threaded Mode