|
|
#1
06-28-2020, 09:33 AM
|
|||
|
|||
What's wrong with formulae?
=IF(B2="",A1,N(A1)+1)
 Why it is showing 66 so many times instead of once? 
|
|
#3
06-28-2020, 10:29 PM
|
|||
|
|||
|
Attaching the file will take off several days from you getting right answer probably, but on wild guess from 2 mm I can see about column B, it looks like cells B82:B88 are merged.
|
|
#5
06-29-2020, 10:07 AM
|
|||
|
|||
|
I attached my file with B merged cells.
|
|
#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 2013
Linear Mode
