![]() |
|
#6
|
|||
|
|||
|
Hi
Please find herewith a solution. The issue is because after the first formula you were creating a circular reference in the other columns. By inserting an extra column between each of your columns and putting the formula in each blank column avoids the circular reference problem. I am sure Colin will come up with a more efficient solution. Hope this helps. Tony (OTPM) |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Word count question | Wuffybrother | Word | 3 | 03-22-2019 03:40 AM |
Count in Excel
|
zanat0s | Excel | 3 | 06-09-2011 10:53 AM |
| Don't count hidden slides | Lu_Argentina | PowerPoint | 0 | 10-12-2010 02:12 PM |
| How to Count from Different Cells? | Shahzad | Excel | 3 | 06-26-2010 01:06 AM |
| Don't count 0 in a chart | Rmaisone | Excel | 0 | 08-21-2006 12:26 PM |