Recent content by StephenSLR

I figured it out and as predicted schedule 120 precedes schedule 40. s

Is it possible to sort the results of a pivot table? See attached file. The 2.5 NB pipe is right down the bottom with the 24 inch pipe. Also within the ranges, i.e. in the 4 inch range the 'schedule 80_' precedes 'schedule 40_'. I can foresee that if it is possible to sort the 'schedule 120'...

Thanks all, It worked a treat. Another thing bothering me, when I use excel help the font size of the answer is too small - see attached. Can I increase it to make it easier to read? s

Thanks that worked, however there are a lot of N/A 's. How do I get them to be blank? Also, so I can learn more, what does the 10 and the 0 in the formula represent? s

The file is very large so I've extracted part of it and I've noticed something else happening for the first pivot table - some of the values are correct. See attached file. To make it easier I've changed my question to suit. I have a concatenated value in Column H...

I have a concatenated value in Column S =CONCATENATE(P5,Q5,R5,N5) In column T I have the formula =LOOKUP(S5,$H$124:$H$2340,$Q$124:$Q$2340) I can see the concatenated value I want in column A ELBWSA 234 WPB1.5Sch80_ and this appears below in the H-Q range specified in the lookup...

Just a simple question about Windows XP Explorer background colour. I have changed the background colour so that the explorer window panes are not white - I have to stare at it all day and a very pale light green I find is a bit easier on the eyes. I went to Control Panel / display/ appearance...

It may not be that simple after all, when the pivot table is refreshed it will change values in column H to whatever pipe was used in the other sheets. Each project is different. The formatting formula has to match the values in column H alongside the pivot table to the values in column H below...

Yes it does, thanks! However there is one hitch, I notice the next row down the formula changes to condition 1: =R112="S" and this is causing errors further down. when I add more and more pipe and schedules things will change so I will need to put in a range rather than a cell. I tried...

Thanks, I think I understand. In column R from row 111 downwards I'm putting an S or a B, etc. into the corresponding cell. Then using conditional formatting in column J from row 4 down. If the value = S colour cell tan, if the value = B colour cell yellow. What formula is best to use in...

I have coloured the prices of SPFA tan, e.g. (Q:137), the prices of Buhlmann have been coloured yellow e.g. (Q:158) Let me explain. When I receive a price list from SPFA I go to column H and match the prices to the pipe specs. 1 inch pipe of schedule 40 is in row 137 SPFA charge 7.23 per...

I've attached one page and edited it to keep the size small, the file is 12 Mb all up. Don't refresh the pivot table as the pages it is linked to aren't included in the file. I'm not sure, conditional formatting from what I understand works if a value is below or above a certain number? s

As you can see from the top image, column I has values taken from column Q in the bottom image. The values are transferred over but not the formatting. I'm not sure how to use that code you pasted, if it can do what I want how do I put it into use? Thanks for the help. s

I'll try to explain, my spreadsheet is quite complicated. In the top left corner of my sheet I'm using the formula =SUMIF($H$124:$H$2180,H5,$Q$124:$Q$2180) At the bottom of the sheet the H column has one set of data and the price is in the same row in the Q column. I'm inputting values from...

Is it possible to set a formula to copy a colour/format of a cell when it selects the values? I have set up a sumif formula in a cell to select from a range of cells. In the range I have coloured the cells containing the prices in USD of one company in Green and another company's prices in...