Recent Activities

Costas.xlsx
Hi thanks for the reply. I think I have attached my sheetCostas.xlsx

Post a sample spreadsheet for analysis. Do not post a picture, but upload a sample workbook.

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…

Reached 1 year of membership at OzGrid

Reached 1 year of membership at OzGrid

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.

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…

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))

Hi royUK , I think I got it...see attached. can you check it for me, cheers.

Hi Roy, see attached

Reached 1 year of membership at OzGrid

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))

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

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.

Reached 1 year of membership at OzGrid

Reached 1 year of membership at OzGrid

Reached 1 year of membership at OzGrid

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…

PS. I need it to be dynamic, cheers.