Recent Activities

  • Eusebious

    Replied to the thread growing range.
    Post
    Costas.xlsx
    Hi thanks for the reply. I think I have attached my sheetCostas.xlsx
  • alansidman

    Replied to the thread growing range.
    Post
    Post a sample spreadsheet for analysis. Do not post a picture, but upload a sample workbook.
  • Eusebious

    Posted the thread growing range.
    Thread
    Hi
    I am trying to build a sheet in excel 2010 to list my visits to a certain brand of coffee shop including location,date, what we had and how much we spent. I have managed most of it, but the problem is with the cell counting the number of unique shops I…
  • titulaees

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • matyldk

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • royUK

    Replied to the thread Countifs date formula.
    Post
    Here's an example using your data converted to a Table. Now if you add or remove data to the Table the formulas will adjust.
  • royUK

    Replied to the thread Countifs date formula.
    Post
    That's fine.

    I've made it more dynamic by adding a drop down list to choose the area in H2. I've changed the formula to point to this cell so when you select a different area it will change the results.

    The only problem you will have is if you add data…
  • cobber1418

    Like (Post)
    Attach an example of your workbook

    You may also try:

    This month

    =COUNTIFS(A1:A100,"PW",B1:B100,">"&EOMONTH(TODAY(),-1))

    This should ignore this month

    =COUNTIFS(A1:A100,"PW",B1:B100,"<="&EOMONTH(TODAY(),-1))
  • cobber1418

    Replied to the thread Countifs date formula.
    Post
    Hi royUK , I think I got it...see attached. can you check it for me, cheers.
  • cobber1418

    Replied to the thread Countifs date formula.
    Post
    Hi Roy, see attached
  • bodycorporate

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • royUK

    Replied to the thread Countifs date formula.
    Post
    Attach an example of your workbook

    You may also try:

    This month

    =COUNTIFS(A1:A100,"PW",B1:B100,">"&EOMONTH(TODAY(),-1))

    This should ignore this month

    =COUNTIFS(A1:A100,"PW",B1:B100,"<="&EOMONTH(TODAY(),-1))
  • shanezer

    Post
    ok thats grand thanks so much for replying I will try something else
  • royUK

    Post
    I doubt very much that you will be able to do what you want.

    It's also a security issue as well, anyone can press a button if they have access to your computer.
  • woodross237

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • ronakcircuits

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • MarkScorze

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • leonharry211

    Has received the trophy Yearling.
    Trophy
    Reached 1 year of membership at OzGrid
  • Roy
    Yes when i save the active workbook it saves the figure that i entered , what i want to do is when i open a new workbook the following day I want to retrieve the figure from the workbook of day before. for example on monday 2nd I created a file called…
  • cobber1418

    Replied to the thread Countifs date formula.
    Post
    PS. I need it to be dynamic, cheers.