Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    3
    Views
    183

    Re: Consecutive index match results??

    This seems to work perfectly, am i right in thinking that the B1 (or AX4 as the case is) needs to change as the formula is dragged down? to AX4, AX5,AX6 etc?

    Thank you by the way
  2. Replies
    3
    Views
    183

    Consecutive index match results??

    Hi,

    Does anyone know what I which additional formulas I would need to add/do to get this index match formula create a consecutive list of new matches as I drag the formula down to the next cells...
  3. Re: Macro running on Shared workbook (Sharepoint)

    Hi Sykes, Yes i've sorted that side of it too :) The one thing I'm concerned about mostly is, it kicking other people out and discarding changes. We had an issue on the current workbook where a...
  4. Macro running on Shared workbook (Sharepoint)

    Hi everyone,

    Has anyone had any experience of running macros on a shared workbook? I know that array formulas cause shared issues if they are not locked down and protected before sharing it but...
  5. Replies
    3
    Views
    223

    Re: Index match & countif

    Yes, I meant horizontally haha! I've not had my morning coffee yet :laugh: This works perfect Eric, thank you. I've been sat for an hour using all variations like this and came up with a grand total...
  6. Replies
    3
    Views
    223

    Index match & countif

    Hi,

    Do you know how I would combine INDEX MATCH with COUNTIF


    I need to find a match for D5 in range I4:I86, once that match is found, I need it to then COUNTIF on that exact row vertically...
  7. Symbol for "DOES NOT CONTAIN" in a formula

    Hi everyone,

    I am using the formula below on conditional formatting which looks up the staff name (R5), Matches it with the data in BD5:BD150 and if the adjacent cell (BE5:BE150) does not contain...
  8. Re: Index match & only index/return certain text

    Yes! Brilliant :) Thanks Steve
  9. Index match & only index/return certain text

    Hi guys,

    So I've created this formula below and its looking up a name for a match then returning the data from the cell next to it which is a rota'd work day so W or H or whatever else has been...
  10. Replies
    14
    Views
    405

    Re: INDEX/MATCH Query - Amendment needed

    Its now working, helped that I could look how you worked it out.

    Thank you very much Fluff :)
  11. Replies
    14
    Views
    405

    Re: INDEX/MATCH Query - Amendment needed

    Yes pretty much, I'm probably just being a numpty, what data should A1 refer to at the end of the formula?
  12. Replies
    14
    Views
    405

    Re: INDEX/MATCH Query - Amendment needed

    Its not working :(
    Would an IF formula work?, =IF the cell above contains this result then move on to the next H??
  13. Replies
    14
    Views
    405

    Re: INDEX/MATCH Query - Amendment needed

    Thanks very much Fluff, The H is stored in H3
  14. Replies
    14
    Views
    405

    Re: INDEX/MATCH Query - Amendment needed

    Hi Fluff, It was coming up with a NUM error, could you explain what the additional formulas are actually doing to my data? (Yes I am an amateur) :)
  15. Replies
    14
    Views
    405

    Re: INDEX/MATCH Query - Amendment needed

    Hi,

    I've probably not explained properly, the data I have is as follows

    01/10/19 W
    02/10/19 H
    03/10/19 W
    04/10/19 H

    I have the same INDEX/MATCH formula in 38 vertical cells looking in...
  16. Replies
    14
    Views
    405

    INDEX/MATCH Query - Amendment needed

    Hi all,

    I have this formula below which INDEXs a list for every date of the year vertically G4:G369, I then created a match for the column next to the date so if the cell has a H, it returns the...
  17. Replies
    5
    Views
    129

    Re: Formula Question

    Thanks for the reply Gerald, I've tested it but it returns ..
  18. Replies
    5
    Views
    129

    Re: Formula Question

    Hi,

    No, I have one sheet which staff input to, this has vehicle registrations against route numbers which are input daily. I have another sheet on the same workbook which is locked down and it...
  19. Replies
    5
    Views
    129

    Formula Question

    Hi Guys,

    Could someone explain how I would merge these two formulas below so that it looks in one range and returns ROUTE, then looks in another and returns COLLECTIONS, I'm slowly getting my head...
  20. Replies
    4
    Views
    281

    Re: Match Last 6 digits of Cell

    Yes, this works a dream, thank you :)
  21. Replies
    4
    Views
    281

    Match Last 6 digits of Cell

    Hi,

    Was wondering if anyone could show me how to get this formula below to: only match the last 6 digits of the cell BA5, rather than an exact match, Is this possible using this formula below or...
  22. Replies
    17
    Views
    459

    Re: If False then (another formula)

    Guys, It was me being a dim wit, It works perfectly.

    Thank you so much :)
  23. Replies
    17
    Views
    459

    Re: If False then (another formula)

    Hi Mike,

    Basically the Monday tab is a plan with employee names on, if their name is in Monday!G6:I25 then I want it to return W (working), If they are not working they will be in the...
  24. Replies
    17
    Views
    459

    Re: If False then (another formula)

    They do yes, its driving me insane ha ha!
  25. Replies
    17
    Views
    459

    Re: If False then (another formula)

    It doesn't give anything Gaz, Just a blank cell.
Results 1 to 25 of 42
Page 1 of 2 1 2