Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Re: Reversing a String of numbers or text with delimiters

    Sorry, my laptop wont let me reply... such is my life today.. I run reports for 12 dealerships. Just switched to excel 2013 from 2007.
    The reason for power query is I can run many different...
  2. Re: Reversing a String of numbers or text with delimiters

    yes this is the result im looking for.
  3. Re: Reversing a String of numbers or text with delimiters

    sorry should also mention that each row has a different amount of changes so wanting the last Price change to align example of saw data below

    10990. 9990
    8990. 7990. 8490. 7490
    12990
  4. Reversing a String of numbers or text with delimiters

    Hi all, new to power Query and I need a solution to the above problem. basically I have a list of prices in 1 cell that are separated by a full stop "."
    E.g. 10990. 10450. 10190. 9990
    And so on...
  5. Replies
    6
    Views
    459

    Re: Macro Buttons change colour when pressed

    Yep that works awesome!, Thanks Mick
  6. Replies
    6
    Views
    459

    Re: Macro Buttons change colour when pressed

    So although the above code works perfectly, is there a way of making it work for sets or groups of buttons?
    eg i have 3 seperate groups of buttons that will have 1 button in each group highlighted...
  7. Replies
    6
    Views
    459

    Re: Macro Buttons change colour when pressed

    Works perfect, THANYOU
  8. Replies
    6
    Views
    459

    Macro Buttons change colour when pressed

    Hi,
    Looking for a solution to my Macro button (shape) problem.
    I have the below code which will colour a depressed button.
    Problem is this will only work for 1 button and i have 12 that i want it...
  9. Re: Another Countifs with multiple criteria and between 2 dates

    Try this one, Columns A,B & C are where you are pulling all your data from. Copy this into B6 and drag accross and down..
    ...
  10. Replies
    2
    Views
    113

    Re: Data sorting using array formula

    Close but not quite, getting multiples at the top which is strange as there are no multiples in the list.
    The returned result below



    <tbody>

    <tbody>
    FPV
  11. Replies
    2
    Views
    113

    Data sorting using array formula

    Hi, i am using the below formula to sort the Data in Column AE. Column AE's data changes everytime i run the report so there maybe between 30 - 50 names in the list obviously the lesser amount of...
  12. Thread: Help

    by Phill032
    Replies
    11
    Views
    353

    Re: Help

    2007, sorry missed that post.
  13. Thread: Help

    by Phill032
    Replies
    11
    Views
    353

    Re: Help

    ok so maybe im just not catching on here.. The code you have attached looks to me like VBA, post 2 i just typed up as normal formulas.
    Can i just past your code? The data i supplied is only a...
  14. Thread: Help

    by Phill032
    Replies
    11
    Views
    353

    Re: Help

    Yep, that is about it.. unsure of your code though?
  15. Thread: Help

    by Phill032
    Replies
    11
    Views
    353

    Re: Help

    Thanks, Almost works perfectly.. only the previous price change amount is not the last amount is is the second last amount.
    So for stock# 1234 the value would be 13,945. other than that it seems...
  16. Thread: Help

    by Phill032
    Replies
    11
    Views
    353

    Help

    Hi All, any help on this would be greatly appreciated.
    The data below refers to a Used car stocklist advertising changes. Each line represents a log of a price change on the internet.
    I need the...
  17. Replies
    3
    Views
    148

    removing duplicates from a list

    Hi guys, there is a quite a few posts about this problem but havn't been able to get them to work how i need them to.. Hoping someone can help.
    I have a vehicle stock list that has all the carlines...
  18. Re: puling a specific price from a list in single cell

    Hey Hey the *0.01 works a treat.
    Thanks, i appreciate your help on this.
  19. Re: puling a specific price from a list in single cell

    For some reason the value i am getting eg 3299900 will not convert to 32999.00. I have tried using curreny and number formats but won't add a separator.
    Any ideas?
  20. Re: puling a specific price from a list in single cell

    your a genius!!

    Works perfectly
  21. Re: puling a specific price from a list in single cell

    Ok so i have added 5 different cells reflected in each line below.
    Might be able to work with an input cell !!
    3599900. 3499900. 3399900. 3499900. 3399900. 3299900. 3199900
    0.1799900. 1699900....
  22. Re: puling a specific price from a list in single cell

    Thanks Dave,

    You are correct in assuming that these are all in one cell, Doesn't seem to work when i drag it down to other cells. Sometime the "." is at the front of the price and sometimes it...
  23. puling a specific price from a list in single cell

    Hi guys,

    Hoping someone can help with the below problem
    I have a used car stocklist with the price changes made on the internet in the below format, each price is seperated by a "."
    What i need...
  24. Replies
    2
    Views
    179

    Re: retrieving the last date in a list

    Perfect!! thanks :cool:
  25. Replies
    2
    Views
    179

    retrieving the last date in a list

    Hi Excel geniuses,

    I have a report that lists multiple vehicles that are advertised on the internet.
    The list comprises of seperate entries for each time a vehicle has had the price changed....
Results 1 to 25 of 38
Page 1 of 2 1 2