Question
NESTED IF/THEN STATEMENT
Is it possible to create an if/then statement where if B4 = B3+1 than display the first number and the last number with a dash in between and if not then put a dash after the number in the cell. Result I am looking for based on the below would be: 64, 114-118, 282-284, 288-290. Any help is greatly appreciated.
Example:
Cell B3 is 64, Cell B4 is 114 and so on.
| MAP |
| 64 |
| 114 |
| 115 |
| 116 |
| 117 |
| 118 |
| 282 |
| 283 |
| 284 |
| 288 |
| 289 |
| 290 |
