Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    4
    Views
    107

    Re: Lookup values and out horizontally

    Superb Fluff, thank you
  2. Replies
    4
    Views
    107

    Lookup values and out horizontally

    I've done Array formula's before and got them working, but for whatever reason, it's not working on my current information.
    Currently I've two sheets:

    Master Sheet - 'Sheet1M'
    2nd Sheet -...
  3. Re: Time Stamp with initials from dropdown box value

    Thank you John :)

    I am still struggling a bit tbh...where you say M2 is the Dropdown, Cell...is that the cell where the value from the dropdown box would go or the name of the Drop Down Box?
    I...
  4. Time Stamp with initials from dropdown box value

    Currently I have an Excel file which enters a time stamp depending on if a value is entered in Column A. So it looks like this


    <tbody>
    Column A
    Column B
    Column C


    Data<where value=""...
  5. Re: Error when posting - Number of tags exceeded maximum amount

    My issue concerned the number of tags you can add when creating a new thread. Underneath the emoticons is an area called 'Tags' - Separate tags using a comma. You may add 5 tag(s) to this thread.
    ...
  6. Re: Error when posting - Number of tags exceeded maximum amount

    To be honest, I did figure out the issue - or at least I think I did. Basically the tags it refers to are the ones you add followed by a comma. I did at least 5 of them (i.e. Excel, Date, Formula,...
  7. Re: Lowest and Highest Date based on value in another column

    Thank you Fluff :)

    It's superb in that it now puts it into a seperate column but the output when there's more than one manufacturer is as follows:


    <tbody>
    PARTNO2
    Hyundai Accent. Subaru...
  8. Re: Lowest and Highest Date based on value in another column

    Thank you for the quick reply :)

    Basically like this:


    <tbody>
    (Column A)
    (Column B)
    (Column C)
  9. Re: Lowest and Highest Date based on value in another column

    Actually, just one little question if possible...how would I put the actual dates in a seperate (third) column?
  10. Re: Lowest and Highest Date based on value in another column

    Absolute legend! This works superbly, thank you. Will try and dechiper the code to get a better understanding of it :)
  11. Lowest and Highest Date based on value in another column

    I'm revisiting my file and wondered if it's possible to tweak and to apply a minimum and maximum date. Basically, this is my data



    <tbody>
    PARTNO1
    Hyundai
    Accent
    01/01/94
    31/12/99
  12. Error when posting - Number of tags exceeded maximum amount

    Hi All

    Trying to post a question and I have included two tables, but for some reason I get the error message "The number of tags you tried to add exceeded the maximum number of tags by 1"

    Is...
  13. Re: Concatenate based on values in another column

    Apologies for the cross posting - certainly won't be doing that again especially with how helpful this place is :)

    I'm revisiting my file and wondered if it's possible to tweak and to apply a...
  14. Re: Concatenate based on values in another column

    :) :) Nice one sir!
  15. Re: Concatenate based on values in another column

    Armed with applying the Macro I've ran into a peculiar issue. Basically with all the data I'm using, I need to get rid of Duplications in Column A and Column C.
    I then need to get rid of extra...
  16. Re: Concatenate based on values in another column

    EDIT: Nice one!!! I've been looking through the various coding updates you've sent to try and get a grasp of this, but what can I say...absolutely unbelievable mate and I really value your help. What...
  17. Re: Concatenate based on values in another column

    To remove the comma's in between each model I've amended the line in the last bit to

    .Offset(, 1).Value = .Offset(, 1).Value & ", " & K & " " & Dic(Ky)(K)
  18. Re: Concatenate based on values in another column

    This is absolutely amazing!

    Whereby it seperates unique makes and it's respective model. At the moment it will state Hyundai Accent, Subaru, Impreza, Toyota, Celica

    But could it state
    ...
  19. Re: Concatenate based on values in another column

    STOP THE PRESS!!!!
    I've put a header in and now it works! Absolutely brilliant!


    <colgroup><col><col span="2"></colgroup><tbody>
    PARTNO1
    Hyundai
    Accent, i30, i40
  20. Re: Concatenate based on values in another column

    That's really good of you to take the time to post that - thank you!

    It's kinda working but it extracts it as the following:


    <colgroup><col width="80" span="3" style="width:48pt">...
  21. Concatenate based on values in another column

    Hi all, first time post so I hope I'm following the correct procedure :)

    Was really hoping someone could give me guidance. Basically I have a file as per the information below and I need to merge...
Results 1 to 21 of 21