Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Search For:

Type: Posts; User: rksample

Page 1 of 3 1 2 3

Search For: Search took 0.01 seconds.

  1. Replies
    6
    Views
    757

    Re: ADO SQL Query Ignoring YEAR in the Date

    Hi Ashu,

    I got the same doubt and check the data.

    I got this working now. Seems like the problem is with the Extract. When I extract the CSV file with Date formatted as TEXT, ADO engine is able...
  2. Replies
    6
    Views
    757

    Re: ADO SQL Query Ignoring YEAR in the Date

    Hi Ashu,

    It is ofcourse dd/mm/yyyy - I should have sent you a couple of lines:

    BUY,Gas,C,Forward Transactions,TRD ,NBP97,FIRM,SSE Energy Supply...
  3. Replies
    6
    Views
    757

    Re: ADO SQL Query Ignoring YEAR in the Date

    Thanks Ashu for responding.

    I tried earlier and also tried by copying text from your response (to make sure it is exact). Did not fetch the expected result.

    Date format in .csv file as...
  4. Replies
    6
    Views
    757

    ADO SQL Query Ignoring YEAR in the Date

    Hi Excel Gurus,

    I have this weird problem that is bugging me since yesterday.

    I am trying to Automate a complex dashboard that queries data from various data input files (in CSV). I am using...
  5. Replies
    2
    Views
    1,241

    Re: VBA Help with Task Allocation Macro

    Hi All,

    I didn't get any response even after 24 hrs. So I modified the description for better understanding.

    Eagerly waiting for a lead on how to do this.

    Thank you,

    cheers,
    Ravi.
  6. Replies
    2
    Views
    1,241

    VBA Help with Task Allocation Macro

    Hi Excel Gurus,

    I need help with a small VBA logic that can loop through a set of tasks and assign Employees to the tasks.

    Process:


    I have a set of tasks (Task 1 to Task 10)
    I have 3...
  7. Matching if a value is present in a Array

    Hi Gurus,

    Quick help with an array related VBA problem. I have a table with information on what classes are assigned to a Teacher.

    Classes Teacher
    1 Ravi
    2 Kiran
    3 ...
  8. Re: Copy table values to Array variables and use them in another sheet!

    Thank you very much Nicolas. This is very helpful. I learnt the lesson needed. I hope I'll be able to apply it now.

    Regards,
    Ravi Kiran.
  9. Copy table values to Array variables and use them in another sheet!

    Hi Gurus,

    I have a query about using Array Variables in excel VBA. I have a set of lookup tables and a main data table. The data table will be downloaded everyday. I need to replace the ID's in...
  10. Replies
    5
    Views
    558

    Re: Chart for Top 3 values

    Thank you very much Stephen! I tried understanding the formula :( but no use. Though I am able to adapt it to my table :)

    If you got some time, can you please explain how the formula works.
    ...
  11. Replies
    5
    Views
    558

    Re: Chart for Top 3 values

    Thanks for you reply Stephen.

    That would be ideal. But I will be satisfied with 3 values supposed to be topped the whole list. I spent considerable amount of time modelling the table. But am stuck...
  12. Replies
    5
    Views
    558

    Chart for Top 3 values

    Dear Gurus,

    I need to create a chart from a table with the Top 3 values in the series.

    Please find the info in the below image.

    48226

    So when Class 1 is selected, the values in the Table...
  13. Re: Search for duplicate records in a selection

    Thanks Jindon, this code worked awesome. Thanks again.

    Regards,
    RK.
  14. Re: Search for duplicate records in a selection

    Thanks Jindon. I am checking out to customize the code.

    There are few titbits I didn't understand. What is "Scripting.Dictionary"?

    And where do I copy my script to extract the relevant data (if...
  15. Search for duplicate records in a selection

    I run a script in a loop for several records (Orders). The loop works fine. But the problem is, sometimes there are duplicates. Processing time for each record is high and having duplicates is...
  16. Replies
    3
    Views
    531

    Re: Separate Top 4 Values a list

    Thanks. But I need two formulas. One to copy the Values and another to copy the respective vendors as well :)

    I'll try to figure out. But would be helpful, if you can post the solution.
    ...
  17. Replies
    3
    Views
    531

    Separate Top 4 Values a list

    Dear Gurus,

    Need some help with this issue. I have a list of vendors who enter their sales data in an excel spread sheet. I need to isolate the top four and create a separate list using excel...
  18. Replies
    3
    Views
    498

    Re: Text to Date conversion issues

    I do use European Date system. And the time&date settings are correctly configured to UK on my system. I did trouble shoot that.

    There must me some other explanation, why the date is being...
  19. Replies
    3
    Views
    498

    Text to Date conversion issues

    Dear Gurus,

    I have a problem converting a column containing datetime values as text.

    ="06/07/2012 00:00:00"
    ="06/07/2012 00:05:00"
    ="06/07/2012 00:07:00"
    ="06/07/2012 00:09:00"
    ="06/07/2012...
  20. Replies
    1
    Views
    796

    Extract data from open web page

    Dear Gurus,

    I need help from an MSDN Guru :) My question is: Is there a way to point excel to an open webpage and it extracts the required data from the page?

    Detailed explanation:

    My client...
  21. Re: Compare Sample Timings between multiple records

    Bump!

    Guys, can anyone help me with the VBA Code for this?

    Thanks,

    Regards,
    RK.
  22. Re: Compare Sample Timings between multiple records

    Sorry NBVC, this doesn't work forme.

    I am not sure formula approach will work for me. I am looking out to write a VBA code for this feature.

    Any assistance with this code will be of great...
  23. Compare Sample Timings between multiple records

    Dear Gurus,

    I have a complex issue to be solved (complex enough for me at this moment) :)

    I have a list of records with Date and Time, from this we need to scan through the time and pick those...
  24. Replies
    1
    Views
    453

    Conditional Formatting and VBA

    Dear Gurus,

    I need to reference a cell and conditionally format another cell. There are 3 conditions that I need to apply. I have some problem with the syntax, esp, where I need to refer if text...
  25. Re: VBA Macro Code To Copy Multiple Cells & Paste As a Continuous Range

    Thanks for the help. I got it working.

    Regards,
    RK.
Results 1 to 25 of 75
Page 1 of 3 1 2 3
porno