Posts by rajesh06

Here are some reponses 1 Some add-ins do create named ranges; you can also write macros to do that 2 No 3 Named ranges can have either a worksheet "scope" or workbook "scope" (Formula Tab / Name Manager). You can refer to cells by range...

Quote:Originally Posted by Hard2Fit When's the next Paul Stuart sale? Typically the day after Christmas I think. (publicly announced about 1 week before)

OK I see. Not sure I have a good solution for you then. You may be able to do something using tables (excel 2007 and 2010), creating helper columns and working with filters. Alternatively, I thought there may be a query facility that you...

You should be able to handle something with this level of complexity with a pivot table

Click the arrow to expand "Number" under the Home ribbon. Under the Number tab look for "Special" and then Phone Number.

You should be able to do this with a filter and a "helper" column. The helper column would be the basis of the filter and might be something like 1, 0, 0 , 1, 0, 0 , 1, 0, 0 (Really anything that would have a unique identifier for the...

Quote:Originally Posted by Cant kill da Rooster Olive pants with an olive shirt sounds odd. . Agree and am surprised that this thread isn't full of 10 pages making fun / sarcastic comments of the OP.

Look up conditIonal formatting

This is one of Ledbury's key features / marketing points - and they are well within your price range.

My shirt maker told me that wearing an undershirt reduces the life of the shirt due to the friction between the undershirt and the shirt. Also, much of the pleasure of wearing a high quality shirt is the feeling of the fabric against...