Search:

Type: Posts; User: duthiet; Keyword(s):

Page 1 of 10 1 2 3 4

Search: Search took 0.02 seconds.

  1. Thread: US to UK dates

    by duthiet
    Replies
    3
    Views
    126

    bobski Not sure what you mean by custom? If the...

    bobski
    Not sure what you mean by custom? If the date is entered as text by example 09/26/2014 for September 26, 2014
    Use the funciton datevalue() which will turn the text back to a serial number....
  2. LL: Try using CurrentRegion combined with...

    LL:

    Try using CurrentRegion combined with selecting visible cells only and then paste.
    Something like the below

    'Filter Sheets and copy rows to MKT
    Worksheets(i).Range("B7:L7").AutoFilter...
  3. Replies
    9
    Views
    290

    Dear Yangyang Welcome to the lounge. ...

    Dear Yangyang

    Welcome to the lounge.

    Everyone want to help and I know excel can do this, but the data provided is very difficult to understand. What is "Summarization Record"? These entires...
  4. Replies
    2
    Views
    140

    Could a Pivot Table give the information you...

    Could a Pivot Table give the information you want?

    First highlight all data then on Ribbon create a Pivot table. Drag and Drop "Table" as rows and "Fields" as columns. Then place Fields as value...
  5. Replies
    5
    Views
    256

    Fred: Your post does not mention if anyone...

    Fred:

    Your post does not mention if anyone attempted a simple test. In other words, did anyone create a new Apple Excel Workbook and insert a checkbox control? Then upload to cloud and test on...
  6. Thread: Copy & Paste

    by duthiet
    Replies
    4
    Views
    186

    A problem I have run into is "pasting" where the...

    A problem I have run into is "pasting" where the Crtl C does pick up the data but Excel will not allow the data to be pasted. If this is the issue it may have something to do with Add Ins. However,...
  7. Replies
    6
    Views
    1,194

    Sorting data for futher analysis

    Ed

    Attached is a sample of what I think you are looking for.

    However, it may be better to Pivot Table the Data and use the Pivot Table Filters to extract the desired results. By example use...
  8. Replies
    2
    Views
    380

    Have not seen this specific problem but make sure...

    Have not seen this specific problem but make sure the Workbook is 'compatible' with Exel 2013. This may require that the Workbook be saved using a different extension. Also in Excel 2010 certain...
  9. Replies
    8
    Views
    551

    Your Idea is very good but needs some refinement....

    Your Idea is very good but needs some refinement.

    Since auto-complete needs all of the informaiton to be in one column you may try this:

    At top put in one column all 25 Categoires. Next hide as...
  10. Replies
    8
    Views
    551

    Welcome to the Lounge. Just a suggestion. Skip...

    Welcome to the Lounge.

    Just a suggestion. Skip the Combo Box and Instead Use Auto-complete.
    If possible make each of the 25 items unique, by example:
    Original List
    Machine Repair
    Machine...
  11. Replies
    4
    Views
    482

    Zeddy: You might try...

    Zeddy:

    You might try http://www.mztools.com/v3/download.aspx, I found this on the Web but have never used the tool

    Good Luck

    Tom D
  12. Muddy: Can you be a bit more specific. For...

    Muddy:

    Can you be a bit more specific. For Excel to assist you would need to open the workbook every day so that the workbook would compare the due date and the current date. This could be done...
  13. D: One thing that may help, before running the...

    D:

    One thing that may help, before running the Macro set Excel 2007 Security to the lowest level. Then run your Macro.
    After the Macro is done put the security back to the level your IT Group has...
  14. Replies
    12
    Views
    890

    For learning VBA you might want to check hte...

    For learning VBA you might want to check hte below MS site

    http://msdn.microsoft.com/en-us/library/ee814737%28v=office.14%29.aspx

    Hope this helps.

    TD
  15. Replies
    19
    Views
    1,152

    Try this ...

    Try this

    =IF(AND(B1="all",C1="grp"),6,IF(AND(B1="all",OR(C1="Grp-k",C1="prv")),7,IF(AND(C1="grp",OR(B1="AM",B1="PM")),3,IF(AND(OR(C1="grp-k",C1="Prv"),OR(B1="AM",B1="PM")),3.5,0))))

    Good Luck
  16. Dear TMG9671 If this workbook was created in...

    Dear TMG9671

    If this workbook was created in an older version of Excel make sure you have converted it to an Excel 2010 xlsx or xlsm workbook.

    In addition, make sure the properties on the...
  17. Thread: Offset help

    by duthiet
    Replies
    2
    Views
    307

    Welcome to the Lounge: Your might want to try...

    Welcome to the Lounge:

    Your might want to try INDEX rather than offset. I have attached an example. You will need to change some formulas to pick up the data you want.

    Hope this helps
    ...
  18. Replies
    2
    Views
    452

    You could try going to the actual data that the...

    You could try going to the actual data that the PT is based on and create a new column. Call the new column somehting like ZERO. Put a formula in the new Column that identifies when data is zero and...
  19. Welcome to the Lounge If I understand your...

    Welcome to the Lounge

    If I understand your question the current Macro is working but it is showing the PATH and FILENAME in COL B, Col C, Etc.

    What you want is Col B, Col C, etc just to show...
  20. Replies
    8
    Views
    1,030

    Glenn: Welcome to the Lounge. Since you did...

    Glenn:

    Welcome to the Lounge.

    Since you did not post an example I made a few assumptions.

    I think the whole problem is that any cell with a date is a number. However, Countif likes text for...
  21. Thread: Insert range?

    by duthiet
    Replies
    1
    Views
    503

    Dear NCDoc: Welcome to the lounge. Range...

    Dear NCDoc:

    Welcome to the lounge.

    Range Names in Excel can be limited in scope. In other words, you can make a range name to be global or limited to one sheet.

    In you case I would suggest...
  22. Possible solution. In Column B do a Vlookup to...

    Possible solution.

    In Column B do a Vlookup to match each record to its serial no.

    Used advanced Filter; Select Filter in Place' Select "Unique Records Only"

    The FIlter should hide all...
  23. Replies
    4
    Views
    4,482

    Dear Kweaver: Excel's Dialog Box for Data...

    Dear Kweaver:

    Excel's Dialog Box for Data Validation is very poorly written. the "ignore blank cells" should actually read "Allow Users to enter drop down items or alternatively leave the cell...
  24. Replies
    1
    Views
    415

    Perhaps the following may help. Are the...

    Perhaps the following may help.

    Are the numbers using a font color that is the same as the background (such as white on white)?
    Select Tools - Options - View Tab and see if the desired view...
  25. Replies
    2
    Views
    798

    HowardC: What about using Match to compare the...

    HowardC:

    What about using Match to compare the two lists.

    See the attached.

    By using Auto Filter, Advance Filter, or Sort the lists can be customized or if really necessay you could create...
Results 1 to 25 of 231
Page 1 of 10 1 2 3 4