I am still having a problem figuring out how to identify when a value is greater than the value that comes before it, even if it is seperated by a few lines of errors. A sample of my data is below...if anyone can help please respond. Thanks! If possible, I would like to quantify the difference if a value on a later date is More than the value before it. If anyone needs more detail just say so. Thanks for all of your help. I have changed the errors to "NV" for ease.
5,745,063,946.30
7,068,203,722.46 ---True (or 2 billion and change)
5,602,064,833.27 False
NV
5,558,266,489.90 False
NV
5,138,950,142.83 False
NV
5,108,390,612.39 False
NV
NV
5,100,738,239.95 False
NV
4,761,400,527.68 False
NV
4,770,628,041.00 True
NV
NV
4,626,463,143.05 False
NV
NV
4,508,925,824.15False
NV
NV
4,472,536,354.04 False
NV
NV
4,425,447,546.19False
NV
NV
4,402,019,115.39 False
NV
NV
5,370,318,730.06 True
NV
NV
4,479,014,609.69
NV
NV
4,311,827,343.41
NV
NV
4,281,670,929.13
NV
NV
4,270,949,823.35
NV
NV
4,251,292,284.34
NV
NV
4,216,032,751.97
NV
NV
NV
4,205,580,854.82
5,745,063,946.30
7,068,203,722.46 ---True (or 2 billion and change)
5,602,064,833.27 False
NV
5,558,266,489.90 False
NV
5,138,950,142.83 False
NV
5,108,390,612.39 False
NV
NV
5,100,738,239.95 False
NV
4,761,400,527.68 False
NV
4,770,628,041.00 True
NV
NV
4,626,463,143.05 False
NV
NV
4,508,925,824.15False
NV
NV
4,472,536,354.04 False
NV
NV
4,425,447,546.19False
NV
NV
4,402,019,115.39 False
NV
NV
5,370,318,730.06 True
NV
NV
4,479,014,609.69
NV
NV
4,311,827,343.41
NV
NV
4,281,670,929.13
NV
NV
4,270,949,823.35
NV
NV
4,251,292,284.34
NV
NV
4,216,032,751.97
NV
NV
NV
4,205,580,854.82
