Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.31 seconds.

  1. Replies
    1
    Views
    34

    Re: Complex Conditional Formatting

    one way, assuming A and B cols above. In C2
    =TRIM(A2&B2), drag down then conditional format C for duplicates, you could then eliminate any known duplicates. Then sort by supplier part number. I'm...
  2. Re: prevent table columns incrementing in formulas when you drag and fill a range

    normally it wsould be restrained with a dollar sign $ not sure how that works with tables
  3. Re: How to find degree value between two numbers

    if it is a different question, then start a new thread
  4. Replies
    5
    Views
    121

    Re: Delaying production

    my only though would be to have a delay sheet built so changes there are then part of the model calculation always referenced. I don't understand the problem enough to say more
  5. Re: How to find degree value between two numbers

    If I understand you, 1 full rotation is 360 degrees and you are looking at that in 9ths so 360 divided by 9 = 40 (i.e 9x40=360)

    so 4 x 40 = 160 degrees

    so the calculation is =(360/9)*4 = 160
  6. Re: Setting Command Button Properties When Workbook Opens

    you can add a button to a cell, then adjust your cells for size. Good if it dosen't muck up any other layout
  7. Replies
    18
    Views
    227

    Re: Shift name based on timestamp

    just a matter of getting the right info from the right places :) The updated version should fit with your data
  8. Replies
    18
    Views
    227

    Re: Shift name based on timestamp

    using your stated locations >
    <b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt;...
  9. Replies
    18
    Views
    227

    Re: Shift name based on timestamp

    i was thinking more on the INDEX / MATCH formula but using this formula (adjusted to remove the date) > =A2-INT(A2) The date portion is a whole number so this just leaves the time value

    Like...
  10. Replies
    18
    Views
    227

    Re: Shift name based on timestamp

    just a thought but i think the date needs to be dropped i the formula otherwise they will never work :)
  11. Replies
    18
    Views
    227

    Re: Shift name based on timestamp

    are the columns used the same as the formula above from Aryatect https://www.mrexcel.com/forum/images/statusicon/user-offline.png
  12. Re: IFERROR + VLOOKUP + ??? - Returning a value only for a given selection.

    what does your formula look like ?
  13. Replies
    18
    Views
    227

    Re: Shift name based on timestamp

    if you in another cell use = ISNUMBER(your cell date time value) and it returns as true then it is time, false will say it is text
  14. Replies
    18
    Views
    227

    Re: Shift name based on timestamp

    are you using actual time values? or text that looks like time?
  15. Replies
    18
    Views
    227

    Re: Shift name based on timestamp

    are there any other overlays that need to be considered, otherwise its a case of extracting the right hand time value and comparing to less than 1
  16. Replies
    1
    Views
    44

    Re: Infinite OLAP Refresh Loop

    What code in the workbook relates to it?
  17. Re: Making a letter point to a specific cell or equation?

    The ZERO in MATCH should set for exact only

    a little concerned about B$3:B$6 as that indicates to me only three rows are referenced

    you might wrap with IFERROR(... formula ... ,"")
  18. Replies
    1
    Views
    64

    Re: text format issue

    left and right alignment is the default to show whether text or number in the cell, you can format the column to align left or right, or convert your text numbers to numbers
  19. Replies
    11
    Views
    571

    Re: Create Printer Error for testing purposes

    can you force it to print direct rather than spool the job ?
  20. Re: Insert IFERROR( and ,"-") at the begining and end of formulas?

    If you select your formulas and run Marks code then you don't need to do anything else
  21. Re: How can I insert IFERROR( and ,"-") at the begining and end of formulas?

    something like ASAP utilities, if when you do it, you also add ' (i.e. =becomes '=IFERROR( as the first character then it will look like text until you have finished changing, then remove the leading...
  22. Replies
    3
    Views
    65

    Re: hyper links to Chrome from Cell

    Thanks, I might have to if I can't get the hyperlink to resolve,
  23. Replies
    3
    Views
    65

    hyper links to Chrome from Cell

    I have been using =HYPERLINK("http://gridreferencefinder.com/","GRF" ) for a while

    work has suddenly started to use from the desktop

    "C:\Program Files...
  24. Replies
    1
    Views
    92

    Re: How to get data from Excel online

    can you try accessing from another machine to replicate no access
  25. Replies
    11
    Views
    571

    Re: Create Printer Error for testing purposes

    physically turn it off, unplug the LAN, remove a colour cartridge, remove paper or add really thick paper to force a jam any of those should give you numerous errors
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4