Dan Wilson
Well-known Member
- Joined
- Feb 5, 2006
- Messages
- 507
- Office Version
- 365
- Platform
- Windows
Good day. I am running Excel out of Office 365 on Windows 10. I have a worksheet that contains user entered data in Column F and a formula in Column G. There are two identical macros that sort the data in these two columns. The only difference between the macros is that one references Column F and the other Column G. Columns F and G are both formatted as Data with no decimal points. Column F is user entered data, Column G is calculated. When I run the Column F sort, all is well and the data is sorted in descending order. When I run the Column G sort, the data is sorted showing all "0" calculations first, then the remainder in descending order. Even when I do a manual sort using the Developer Sort function, the results are the same. What am I doing wrong? Any help is appreciated.
Thanks, Danno...
Thanks, Danno...