Recent content by iken

Cheers guys, The spreadsheet I attached is just a portion of the actual file. A bit more words around what I am trying to achieve. Column A represents trades and all companies we use under each, so there could be some 20 odd under each trade/discipline. Column C, D, E & F are my helper columns...

Hi Folks, I need a bit of help on using named ranges for data validation lists. The sample excel file has a snip of what I have. generally the layout cannot change from what I have (not what is in file) Summary of what I have done so far: 1. I have a list of multiple disciplines, which have...

Hey fellow geniuses, Just wondering if there is a way to rank in alphabetical order, a list of names but only if a value in an adjacent cell is greater than 1? On the attached worksheet, I would like to rank the names that have a value in row B greater than one, while ignoring the names that...

Hi Skip, I tried to copy the code into a few places (Module 1, into code for Trade List worksheet) and couldn't get this to work. I did note I got teh column wrong, should have been C and not D so I changed this alomg with the offset - still didn't work as below. Sub HideUnhideSheets() Dim r...

Hi All, I have searched far and wide for answers to this, and there are some that are close, but none that suits my specific needs. I have a workbook with over 100 sheets, each named, and not in order (ie sheet 10 could be the 30th sheet). On the first sheet called "Trade List", I have all teh...

Hi, It all depends on the layout level you are drawing. For a layout plan I would detail the following Plan Level Drawn size SA Drawn Size RA Notes SA Note RA Roof 24 x 24 20 x 20 24 x 24 TB...

Thanks for all the replies. We have no control over the quality of town supply conditions, so whatever it is today could change tomorrow. The consultants specified 2205 after tender (scope change) but no0one knows why (even the consultant looking after this cant explain why. The manufacture of...

Thanks gr2vessels, I did forget to mention this for for domestic hot water, so the wtaer will be around 80 degC (tempered down at basins) and is an "open" system so is subject to town mains and the quality is not controlliable.

Hi All, Can anyone advise why 316ss shouldn't be used for pressure vessels dor a domestic water system. We have a contractor stating it must be 2205 but will not/can not substantiate this (other than 2205 will cost more - more for them). Thanks,

The "Mechancial" feild is very vast and open to alot of different areas of work. I constantly deal with specifications that are cut and pasted from other contracts, which means the scope of works is not 100% correct/specific. The only real way is to start from scratch and detail what is...

Isn't it funny, that as soon as you ask the light bulb comes on. Needed to be an array formula - all sorted

I have a spreadsheet for a snooker league I am trying to correct (in particular finding the maxium breaks and name of person) for each week (up to 7 matches a week for around 14 weeks at the moment). I have attached a sample sheet here, if anyone can let me know what formula I need to put in...

Hey, I found another forum, and had the attached as a reply Works a treathttp://files.engineering.com/getfile.aspx?folder=7dad1cd7-987e-49ad-9c2d-a2e0dd5ced94&file=Sample_(Modified_by_tigeravatar).xls

Thanks IDS, Your method almost works, it just doesn't quite give the right figures for multiple values of the same freqency as below: Formulea Results Expected Results Number Freq Rating 1 2 1st 9 10 10 2 4 2nd 8 9 9 3 6 3rd 7 4 4 4 7 4th 7 4 7 5 2 5th 7 4 8 6 4 6th 6 3 3 7 7...

Hi All, I am trying to get a value from a list, based on it's ranking. I need to get the cell value from the cell directly above the value gained from the Large function. I have tried using OFFSET(LARGE($B$5:$AO$5,1),-1,0,1,1), but get an error (it appears the Large function cannot be used as...