Search results

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...

Row 11 to refer to Row 12. i.e. the original row to always refer to the row directly below it. Thanks, it works, the only thing is that if there is no value in the cell below I get 00/01/1900 s

I am using a database that I didn't design and is locked by the designer. Is there a way to switch on an autocomplete to fill in data I add into the text boxes - just like it does in MS excel? s

Thanks for that, I think it works, however my data consists mainly of dates. Cell A2 contains the date 03/11/2006 - 3rd November 2006 and when I use the indirect function I get the value 39024 in cell A1. How do I get it to format dates properly. Also if I click and drag the bottom right...

Hello, I would like a cell, A1 say, to always show the value of the cell directly below. i.e. typing '=A2' in cell A1. If a new row is inserted below row 1, I still wish A1 to show the value of the values I will enter into A2. I have tried both absolute and relative references but when I...

Is there a way to have text from one cell centred vertically over a selection of cells in a column? The text of is at 90 degrees going from down to up the column. s