Search results

Hi all, I have googled this question and not come up with a solution that fits my needs yet. I have a dashboard with hospital readmission rates, basically numerators, denominators and %rate values , for each quarter of the year. What my question is how can I make the values link to another...

Hi, I have a formula in a worksheet that I copied down aprox 61K rows. The formula looks like this: =IF($A4=$H$1,OFFSET($A4,-1,1,1,1),"") so when this formula is false I get several "blank" rows. When I copy this column to another sheet and try to paste special values only, I see my blank rows...

Not sure if the title of this thread is even close to my problem. I have a chart that updates the last N number of values. It uses the named ranges and the offset function. The way i have this set up works on my PC fine but as soon as I open the file on another computer it fails. My theory is...

Hi all, I have been working on a data entry project in Excel. I have a Data Entry worksheet that has about 13 columns. some of the headers are: Indicator Name Indicatory Category Date Goal Facility Unit Unit Group Numerator Denominator Base Rate Calculated Rate This worksheet...

Hi, Rate_Base is a named range with empty cells, when I put values in the cell it correctly sums the values of rate_base =SUMPRODUCT((MONTH(Entry_Date)=1)*(YEAR(Entry_Date)=2013)*(Indicator_Name="CLABSI")*(Facility="Carrollton")*(Unit_Group="ICU")*(Rate_Base)) Why does this not work? If I...

Hi, I have a conditional format that works fine but what if I want to assign an named cell as my criteria instead of hardcoding a value. Seems like this should work? Hardcoded version...

Hi all This has had me stumped for a while. I have cell M2 containing this formula in it =COUNTIFS(Indicator_Name,A2,Entry_Date,DATE(YEAR(C2),MONTH(C2),1),Facility,E2,Unit_Group,G2) If I set a custom validation on cell L2 to this =M2<=1 If a user trys to enter a value in L2 greater...

I guess the VBA forum would be a better place to ask this one? Hi, First, Is it true that a regular line chart cant scale the Y axis in hours? so we should use a scater plot? Here is my real question, My hospital takes temp and humidity readings every 30 mins for 11 Operating rooms. This...

Hi, First, Is it true that a regular line chart cant scale the Y axis in hours? so we should use a scater plot? Here is my real question, My hospital takes temp and humidity readings every 30 mins for 11 Operating rooms. This data is saved to a big Excel file. I have a procedure that...

Hi all, I wrote a vba app that opens a master workbook, it does a complicated IF statement to filter out rows based on column criteria It then saves the filtered rows to another workbook , closes out the master, closes and saves out the subset of data as "work list" this all works great but...

I trying to get this code to run, its just a sample for learning purposes can you tell me why I would get a "runtime error 424 object required" on line 7 Its supposed to copy the rows that have Car in column 1 to sheet 2 Thanks Dave Sub mycar() x = 2 Do While Cells(x, 1) <> ""...

Hi, Here is another problem I am trying to figure out that I have not been able to search for a solution. I have a list of values that are grouped, what I want is a formula to calculate the range (Max-Min) Here is an example of my data Group Name Value Range Calc (Max-Min) GRP1 2 4 GRP1 4...

This question seems to come up quite a bit on the forums, but I cant seem to get my specicic scenario addressed. Col M contains the values I want to group, Col N is the group they fall into , see example here: value (col M) Range (col N) 0.439 0.7 0.619 0.7 0.619 0.7 1.929 2.1 1.929 2.1...