Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Show different worksheets with Camera Tool but the ability to edit data shown?

    Using this YouTube video as a guide https://www.youtube.com/watch?v=lCsvSdk4Tro I have created a Dashboard of sorts which has a Dropdown box and this shows data from numerous sources.

    The sources...
  2. Re: Minus two values but enter text if one cell is blank

    Managed to suss it!

    =IFERROR(DATEDIF(IF(B2=0," ",B2),D2,"y")&" years, "&DATEDIF(B2,D2,"ym")&" months, "&DATEDIF(B2,D2,"md")&" days","Never Sold")

    :)
  3. Re: Minus two values but enter text if one cell is blank

    Thank you LlebKcir, I tried the modification to Attempt 02 but it then ignored 'Never Sold' and just put in the date I put in 'Date_You_Started_Tracking and ignored 'Never Sold'

    From what I can...
  4. Re: Minus two values but enter text if one cell is blank

    Apologies if this is getting a little confusing, but ultimately this is how they all work so far:

    Attempt 01
    States 'Never Sold' if H2 is blank - If not blank, it J2-H2 as numeric...
  5. Re: Minus two values but enter text if one cell is blank

    I'm getting into a bit of tizz with this aren't I, kinda losing track lol

    But basically, if H2 is blank then it needs to state 'Never Sold'

    But if there is a value then it does J2-H2 and then...
  6. Re: Minus two values but enter text if one cell is blank

    =IF(H3="","Never Sold",IF(H3>0,J3-H3,"Never Sold"&DATEDIF(H3,J3,"y")&" years, "&DATEDIF(H3,J3,"ym")&" months, "&DATEDIF(H3,J3,"md")&" days"))


    I applied it like the above, but now it is ignoring...
  7. Re: Minus two values but enter text if one cell is blank

    Thank you :)

    I thought the comma was used at the beginning of a new IF statement so thank you for clarifying.

    I have implemented the formula as

    =IF(H2>0,J2-H2,"Never...
  8. Re: Minus two values but enter text if one cell is blank

    Apologies, here is my post with that (hopefully rectified)

    I have been trying to do this and also understand the fundamentals of Nesting IF formulas and I feel I have cracked it, but for some...
  9. Re: Minus two values but enter text if one cell is blank

    Cheers mate :)

    I have been trying to do this and also understand the fundamentals of Nesting IF formulas and I feel I have cracked it, but for some reason the formula states "too many arguments"....
  10. Pivot Table - Sorting the whole table based on additional V-Look Up Data

    Basically I have a Pivot Table and got a few V LookUps in subsequent columns.

    Now I want to sort the whole Pivot Table based on the extra Column which contains V-LookUp Data but it's all greyed...
  11. Re: Minus two values but enter text if one cell is blank

    Thank you ever so much for this!

    In another column I also had the following formula =DATEDIF(0,K2,"y")&" years " &DATEDIF(0,K2,"ym")&" months "&DATEDIF(0,K2,"md")&" days"
    This translated the...
  12. Minus two values but enter text if one cell is blank

    Been wracking my brains with this one and I suspect there is an easy solution but I cannot figure it out.

    I'm trying to work out the number of days since a particular item has sold but in some...
  13. Replies
    4
    Views
    136

    Re: Lookup values and out horizontally

    Superb Fluff, thank you
  14. Replies
    4
    Views
    136

    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 -...
  15. 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...
  16. 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=""...
  17. 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.
    ...
  18. 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,...
  19. 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...
  20. 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)
  21. 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?
  22. 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 :)
  23. 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
  24. 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...
  25. 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...
Results 1 to 25 of 33
Page 1 of 2 1 2