Search results

First, hide all the columns and rows in that worksheet. then you can set up password for that particular worksheet and make it very hidden under Macros.

I used E1 for user to enter the desired number of figures to display (counting backwards). and the new formula is IFERROR(INDEX($B$3:$B$101,MATCH(COUNT($B$3:$B$101)-$E$1+ROWS($D$3:D3),$C$3:$C$101,0)),"") and it will display the x number of figures in a straight sequence. Easier on the eyes.

Hi Chandoo, thanks for the idea. I have made some changes... 1. the display is in reverse order. Since it is going to be a helper column i have cell e1 for input: the number of last figures to be displayed. and then the formula would be...

Can you just create a list just like that? Or are you saying the pulldown menu is dependent upon a vlookup?

Hi, I was reading http://chandoo.org/forums/topic/return-last-5-entries-of-a-dynamic-list-ignoring-blank-cells and wonder what if I want to return all the numbers (or text), instead of just the last 5 numbers?

Can you explain further? you can start with 2 cells that's rand() and then a 3rd cell doing Randbetween(first cell,2nd cell)??

Please define 1. the "problem" with the >1 on 2010 and <1 on 2009. if there is a decrease then there is a decrease. 2. what "ideal" results you want to see. are you seeking an absolute value from the computation? Then you need to use ABS().

Yes, Hui. you are right. it's the number of character, not length. it's just my way of remembering that function. The more characters it has in a cell the longer, hence length, it looks to me. ;)

Len = length of a cell

What is your question?? Or you are just happy to make a statement? ;)

right click on cell. go to format cells. go to number tab. make the change. Yeah, here is the thing that annoys people somewhat. you are most like trying to enter a number in a cell next to a cell with a date on it. MS thinks it's smart to auto format your entry the same as the one above...

Oh I see. please ignore my last posting i didn't quite understand the original requirement.

i suggest you use ISTEXT function after using a IF function. IF(ISTEXT(A1),"Accept","Reject")

I actually have done that in the past. but the most important thing is that you work with your manager and/or receipients of the dashboard and pick their brain on how they see those KPIs are related. Most often than not they would say KPI#4, 6 and 11 are related and put them in a chart...

(Materials!$k$5:$k$1001 instead?

the indirect part should be =indirect(cell location of the first pull down menu that shows the choices of Meat vege or fish&"List") That said, you need to build your 3 lists as "MeatList", "VegetableList" and "FishList" because the spelling has to be the same as in cell A1 (showing up as...

check out this link http://www.youtube.com/watch?v=e-cRsGYDj-I&feature=plcp&context=C39e7847UDOEgsToPDskJ3c92uJNn6yELw_nWGK225

You lost me at "sales history as a percentage of sales and quantity of items sold". Do you mean you want to 1. have the year on a click down menu? Yes. Pivot table does provide that. 2. show the years as column heading? yes. Pivot table can do that too.

what is SUM176??

first of all, define the days shown using weeknum(date,1). then you need to do a sum of dates' data in a weekly fashion. Then you can create your graph using weekly data and a pulldown menu as the driver.

similar technique as in http://www.youtube.com/watch?v=e-cRsGYDj-I&feature=plcp&context=C39e7847UDOEgsToPDskJ3c92uJNn6yELw_nWGK225 ??

Briefly looked at your spreadsheet. Here is my observation your "actual" formula is just a long "if" function when the "base", "INCR" and "misc" are all independently working so your "if" formula should have somewhere "+" with in but i don't see any. May be that's reason why your "correct"...

http://www.techonthenet.com/excel/formulas/match.php I guess you have to ascend or decend your order when you need to use 1 or -1 in the 3rd string of argument in match function? So tbw, exactly what was your ideal answer or what you trying to find on your list? if you want to count the...

have you tried using sumif(range of vehicle numbers,the specific vehicle number you want,column of data on sum)

I think you need to create the hyperlink from the PDF file, not from XL.