We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
My Super Personal Accounts Spreadsheet
Options
Comments
-
Hm, can't work out how.
Tab 1 has the following
Dept Date Received More along here...
Department is a number, date received is a date.
Tab 2
Dept Mar10 Apr10 May10 Date last received
100 -- 1
0
5
And this is the cell I must fill!
115 -- 0
1
2
The numbers under the month headers are just counting the number of occurences on the previous page where the department number and month/year are the same.
So, how would your suggestion work?Target Cash Net Worth: £25K by January 2012
Progress May-08 19.0%; May-09 40.0%; May-10 63.0%; May-11 58.4%; Jun-11 58.5%; Jul-11 58.9%; Aug-11 58.7%; Sep-11 59.0%
0 -
matt_n_mich wrote: »You should be able to use IF for the department and MAX for the date...
sites . google . com /site/miscfileaccess/DateProblem.xlsx0 -
LucyTheDwarf wrote: »Hm, can't work out how.
Tab 1 has the following
Dept Date Received More along here...
Department is a number, date received is a date.
Tab 2
Dept Mar10 Apr10 May10 Date last received
100 -- 1
0
5
And this is the cell I must fill!
115 -- 0
1
2
The numbers under the month headers are just counting the number of occurences on the previous page where the department number and month/year are the same.
So, how would your suggestion work?
Oh IC... You could still do what i did in the one I linked to but ref the formula to take its data from tab 10 -
Does that work?0
-
Hm, it doesn't seem to work. On your spreadsheet, if you change the department to B, it doesn't work out the last date.Target Cash Net Worth: £25K by January 2012
Progress May-08 19.0%; May-09 40.0%; May-10 63.0%; May-11 58.4%; Jun-11 58.5%; Jul-11 58.9%; Aug-11 58.7%; Sep-11 59.0%
0 -
Strange ok give me a few mins sorry0
-
Strangely if you type in the formula each time it does work on an induvidual basis.... so would work in your scenareo (if there is not too many?) but then the dept changes it fails... strange0
-
There are currently 33, but it will expand to 250 ish in a few months time, so I can't type them all individually.
Thanks for looking though
Target Cash Net Worth: £25K by January 2012
Progress May-08 19.0%; May-09 40.0%; May-10 63.0%; May-11 58.4%; Jun-11 58.5%; Jul-11 58.9%; Aug-11 58.7%; Sep-11 59.0%
0 -
I'll PM if i get it... I like problems... good one!0
-
I like problems too, but I think my employer will get a bit annoyed if I spend too long on this one. It's not an essential field, it's one I want
Target Cash Net Worth: £25K by January 2012
Progress May-08 19.0%; May-09 40.0%; May-10 63.0%; May-11 58.4%; Jun-11 58.5%; Jul-11 58.9%; Aug-11 58.7%; Sep-11 59.0%
0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 351.2K Banking & Borrowing
- 253.2K Reduce Debt & Boost Income
- 453.7K Spending & Discounts
- 244.2K Work, Benefits & Business
- 599.3K Mortgages, Homes & Bills
- 177K Life & Family
- 257.7K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.6K Read-Only Boards