Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    2
    Views
    161

    Re: Art work pricing formula

    Hi,
    If sizes are listed in column A (A2 downward) and the price is listed in column B (B2 downward)
    In cell D2 you can type the size needed.
    Cell E2 would contain the flowing formula

    ...
  2. Replies
    5
    Views
    254

    Re: Clearing Excel AutoFilter using VBA

    Hi,
    You can check the state of the Autofilter and decide what to do



    With ActiveSheet
    If .AutoFilterMode = True And .FilterMode = True Then
    MsgBox "They are visible...
  3. Replies
    1
    Views
    195

    Re: Help with data validation question

    Hi,
    If I have understood correctly, you need "Hide Used items in a drop down list"
    There is a full explanation here along with a downloadable file to play with:-
    ...
  4. Replies
    5
    Views
    140

    Re: How to mix Subtotal & Countif

    Your file has hidden columns (C, D & E) but no hidden rows.
    Therefore you should use the formula posted by sandy666
  5. Replies
    5
    Views
    140

    Re: How to mix Subtotal & Countif

    From the help file:-
    1-11 includes manually-hidden rows, while 101-111 excludes them; filtered-out cells are always excluded.
  6. Re: Using Indirect to keep cell reference from changing

    Hi Try this
    Cell A2 = $A$1:$AB$500

    Change the formula to

    =IFERROR(VLOOKUP($T$1-2,INDIRECT("Job!"&$A$2),3,FALSE),"--")
  7. Thread: Dynamic Shapes

    by Taul
    Replies
    4
    Views
    219

    Re: Dynamic Shapes

    Hi,
    Take a look at Conditional Format (on the Home ribbon)
    Conditional Format - Icon Sets.
    use the 4 or 5 coloured arrow sets
    This provides a green arrow up, red arrow down and a yellow arrow...
  8. Replies
    1
    Views
    124

    Re: Formatting cell size

    I would suggest you do not merge the cells.
    Put the data in the column “A” cell only, then select the cells “A to D” and then:-
    Click on “Wrap Text”
    Format – Format Cells – Alignment – Horizontal...
  9. Re: Working out an individuals age in Years, Months, Days if they were born before 1 Jan 1900

    I haven't looked at the downloadable file for a few years but I managed to find an older workbook where I used the formulas, extract blow.

    A2 = Name
    B2 = DoB
    C2 = Date died

    formula in col D2...
  10. Re: Working out an individuals age in Years, Months, Days if they were born before 1 Jan 1900

    Hi,
    I would suggest looking here, lots of interesting stuff on pre-1900 dates and a workaround in a downloadable workbook as an example
    http://www.exceluser.com/formulas/earlydates.htm
  11. Thread: datedif()

    by Taul
    Replies
    4
    Views
    237

    Re: datedif()

    I think that post was dated 1st April
  12. Re: Working hours between two date/times excluding Lunch and weekends, diff time on Friday

    Hi,
    Just for the sake of completeness and in case anyone else is looking for a similar solution. I have found an alternative approach. So I thought I would share it.

    Basic solution is here...
  13. Re: Working hours between two date/times excluding Lunch and weekends, diff time on Friday

    Hi Oldbrewer,
    Just to explain a little more, I’m trying to create a generic formula to handle working periods of time that would be better than the existing formula that I mentioned in the original...
  14. Re: Working hours between two date/times excluding Lunch and weekends, diff time on Friday

    Thank you Oldbrewer,
    I did not really grasp the full solution you offered, I think my brain must have been worn out as I spent the last few days looking for a work around to the problem. You are...
  15. Re: Working hours between two date/times excluding Lunch and weekends, diff time on Friday

    Hi Oldbrewer,
    Thank you for the reply, it looks like you have spent some time on this one.
    Your formula accounts for different hours on a Friday but it does not account for lunch breaks or...
  16. Working hours between two date/times excluding Lunch and weekends, diff time on Friday

    Hi,
    I need some assistance with calculating working hours between two date/time cells. The working hours are 8:30 to 17:30 and the lunch break is 12:30 to 1:45

    The date/time value could be...
  17. Replies
    16
    Views
    651

    Re: File (7MB) takes 25s to save each time (?)

    Hi
    I suspect there are hidden objects, usually command buttons that are being duplicated. Try this,
    On the Home tab, go to Find and in the drop down list, select “Selection Pane”
    This will list...
  18. Re: Alternative Formula for Nested If/and Function

    Hi,
    Welcome to the forum.
    Am I correct in assuming the outcome “Non-Corp Gold” is defined by the last 11 characters of the text in cell A1. This appears to be true based on the two examples you...
  19. Replies
    5
    Views
    235

    Re: SLA Calulation excluding weekends

    Hi
    Yeah, my bad, the correct format is [h]:mm:ss

    I notice you are using cell references rather than the Named Range that I suggested, presumably Availability!G47 is the cell containing the End...
  20. Replies
    5
    Views
    235

    Re: SLA Calulation excluding weekends

    Hi,
    Firstly I would make a few assumptions as I was a little confused about the meaning of “attended”
    We are comparing date times between Reported Date (Column “A”) and Call Out Response Date...
  21. Replies
    4
    Views
    321

    Re: Help to create the proper schedule planner

    You're welcome.

    If you want to post a sample of the excel file, you can use the HTML Maker shown the the thread below:-...
  22. Replies
    4
    Views
    321

    Re: Help to create the proper schedule planner

    Hi,
    One way is to use conditional formatting.
    select cell D5 and apply conditional format, use the formula


    <tbody>
    =AND(D$4>=$C$5,D$4<=$C$6)

    </tbody>
  23. Replies
    14
    Views
    619

    Re: Table of Contents with Tab Colour

    Hi,
    After doing a little searching I came across an interesting post over at Ozgrid....
  24. Replies
    14
    Views
    619

    Re: Table of Contents with Tab Colour

    Hi,
    Yes, I understand what you are trying to achieve and although we can get the tab back colour and put it into the ToC page via the code, we cannot get the tab font colour.
    The best I can offer,...
  25. Replies
    14
    Views
    619

    Re: Table of Contents with Tab Colour

    Hi, forgot to answer another part of the question, the underline is part of being a hyperlink but you can turn them off


    AnchorCell.Font.Underline = False

    cheers
    Paul
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4