Thanks again Hui, but I get the same results regardless of what variation of the formula I use. Like I said the original formula works great for sheet1
but for sheet2 the formula(s) only pick up 9 of 20 records for Jan 2011.
And for the purpose of clarification I think the formula for...
Hui,
I will try to work with the formulas you suggest, but regarding your reply... Sheet3 contains something similar to this. In my example C1 was Jan-11. My formula only returns 9 records when there are actually 20 records for Jan 2011. What is so frustrating is the same formula is working...
I have a problem that I have been puzzling over for a week or so.
The goal is to create a chart to compare data from 2 sheets.
Each sheet in column A contains sequential dates. The 1st sheet has 2010 dates in 01/01/2010 format thru 12/31/2010. The sheet for 2011 has dates up to 05/12/2011...
Dynamic Named Range is great for what you are attempting... You can also achieve the automatic expansion of a range by converting to a table in some cases.
OK I tried all of the recommendations and they all provided the desired outcome.
I guess the moral of the story is that match works better than counta in this particular case.
I really appreciate the help on this.
Good Morning,
Thanks to all that replied, I will try all recommended solutions this afternoon and provide feedback. As always, this is the best source for excel information and help.
dan_I,
I think I get what you mean by blow up, the formula kept locking my computer up when I tried to work the range in a function.
Anyone else have a recommendation?
I have used the following dynamic named range formula for quite some time to accomplish a dynamic range.
The only problem I have is I can't leave an empty cell between occupied cells. If I do the range is not accurate.
Does anyone have any recommendations apart from converting to a table...
Hui:
Thanks for the reply. Let me clarify my question.
The age I will be working with will always be greater than the real age.
In the example above the age 52(rated age) is approximately 4 yrs above the real age.. how can I get the formula to return how old my rated age will be in the...
A co-worker and I have been working on this problem for a while and only achieved marginal success. Here' the issue. The sheet requires the user to provide the Date of Birth or (DOB), to arrive at what their age will be at MMI( a date in the future.
Here's the twist. There is a term called...
Key Master Indeed!!
That is exactly what I needed. I was actually trying SUMPRODUCT as part of the solution but could not get the total result. The Match and < were the missing pieces..
How was that you were able to put that together? I will study the components of the formula to...
Ninja:
Thanks for the reply, and for explaining the solution.. I didn't understand what you meant initially.... I will work with it and see if this works. I am not sure how to post a file in this forum, but can post it to my Windows Live Sky Drive but I will try your solution 1st..Thanks again!!
Thanks for the reply Excel Ninja however I am not able to find my solution in the link provided. Duplicates are not a problem. below is the list that is populating in column B via Data Validation
Bills
Case Management (Field)
Consultations
Dental
Medical Management
PTR
UR -...
I have a spreadsheet that returns the number of times a nurse(s) performs a particular activity. There are about 5 nurses. The activities as well as the nurse’s name are listed on a sheet called list. named ranges; RN and activities are used.
I use data validation to populate a separate sheet...