Issue with imported data
OK here is what happens
1 - I create a SQL statment and pull data from a DB into Excel 2 - I edit the data range properties so it doesnt keep the cell format properties 3 - The data is imported into excel and I format date columns to MMMM/DD/YYYY 4- I then try to use the countif function which should do what I am asking it to do 5- when I use the function and highligh the column criteria that has 40 results from Aug to Oct I dont see dates as the sample date for the range I see numerical data like 706;724;724;.... which completly screws ths function argument NOW if I go to a new sheet and manually create 10 dates and run the countif function against the dates in the function argument syntax for the sample range I see the correct data which are the dates (June 13,2000;june 15,2000; .....) Some please tell me what I am missing here, why is my imported data format all meessed up, and only when I try to use function arguments -- Neall |
Issue with imported data
|
All times are GMT +1. The time now is 05:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com