Posts by tqv1969

  • COMPARE SHEET1 with SHEET2

    Re: COMPARE SHEET1 with SHEET2


    Dear Krisnakumar,


    Thank for your help. Could you help to highlight just those cell they are different only? And in case they are in different files how can I apply? Do we have the solution in VBA?


    Best regards,
    TQV

  • Compare data between two sheets

    Dear Gurus,


    I've got the issue to compare the data from two sheet. Could you please help on this? My data in two sheet wit hthe same header but the data when input are not match exactly. What I need is to point out the different is where for each sigle row e.g they are different only in one cell vs. other or event two And if they are match perfectly we will color them with green background for example.


    Best regards,
    TQV

  • Convert text od Date into Date field

    Re: Convert text od Date into Date field


    Dear Glenn/Fin Fang,


    Thanks for your efforts. It really appreciated.
    The point is the date column is inputted on the web site e.g by Word and the date that display is the one I want to have in Excel. But when I try to bring them into database in Excel I faced this problem.
    Anyway, You helped me to recude the work load for those didn't face this last issues. And for all the left I must re-input:crying: :crying: Thank you once again anyway.


    Best regards,
    TQV

  • COMPARE SHEET1 with SHEET2

    Re: COMPARE SHEET1 with SHEET2


    Dear Gurus,


    I've got nearly the same issue but in different format. Could you please help on this? My data in two sheet wit hthe same header but the data when input are not match exactly. What I need is to point out the different is where for each sigle row e.g they are different only in one cell vs. other or event two And if they are match perfectly we will color them with green background for example.


    Best regards,
    TQV

  • Convert text od Date into Date field

    Re: Convert text od Date into Date field


    Dear Glenn,


    Thank for your qick response. I tried and it worked but wrong date b/c now it seem that the cell will contain the date in Excel number code e.g: 12/02/2006 will be come 39053 and what we treat will not get the right data. Do you have any other suggestion?


    Best regards,
    TQV

  • Convert text od Date into Date field

    Re: Convert text od Date into Date field


    Dear Glenn,


    It worked. Thanks Glenn. But I still face the problem with the cell that present like this 12/1/2006. It should be 12 Jan, 2006 but with that type of input when I apply the special format it become 1 Dec,2006 or error message if I apply your formula. Do you have any suggestion?


    Best regards,
    TQV1969

  • Convert text od Date into Date field

    Dear Gurus,


    I've got the data base from the web but the date column is in text format e.g: 28/02/2006. I've tried to use funtion of Left & Mid to isolate day/month infor and put them toghether like this: =Mid(A2,4,2)&"/"&Left(A2,2)&"/2006" (result 02/28/2006 b/c my system set date in format mm/dd/yyyy) and try to change format to date but it didn't work. Please guide me any solution.


    Best regards,
    TQV1969

  • Count text with condition

    Re: Count text with condition


    Dear Bob,


    Thanks for your time. I've tried the fomular and it work but I din't understand about the fomular. Could you please guide me more if you have time?
    I've also have one more question that in case I wuold like to count the same but for a specific range e.g in that example from C3:F3 only how can I apply the fomular?


    Best regards,
    TQV1969

  • Make privot table from many data files

    Re: Make privot table from many data files


    Quote from royUK

    I think that if you have that much data then you ought to maybe think about using MS Access.


    Dear RoyUK,


    I've found the way to solve this issue. I put all data into Access file and make pivot table from Excel and select option "Get External Data" and at the end of wizard I can see all fields as in Excel. After that I can process the pivot as usual.


    Best regards,
    TQV1969

  • WeekNum funtion in acess

    Re: WeekNum funtion in acess


    Quote from bnix

    You could also use DatePart() to pull in the weeknumber in your query.


    Code
    "SELECT This_Date, DatePart("ww", This_Date) As WeekNumber
FROM my_table"


'assuming This_Date = 9/19/2005
'this would return 9/19/2005 and 39 as the weeknumber


    Dear Bnix,
    Thank for your attention. I've also thought to do in excel but my data is from monthly source and they are so big to rework for so many years.
    I will try your guide. But how can I put it in Access? I should put them in macro/module tab in access? I'm quite new in access :) .
    Best regards,
    TQV

  • WeekNum funtion in acess

    Dear Sir,


    I've imported the data base from excel and they have the field of Date only. In excel we have the WeekNum funtion that tell us that date belong to which week in 52 weeks of one year. How can I create one more field in Acsess table and put e.g Weeknum(Date) to get week number in a year?


    Best regards,
    TQV

  • Funtion to use beta binomial distribution for model data

    Re: Funtion to use beta binomial distribution for model data


    Quote from Derk

    I know what the binomial distribution is and what the beta distribution is, but I don't know what a beta binomial distribution might be. Is this a Baysian problem where the p value for the binomial has a beta prior distribution?


    Dear Derk,
    It used to analyse the TV viewing data. This model can calculate the cumulative reach in period of time from TV viewing data. It can be binominal distribution b/c my boss called it BBD very often.
    Best regards,
    TQV

  • Scatter chart in 3D!

    Re: Scatter chart in 3D!


    Dear Andy,


    That is great! You are the chart's expert. Thank you so much. I'm thinking how to make this more convinience e.g zoom in/out, change the scale to see more clearer as this case(threre are too many over lap).
    Btw, do you write any books about excel/access?


    Best regards,
    TQV

  • Scatter chart in 3D!

    Dear Sir,


    I've got the data in different scales and I would like to segment them into different groups. But the scatter XY chart can do for two set of data only. If I'd like to have one more axis e.g Z fo the third data set or even more, does that can work in excel? Or can we make the interactive chart those more data set will be scroll and it show different layers of XY chart while scrolling?
    I;ve try 3D column chart but it so complicated to see.
    Please help.
    Thanks
    TQV