Replies

I think this is what you are looking for….good luck.

Thanks all…really do appreciate it…both solutions will work fine….I don’t know why I didn’t think about the mtq..after all I use them all the time.

At any rate thanks to all who replied.

Brian,

Thanks, I, just before I read your reply, did just that.

Thanks

Thanks for the quick reply…
I tried your suggestion and it returned an error…
I tried the following and it returned the first Initial, but I still don’t know how to get the second?

Initials: Left([FullName],1)

Again, Thanks

Charolette,

Thanks for your reply.
This is a Peer review audit of medical personnel. Outcomes are used for
performance evaluations, clinic evaluations on any given day that total
performance was down. Is there a particular provider having problems in the
same area-if so figure out why etc.

There will be approximately 20 questions that I will do evaluations on.

Again, this has not been developed as of yet, just looking for a starting point.

Thanks in advance.

Legare,

Thanks for all of your help…it works perfectly, exactly what I needed.

I put a call into MSSUPPORT 2 days ago, they asked for a sample spreadsheet and I haven’t heard from them since. You were able to resolve this for me in a matter of minutes.

I sincerly appreciate it.

Positively Brilliant!!!!!!By reading the description of the function, it is perfect…however, it is still returning N/A. I’m sure it’s me. I put the formula in Summary!C4 will that cause this problem?

Thanks again.

Thanks for the suggestion. I think this is almost what I am looking for. I’m not sure why reference C18 and when I apply the formula it returns N/A. I am not familiar with OFFSET so any help would be appreciated.

Thanks

Thanks for responding. I apolgize if I wasn’t clear.

Summary!C3 is a date field as well as Test1!D5.

Today is 2/28, if I updated this spreadsheet today, both Summary!C3 and Test1!D5 would have the 2/28 date therefore =. Since they equal, Test1!D18 has the data I am after. However, in 2 weeks the date in Summary!C3 will change to 3/14 but Test1!D5 will will still be 2/28. In Test1 I will add a new column, “E5”, and it will have the 3/14 date and will now equal Summary!C3. Therefore E18 now has the data I am after. (the column will always change but the row will not)

Therefore, my “Where” is where Summary!c3=the “DATE COLUMN” in Test1, grab the data from that column(E) but same row(18).

I hope this is more clear.

Again thanks for your help.

I don’t have an answer to your problem, but would sure like to know how you put the smiley faces here.

Thanks