This is due to the feature of Small function if you investigate your formula output using f9. there is no 32nd numeric value in small function array
16 17 19 20 21 23 24 25 26 27 28 29 32 34 35 36 37 39 40 41 42 44 45 46 47 49 50 53 54 55 56 FALSE} FALSE ## ## ## ## FALSE ## ##...
one suggestion, you can make your pivot table dynamic or take reference from the table.
For more information, please refer below Url to make the dynamic pivot table.
Please use below formula to convert date
This happens due to incorrect date format, there is two way to resolve this problem
1) change your system date format
2) use above formula
For 1 - you can check with if condition (if the both values are same then result should be zero "0")
For 2 - see condition formatting required True / false and values and your formula return blank and formula -
=IF(the formula cell <0, 0,the formula cell) = 0 then x...
Can you please explain your query little more, do you want to update same cell (A1) every day and do you want to cumulative in cell B1.
Than there is no way to achieve this with this. you have to maintain historical data or use VBA but VBA is also will not be able to help you...
This could be a lengthy process to track every transaction to next translation age, to identify this you have check track every next transaction date and then calculate age between dates. if you want to find out first transaction v/s first repeat then you can refer enclosed file.