|
Beresford SD | Simple, self functioning. Yeah, right.
What you have described causes me to conclude the data is arranged in rows, each record occupies a row across more than one column. One of the columns better include the date, if there is no date stop reading here. XX
In a blank column to the right of the data set place a MONTH function to generate a month number for each record.
In the next blank column to the right of the month # column, place an IF function set up to test the number in the month # column. IF(cell=1, cell with number of days, 0) would test the cell in the month # column for "1" which would be January, and return the contents of the cell in the record with the number of days in it if the January number matches, or zero if the month is other than January.
Then use 11 more columns to the right of the January (1) column to carry out that same operation for each of the other 11 months.
These 13 columns are self functioning, the cells in each column self calculate as the date is entered. The month # column will always have a number from 1 to 12 in it if the date is entered properly, the cells in the other columns will contain zeros unless the month # matches. Except you do not want zero in those cells as that would foul up the DMIN calculation, so leave out the zero in the IF function so the cells stay blank. Troubleshooting may go better if you leave the zero (or some character) in place until you know the function is working, blank cells can be annoying when things don't work.
NOW you can put 12 DMIN functions somewhere on the sheet, such as at the top of each month column, to find the number you want.
To my way of thinking this does not qualify as simple, but it may trigger some thought from someone who could condense the effort so as to produce the result you think you want.
| |
|
Database function in Excel
