Search results

This works! Is there a way to use this same code with a protected sheet which is also part of a shared workbook?

Please see the attached example. I appreciate the help!

Luke, thanks for this. Unfortunately, it did not work. I received a Run-time error '9': subscript out of range.

I have a log which several of my staff enter information into daily. They generally work Monday through Friday; however, sometimes work weekends. Therefore, I need the log to be inclusive of all dates from log's origin forward (9/21/12-current). I am struggling to create a VBA code which would...

Faseeh, I used named ranges and the formula you provided, made a small modification and this worked: =IFERROR(INDEX(NPI_Providers,SMALL(IF(A$1=ClinicList_Providers,ROW(ClinicList_Providers)),ROW(A1))-3,0),"") Thank you!!

Hi Faseeh, This came very close. In my live database, I have 46 clinics. Clinic1 was skipped, Clinic2 returned 4/7 entries, Clinic3 was blank (accurately), and Clinic4 returned 3/4. I used ctrl+shift+enter and dragged as you described. Any thoughts on why this did not work?

I am trying to extract multiple dynamic lists from a range matching certain criteria. I need to extract from the "Providers" sheet unique, dynamic lists without blanks to "Clinic" sheet by matching Row 1 on "Clinic" to column E on "Providers" Here is an example...

Hi Narayan, The data could have more than 2 providers with the same number of visits. In this case, I would want it to choose the most recent visit. Thank you!

Faseeh, In your example where there are two supplies with the same number of occurrences, I would want it to choose the most recent (3/25/13: TESTAEHR, JACK). Sajan, Thanks for the reply. I have entered the formula, using Ctrl + Shift + Enter, without success. The column returns blank.

Hi Faseeh, If there are multiple providers, I want it to choose the provider with the most visits/occurrences, then the most recent visit date. Ex. Rows 15-18: Patient #34567 had one visit to TEST, SAM and three visits to TEST, ZACHARY. The most recent of the four visits was to TEST, SAM on...

I am trying to find a provider for a patient using the following conditions: -if seen by multiple providers, choose the one with the most visits, then choose most recent visit -if equal number of visits by providers, then choose most recent This is the last formula I have started to work...

I am tracking census information in horizontal dynamic ranges on an Input! sheet. The information is being compared among two organizations. Changing the layout is not prudent in this case. The date is in row Input!3:3 and the values are in row Input!5:5 for organization 1 and Input!32:32 for...

Luke, To answer your previous question, yes Excel is highlighting the correct selection. Please review the hotfile Hui requested. I remain close, but no cigar!

I apologize for the delay, was on vacation! http://hotfile.com/dl/135219515/a7b8672/Daily_Census_Shared_Sample.xlsx.html I have another question as I proceed further into this assignment. I would like to automate the sheet 'YTD COMP FY11'. Is there a way to automate the summation of months...

Luke, Unfortunately, I have not found any extra text anywhere. It is returning an invalid formula error when I use the formula you have provided to accomodate for gaps: =OFFSET(Input!$A$3,0,MATCH(Graphs!$L$2,Input!$3:$3,0)-1,1,MATCH(Graphs!$L$2,Input!$3:$3)-MATCH(Graphs!$O$2,Input!$3:$3))...

That included the end point in the drop-down list; however, the data is still shifted 1 date beyond the date it should match up with.

The dates on the Input! sheet are 1 day apart. The dates in the drop-downs are limited to the dates given in the Input! sheet. The graph is displaying the data range 1 day behind. For example, I choose an end date of 11/3/2011, and the graph will shift my range forward one day. Instead of...

I did forget to mention that the start date and end date cells are meant to be drop-down lists. Thank you!

Luke, Unfortunately, this is not quite the answer either. Can I send you the abbreviated document for you to advise?

Hui, Thank you for the quick response and welcome! Unfortunately, I have either entered this incorrectly or I am still missing something. Can I send you the abbreviated document for you to advise?

1. I am tracking census information in horizontal dynamic ranges on an Input! sheet. The information is being compared among two organizations. Changing the layout is not prudent in this case. The date is in row Input!3:3 and the values are in row Input!5:5 for organization 1 and Input!32:32...