#1
|
|||
|
|||
What's wrong with formulae?
=IF(B2="",A1,N(A1)+1) Why it is showing 66 so many times instead of once? |
#2
|
|||
|
|||
please add attachements so that we dont have to recreate the data and guess what you have in certain colunmns
|
#3
|
|||
|
|||
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.
|
#4
|
||||
|
||||
Merged cells in col B.....
|
#5
|
|||
|
|||
I attached my file with B merged cells.
|
#6
|
|||
|
|||
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 |