Singletrack Forum » User Favorites: cookeaa

Singletrack Forum » User Favorites: cookeaa cookeaa en-US Tue, 29 May 2012 09:59:15 +0000 http://bbpress.org/?v=1.0.2 <![CDATA[Search]]> q http://singletrackworld.com/forum/search.php Stoner on "Just learnt a powerful new Excel technique" http://singletrackworld.com/forum/topic/just-learnt-a-powerful-new-excel-technique/page/3#post-3751956 Wed, 02 May 2012 09:53:59 +0000 Stoner 3751956@http://singletrackworld.com/forum/ ach. Its done w directs now. Deadline looming in 48 hrs - sometimes you just have to crack on and damn the finesse. If I find a workaround once the model's done Ill drop it in later. Rob Hilton on "Just learnt a powerful new Excel technique" http://singletrackworld.com/forum/topic/just-learnt-a-powerful-new-excel-technique/page/3#post-3751902 Wed, 02 May 2012 09:39:26 +0000 Rob Hilton 3751902@http://singletrackworld.com/forum/ It's defnly do-able, but I'm a bit too rusty at this stuff now to give an answer without wasting lots of time Stoner on "Just learnt a powerful new Excel technique" http://singletrackworld.com/forum/topic/just-learnt-a-powerful-new-excel-technique/page/3#post-3751859 Wed, 02 May 2012 09:26:19 +0000 Stoner 3751859@http://singletrackworld.com/forum/ <blockquote> I haven't even touched any LCS</blockquote> I wouldnt be too worried. 'orrible stuff. We have to cut our own threads by hand - no automatic dieing machines in our college! Doing an assessment piece at the moment - hanging two rads - with two step overs. Its unforgiving stuff. have tried lots of workarounds and just cant get offset and indirect to work together in this formula. Im going to have to do direct formula <img src="http://singletrackworld.com/forum/my-plugins/bbcode-buttons/default/icon_sad.gif" title=":(" class="bb_smilies" alt=""/> Rob Hilton on "Just learnt a powerful new Excel technique" http://singletrackworld.com/forum/topic/just-learnt-a-powerful-new-excel-technique/page/3#post-3751751 Wed, 02 May 2012 08:54:16 +0000 Rob Hilton 3751751@http://singletrackworld.com/forum/ Let the sediment build up sediment and you could be looking at a NOT <img src="http://singletrackworld.com/forum/my-plugins/bbcode-buttons/default/icon_smile.gif" title=":)" class="bb_smilies" alt=""/> God knows how but I've passed my level 1 and I haven't even touched any LCS yet! Some disorganisation going on at my college... Stoner on "Just learnt a powerful new Excel technique" http://singletrackworld.com/forum/topic/just-learnt-a-powerful-new-excel-technique/page/3#post-3751222 Tue, 01 May 2012 22:43:23 +0000 Stoner 3751222@http://singletrackworld.com/forum/ <blockquote>Rob Hilton - Member Like no way dude - parallel lives! I'm doing level 2 on Mondays & Wednesday evenings. Get the feeling you're a bit ahead of me.</blockquote> no, not ahead of you Rob. I decided to start from scratch so am 3/6 terms into 6129 City & Guilds first, before L2 and L3. I decided that although I have quite a bit of experience I have some holes in my basic knowledge and I might as well fill them on the way through. Im in no rush. Tuesday night practicals and Wednesday theory. Hands as black as soot ATM from mucking about with LCS pipe. Maybe an interest in Excel leads to a propensity to plumb. After all, CH is just AND & OR gates is it not? <img src="http://singletrackworld.com/forum/my-plugins/bbcode-buttons/default/icon_wink.gif" title=";)" class="bb_smilies" alt=""/> Rob Hilton on "Just learnt a powerful new Excel technique" http://singletrackworld.com/forum/topic/just-learnt-a-powerful-new-excel-technique/page/3#post-3750010 Tue, 01 May 2012 17:06:00 +0000 Rob Hilton 3750010@http://singletrackworld.com/forum/ Like no way dude - parallel lives! I'm doing level 2 on Mondays & Wednesday evenings. Get the feeling you're a bit ahead of me. You don't also have flashbacks to when you were a small Amish girl churning butter on a rainy day do you?* *Made this bit up. Stoner on "Just learnt a powerful new Excel technique" http://singletrackworld.com/forum/topic/just-learnt-a-powerful-new-excel-technique/page/3#post-3749950 Tue, 01 May 2012 16:52:12 +0000 Stoner 3749950@http://singletrackworld.com/forum/ Cheers Rob, will digest later. Off to plumbing school now... Rob Hilton on "Just learnt a powerful new Excel technique" http://singletrackworld.com/forum/topic/just-learnt-a-powerful-new-excel-technique/page/3#post-3749929 Tue, 01 May 2012 16:47:34 +0000 Rob Hilton 3749929@http://singletrackworld.com/forum/ <a href="http://spreadsheetpage.com/index.php/oddity/a_range_name_is_really_a_named_formula/" rel="nofollow">http://spreadsheetpage.com/index.php/oddity/a_range_name_is_really_a_named_formula/</a> Stoner on "Just learnt a powerful new Excel technique" http://singletrackworld.com/forum/topic/just-learnt-a-powerful-new-excel-technique/page/3#post-3749900 Tue, 01 May 2012 16:41:49 +0000 Stoner 3749900@http://singletrackworld.com/forum/ named formula or named range? if named range, Id need to create a named range for each incidence (50cols by time, bringing back SUMPRODUCTS from 20odd worksheets) Rob Hilton on "Just learnt a powerful new Excel technique" http://singletrackworld.com/forum/topic/just-learnt-a-powerful-new-excel-technique/page/3#post-3749895 Tue, 01 May 2012 16:39:26 +0000 Rob Hilton 3749895@http://singletrackworld.com/forum/ I had quite a time trying to resolve (I think) this very issue some years ago. I wonder what I did... How about using the offset as a named formula? Stoner on "Just learnt a powerful new Excel technique" http://singletrackworld.com/forum/topic/just-learnt-a-powerful-new-excel-technique/page/3#post-3749873 Tue, 01 May 2012 16:35:15 +0000 Stoner 3749873@http://singletrackworld.com/forum/ emergency people! It appears that INDIRECT wont work with Dynamic Ranges. i.e. OFFSET((INDIRECT($B$29&"$K$10")),0,0,270,1) throws up a #VALUE when used in a SUMPRODUCT formula. The reason Im using INDIRECT is to be able to build a formula that can address specific worksheets. Anyone got any ideas which function will bring back a range but can be built up from a text input for the Sheetname? INDEX I dont think will work. reggiegasket on "Just learnt a powerful new Excel technique" http://singletrackworld.com/forum/topic/just-learnt-a-powerful-new-excel-technique/page/3#post-3749828 Tue, 01 May 2012 16:25:50 +0000 reggiegasket 3749828@http://singletrackworld.com/forum/ you can also use a simple SUM function, but with an IF statement emnedded in it, and entered as an array function. Press CTRL + Shift + Enter to complete the formula: {=SUM(IF(LEFT(A1:A10,LEN(F1))=F1,B1:B10))} Stoner on "Just learnt a powerful new Excel technique" http://singletrackworld.com/forum/topic/just-learnt-a-powerful-new-excel-technique/page/3#post-3749070 Tue, 01 May 2012 13:18:58 +0000 Stoner 3749070@http://singletrackworld.com/forum/ grr, anyone know why I cant get this SUMPRODUCT to work with OFFSET properly? Just getting #VALUE My OFFSET formula is valid on its own, and the SUMPRODUCT formula is valid with the range entered as a full address. But swap the range address for the OFFSET statement and it no longer works... Stoner on "Just learnt a powerful new Excel technique" http://singletrackworld.com/forum/topic/just-learnt-a-powerful-new-excel-technique/page/3#post-3748931 Tue, 01 May 2012 12:43:16 +0000 Stoner 3748931@http://singletrackworld.com/forum/ BTW just found that this will work across different sheets quite happily. i.e. Criteria range on one sheet, value range on another. I know, not that remarkable, but good to know. soma_rich on "Just learnt a powerful new Excel technique" http://singletrackworld.com/forum/topic/just-learnt-a-powerful-new-excel-technique/page/3#post-3748370 Tue, 01 May 2012 10:32:37 +0000 soma_rich 3748370@http://singletrackworld.com/forum/ I am loving the XmlImport method in VBA at the moment enabling me to pull in loads of data from the web manipulate it and re publish it. VBA is where its at there is only so much you can do with functions. Stoner on "Just learnt a powerful new Excel technique" http://singletrackworld.com/forum/topic/just-learnt-a-powerful-new-excel-technique/page/3#post-3748314 Tue, 01 May 2012 10:19:08 +0000 Stoner 3748314@http://singletrackworld.com/forum/ good to hear. Didnt realise there might be a backlog of demand for the "Double Unary" (--) ! <img src="http://singletrackworld.com/forum/my-plugins/bbcode-buttons/default/icon_wink.gif" title=";)" class="bb_smilies" alt=""/> Ive just sat down to use the formula in earnest now. Lets hope it holds up .... craigxxl on "Just learnt a powerful new Excel technique" http://singletrackworld.com/forum/topic/just-learnt-a-powerful-new-excel-technique/page/3#post-3748187 Tue, 01 May 2012 09:54:22 +0000 craigxxl 3748187@http://singletrackworld.com/forum/ Cheers Stoner, just saved me some time and no doubt more in the future with that formula. SamCooke on "Just learnt a powerful new Excel technique" http://singletrackworld.com/forum/topic/just-learnt-a-powerful-new-excel-technique/page/3#post-3746414 Mon, 30 Apr 2012 16:51:23 +0000 SamCooke 3746414@http://singletrackworld.com/forum/ <blockquote>is the whole forum yours or were you trying to link to a specific post?</blockquote> I think he was demonstrating his ability to include links in his text within a forum Stoner on "Just learnt a powerful new Excel technique" http://singletrackworld.com/forum/topic/just-learnt-a-powerful-new-excel-technique/page/3#post-3746404 Mon, 30 Apr 2012 16:43:22 +0000 Stoner 3746404@http://singletrackworld.com/forum/ is the whole forum yours or were you trying to link to a specific post? Klunk on "Just learnt a powerful new Excel technique" http://singletrackworld.com/forum/topic/just-learnt-a-powerful-new-excel-technique/page/3#post-3746278 Mon, 30 Apr 2012 16:05:21 +0000 Klunk 3746278@http://singletrackworld.com/forum/ as this is a flaunt your geek week, heres one of <a href="http://forums.cgsociety.org/forumdisplay.php?f=98">mine</a>