Recent content by dnessim

Here is a simple example of what I am trying to. I have a column of data, Hospital readmissions. There are 6 values in this column Hospital readmissions 7 12 9 4 7 2 The formula to calculate each value looks like this...

I guess my vision is to be able to do something like passing data with key-value pairs like we do on a querystring for a web applications https://chandoo.org/excel?filtercriteria1=apples&filtercriteria2=red&filtercriteria3=Jan well , something like this for a value in a cell linked to worksheet

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...

Luke, you are right its anoying since I had the values I wanted completed in about 20 mins then I spent the next few hours searching and tshooting to try to get rid of the "empty" cells. I did get to converse with all you fine folks about excel, which is always a pleasure. I did solve my problem...

I copied the data to another sheet and used paste special > values , then I used filter to get rid of the blanks. This worked so I am all set. Still dont understand why my other method used find/replace > go to special > blanks and I couldnt find any blanks even though i had some blank cells...

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...

Yes, thanks all, upgrading to MS Office SP 3 resolved this issue. I am able to now crawl out of the rat hole I found myself in. Dave

Thanks, acording to that article it requires a service pack update. I will try to get that installed. Thanks Dave

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...

pmcc1, In Excel dropdown lists are a form of data validation. There is a really good tutorial right here on Channdoo.org. this should get you started http://chandoo.org/wp/2008/08/07/excel-add-drop-down-list/ If you want to ge more complex , meaning context sensitive you can do that too...

Narayan, Thanks so much for taking the time to download my file and help me. Some more details that will help explain what my objectives are. The CAR-Dashboard sheet is a legacy documemnt, meaning I cant change the layout and the the sheet should be read-only to my users, meaning they enter...

@Narayan, Hi I have sanitized a sample of my workbook. Can you help me to understand some of my options to manage such long formulas. Maybe an example of a UDF you suggested? I wasn’t able to get a udf to do what I wanted. Is it possible for a UDF to change the color of a cell...

Hi Narayan, I do know some VBA and I have been torn as to redo this project using vba. You are so right about trying to understand this formula in the future. Thanks, Dave

Hi Hui, That first if statement doesnt look for an error but it looks for a value in one of my dropdown lists on the data entry page. If the value is 0 then nothing should display. That would help a little but not really solve my problem of having to maintain this formula on a worksheet in...

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...