Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    2
    Views
    84

    Re: Isnumber search if .......help needed!!

    Too much over-thinking......many thanks!!
  2. Replies
    2
    Views
    84

    Isnumber search if

    OK so I have a formula that returns a true or false value for a certaintext string....

    IF(ISNUMBER(SEARCH("EPN",B40)),"EPN","")

    So if EPN is in B40 then EPN is shown in the cell where the...
  3. Thread: Cell Colour

    by Simont485
    Replies
    5
    Views
    186

    Re: Cell Colour

    Option 2 is perfect for what I'm trying to achieve!!

    Many thanks
  4. Thread: Cell Colour

    by Simont485
    Replies
    5
    Views
    186

    Re: Cell Colour

    Yes its a manual change so nothing else happens at the same time......
  5. Thread: Cell Colour

    by Simont485
    Replies
    5
    Views
    186

    Cell Colour

    I have found VBA code from another thread that returns a value for a cell colour. But it will only update when F9 is pressed for a cell colour change

    In B1 =GetColor(A1) when colour in A1 changes...
  6. Replies
    9
    Views
    328

    Re: Excel Staff Rota

    Yes my mistake....spotted the <>N/A easy enough but missed the 'Left(Index......'had lost the left!!

    Works perfectly!
  7. Replies
    9
    Views
    328

    Re: Excel Staff Rota

    Ok...so made the change to <>"NA" as shown but it now ignores all text......I just need to ignore everything but NA......
  8. Replies
    9
    Views
    328

    Re: Excel Staff Rota

    In cells B8:E12 where NA is used I need to ignore all other text.

    So if a cell in that rage contained 'swap' or 'name' it would be treated as a blank.....
  9. Replies
    9
    Views
    328

    Re: Excel Staff Rota

    ERM...... thank you I am speechless!

    That is truly amazing! Woks perfectly straight out of the tin!

    Cannot thank you enough! I was confused just trying to explain it in English lol!!

    Again...
  10. Replies
    9
    Views
    328

    Re: Excel Staff Rota

    <tbody>

    A

    B

    C

    D
  11. Replies
    9
    Views
    328

    Excel Staff Rota

    I have a staff rota and want to input a date to show staff who are available to be called for cover.

    I have tried Index Match and Vlookup but my Excel experience falls short.

    I have an example...
  12. Thread: Index Match

    by Simont485
    Replies
    13
    Views
    484

    Re: Index Match

    Ok so that now works..........??? Honestly it didn't earlier.Many many apologies and thanks

    So if B3 was also Blank how would I get to see Person 3 in D2.......an so on for a longer list?
  13. Thread: Index Match

    by Simont485
    Replies
    13
    Views
    484

    Re: Index Match

    Nope....When C1 is blank I want D1 to return Person 1....... because B1 is blank.
  14. Thread: Index Match

    by Simont485
    Replies
    13
    Views
    484

    Re: Index Match

    <tbody>
    A

    B



    Person 1
  15. Thread: Index Match

    by Simont485
    Replies
    13
    Views
    484

    Re: Index Match

    Sorryms-understod what you meant....my lookup range has text only......
  16. Thread: Index Match

    by Simont485
    Replies
    13
    Views
    484

    Re: Index Match

    Yes......Column A range is staff names and column B range is activity.....

    staff assigned an activity have a letter in column B and non assigned staff are blank. I need to see the staff names who...
  17. Thread: Index Match

    by Simont485
    Replies
    13
    Views
    484

    Re: Index Match

    Thank you but I just get #value!.....
  18. Thread: Index Match

    by Simont485
    Replies
    13
    Views
    484

    Index Match

    Hi all

    So I have an issue with index match.

    Column A is my index (A3:10) and Column B (B3:B10) is my match to C1 and result is in C2

    Column B contains blank cells.

    When C1 is blank I...
  19. Replies
    1
    Views
    156

    Data Link Issue

    HI all

    I have setup vba code to get comments from another workbook. It works fine until I close down all workbooks and reopen.

    Then then link has changed from

    =GetComments('[EPN - SPN -...
  20. Replies
    0
    Views
    221

    Linking vs Connection

    Hi all

    Just a bit of a general info required really.

    At work I have read only access to 2 work books. Both of these are staff rotas. There are a myirad of shifts, shift lengths, shift times etc...
  21. Replies
    9
    Views
    51,817

    Re: Excel VBA Get Comment from Cell

    Hi there...I have been using various get comments vba codes but i have this problem with all of them.

    When they are first loaded they work perfectely and I can conditiona format the cells to suit...
  22. Replies
    10
    Views
    563

    Re: Excel Scroll to dated column

    So I have introduced this at work and have had a suggestion that may be useful......

    If possible ......when cell A1 is blank it goes to todays date?
  23. Replies
    10
    Views
    563

    Re: Excel Scroll to dated column

    That's great many thanks!!
  24. Replies
    10
    Views
    563

    Re: Excel Scroll to dated column

    Is it possible to adapt this so that if cell A1 is blank the rota defaults back to D4, which is 1/04/2018 on the rota?
  25. Replies
    10
    Views
    563

    Re: Excel Scroll to dated column

    Yes sorry my mistake!

    Woks perfectly! Many Thanks!
Results 1 to 25 of 47
Page 1 of 2 1 2