Search results

Here's what I would like to see happen (in lay-men's terms)...I would like pull column/row information from the "master worksheet" into preformatted tables(i.e. individual worksheets) and then sort that data in the table, respectively. As an example of one table, I want to pull the following...

I am trying to conditionally format columns with the header as dates. I would like to format based on the following: Dates > Today = Format entire column Black Dates = Today = Format entire column Yellow Dates < Today = nothing How can I format an entire column based on the value...

Nevermind on that one! I fiddled around and figured out how this works now. Finally I'm starting to get how all these formulas are connecting my data together. Thank you Chandoo for the patience and help! You really are a great person for being there for your community.

Chandoo, you are awesome!!! This is exactly what I need! :) How could I do this but return the next number in the array (i.e. the second number)?

I have a range of cells from rows 5:88 and columns A:Z. The range looks some like this... #NA ; #NA ; #NA ; 1 ; 5 1 ; 9 ; #NA ; #NA ; #NA #NA ; #NA ; 7 ; 3 ; #NA Etc.... Is there a formula that returns the 1st cell that equals an actual number?

I have a range of values C3:C100 that have been offset from a separate worksheet based on meeting certain conditions. If the conditions are not met, the cell value is returned as #N/A. The values that met the conditions return their numberic value. In order to chart the duplicate values on a...

I have special situation where information is housed in a separate system and need to export this data from time to time to update the data in my "data" worksheet of my dashboard. If I delete the current worksheet titled "Data" and import a new worksheet and title it "Data", will the formulas...

Thank you for the reply. I was able to figure out question #2. For question #1 however, I have built the following formula, which separates the labels somewhat, but there are still several duplicates. I have tried create unique ratings for each risk, while keeping the rating within the range for...

I have built a scatter chart to show as a risk heat map, where Y-axis is Impact and X-axis is Likelihood. Couple challenges I have and could really use some help. Some info on the risks. -Each has an individual risk ID #. No duplicates exist. -Impact rating is either 1,3,5,7,or 9 -Likelihood...

I have spent several days on this and still cannot figure out how to sort my data. To give better description, based on the KPI dashboard tutorial, my dashboard is for showing risk information. There are 5 buttons: 1st = Risk Rank - this is a numerical value 2nd = Risk Category - text 3rd =...

I'm building a dashboard based on this tutorial http://chandoo.org/wp/2008/09/10/kpi-dashboards-graphs-excel/ I am OFFSET'ing both text and numberical values in the Sort KPI column, which I then had to include a SUM(COUNTIF) function in the Unique column to handle both text and numbers. I am...

I'm following the tutorial that has been posted on building dashboards that the user can sort. http://chandoo.org/wp/2008/08/27/excel-kpi-dashboard-sort-2/ I've been able to build my own dashboard, but the data I need to sort is both text and numbers. Can anyone tell me how to implement this...

I would like to sort a column based on numberical values, but then further sort them based on an asigned unique number from another column. How can I write this into a LARGE function equation?

Column B is text either "Credit" or "Debit" Column D is number Column E is running balance I want an "if" statement to this effect: If Column B = Credit then "Add" Column D to Column E, but If Column B = Debit then "Subtract" Columnd D from Column E. This would be a running tally as...

If entered exactly as above, this only returns a #VALUE!

Thank you for the reply but not an option for the version of excel I have.

Thank you for the response. It worked great. However, looking further into this, how can I include an additional condition into the function that basically asks: If A3:A80="D", and then do the same thing with the SUMIF function you provided. Any idea how I can incorporate this into your...

I have a column which tracks the date of certain expenses and separate column with the expense. Each expense is entered separately, therefore there may be multiple rows with the same date. How can I write a formula to sum the expenses between a predefined date range? Currently, I am entering...