Search results

SirJB7...They'd flip..The Actual would be "ahead" of the "Expected". You're example is correct that the Actual would be in the 50%, and, the expected in the 25%. The colors are kind of irrelevant, as eventually they'll probably become webdings (X's, circles...whatever) or something else...

a). Yes SirJB97. That is my fault. I thought I'd removed/unhidden that line. Please assume that it should be Row 10. b). 37% will correspond to "25%". The goal is that UNTIL That value is equal to, or, exceeds the next heading (in the case of 37%, that would be 50%), it stays in the 25%. So the...

Hello- I'm trying to use Icon Sets to display % actual complete vs expected % complete for a software build. The % complete is purely manually entered, however, the expected % complete is calculated based on a formula where the Elapsed Days of Build is Divided by the Total Days of Build. For...

Bam! Works like a charm. Thanks buddy!

Sweet! Thanks buddy. When I enter it as-is I get a value, but, if I Ctr+Shift+Ent it goes blank.

Hi there- Wondering how I can add additional criteria to an array formula like this: =IFERROR(INDEX($C$2:$C$453,SMALL(IF($M$2:$M$453<TODAY(),ROW($M$2:$M$453)-ROW(!$M$2)+1),ROWS($M$2:$M2))),"") = C+S+E Is it as simple as just adding "AND" to the IF...

You know Luke...it dawned on me during my lunch that I might be overreaching. Indeed! Thanks buddy :). My orignial intent was to just use the times and rank those, but, since I actually added a "rank" column, the iNdex/Match is la bomba.

Ok. I've rearranged my data and have the following formula: =INDEX(Table11[Ticket '#],LARGE(IF($AM$11=$X$3:$X$74,ROW($X$3:$X$74)),ROW($N1))) AM11:AM15 are the values 1, 2, 3, 4, 5. T X3:X74 is the Ranking (1-70). I want to extract the ticket number (Table 11 data) into AN11:AN15 so it's next...

Thanks for the feedback on this guys. I forgot to check back. I will institute this formula and let you know. Much appreciated!

Is there a way to "$" a table heading so it doesn't move a column when I drag it? I spend a lot of time fixing the table heading in a formula after I drag it to the right/left, when I want that to stay fixed. Other than manually typing in the cell range, is there another way? perhaps this is a...

I'm having some issues with an array formula, similar to the one Luke did in Formula Forensics 3. Good ole =INDEX(SMALL(IF) Here goes: I've got a list of data that is ranked based on shortest to longest. It is NOT in sort order, but, has a value of 1, 2, 3, 4, or 5 (K28-K32). This sort order...

Thanks Luke. Yeah, that's my problem! This just further highlights my issues I've already raised with the requester. :)

Hi there, I'm trying to figure out the % of time for a specific interval based on the total length of time for a task. For example, here's my data: These are intervals of time BETWEEN two tasks. I need the metric of % of time for intervals between tasks. Int 1 ||Int 2 ||Int 3 ||Int 4...

Thanks Shrivallabha. I was doing the ctrl+enter trick wrong!!! I was typing the "=" portion into the formula bar...rather than the cell itself. Thanks for your input too!

Hello- I'm stumped! I have some blank rows I am trying to avoid filling in manually: A| AB| CD| DE| There are ALWAYS 9 rows between values. What I want is all of the blanks populated with the value above it...so: AB AB AB CD CD CD DE DE DE etc.... I tried the Ctrl+enter...

This is my first shot at an array formula, so here goes: =INDEX(Sheet4!$C$2:$C$7,SMALL(IF($A$2:$A$7=Sheet4!$A$2:$A$7,ROW($A2))-1,ROW($A1))) This is pulling the corresponding value from the Actual cost column by matching the ship to name on both lists... Entered in D2 on Sheet one, using...

Chandoo had a special blog post for this specific item. http://chandoo.org/wp/2013/01/07/todo-list-with-priorities/

Hui- Thanks for all the hard work & brain crunching!

Sajan - WOW. Can you explain the "=5" part? I see Hui used the same technique in his (but used "=15". This would be an awesome Formula Forensics

I can't tell if you want the entire row (i.e. that specific series of numbers), or one of those values. I did a search in the "search box" for "search array" and found this little gem from narayank991: http://chandoo.org/forums/topic/position-of-a-cell-in-a-range Assuming your data is in...

Narayank991 - This is an array formula right? CSE? Very cool.

I believe all you'll have to do is just change the letter from "C" to the other one...like such =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE("CR"&A2," ",""),",",",CR"),"CRCR","CR") =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE("Q"&A2," ",""),",",",Q"),"QQ","Q") etc

This is neat. I've been playing with this, but, I noticed that eventually, it stops at a single name. Why is that? Does the RANDBETWEEN function not allow the same number twice or something?

Hi SirJB7! Unfortunately that is blocked at work :-(. Narayan- Thank you for this! No wonder! The irony is that I actually updated the formula to VALUE(=IF(AND(H$22&#62;Sheet1!$B4,H$22&#60;Sheet1!$C4),"1","")) and it worked, but with the number of cells & reference updates I'd have to...

Hello there- I've searched the box and read countless threads, but, still having the same issue w/conditional formatting. I've made a small Gantt inside a dashboard, and want to fill the cells when a date is between the start & end date(s). My formula within the Gantt is great, and...