or Connect
New Posts  All Forums:

Posts by rajesh06

Quote: Originally Posted by yerfdog Yeah, but most cities have more than one zip code, and big cities have many. good point - i have no good solutions for you then. If your goal is to rename all the addresses consistently then I would suggest creating a "rename" table which starts with a pivot table with the addresses in the rows and then some sort of count as the data. You would then sort this alphabetically in order to get similar names...
Quote: Originally Posted by 1970cleveland I took 2 new Brooks Brothers shirts to get pressed and they did so with the collar stays in, now I have ugly stay imprints visible through the outside on my collar. I tried ironing them out after removing the stays but they are still visible. Has anyone had this issue? I may try washing it then ironing it again. Right now they look horrible, I would not wear them but at the same time I would hate to scrap 2...
Quote: Originally Posted by Bhowie I have a column with addresses some of the duplicates are not all spelled exactly the same way ( Capital of Texas Highway can look like Capital TX Hwy, CapL of Tx Hwy... etc.) and I also have a column with the corresponding city. The problem is I don't have the zip code for any of these locations. Is there any way I can match up a zip code without looking up each inidvidual address? There are over 1000 entries so...
Quote: Originally Posted by ThinkDerm awesome stuff! +1 - it would be easier if they were grouped by size.
Quote: Originally Posted by NameBack Yeah. Sorry, should have clarified -- that's my question. I know how to get it to do an autofill to a certain range, the problem is that I can't figure out how to get it to fill to anything other than a static range. The makeshift solution I have is that it fills down to a predetermined range, which is way longer than it needs to be (to make sure that it fills down sufficiently far, as the files I'm working...
Quote: Originally Posted by NameBack So, is there a good way to duplicate the way autofill works with VBA? In the sense that, I want a macro that opens up a document, adds a column, and fills that column with a value all the way down to the bottom of the sheet, as would happen if I manually double-clicked the corner of the cell. Basically, how do I use relative positioning in VBA? I once boot-strapped something with a macro that would find the next...
Quote: Originally Posted by MasterOfReality I have a bit of an issue. I am going through geological logs that were logged in imperial units. I need to convert this to SI units. There are thousands of lines with distance measurements that are in feet and inches. For example each measurement, its actually typed into one cell as "208' 3"", instead of seperate cells for feet and inches. Short of copy/paste into a txt document and then re-importing...
Quote: Originally Posted by Orgetorix You are missing something. What's a normal knot? Long or short, vertically? Skinny or fat? How much tie space do your shirts have? Do you want your knot to fill it up? What knot do you tie most often? If you tie a four-in-hand, do you want it more symmetrical or severely asymmetrical? If you tie a Windsor, do you want it wider than it is tall, or the reverse? Do you want a dimple or not? A sharply creased...
Quote: Originally Posted by void143 Hello texquire, Сan you please re-post before and after pics? It's really hard to beleive for me that pair of shoes can survive more than a season. Maybe that's climate issue (Russia) or personal wearing habits (lack of any good habits at all). I had bad experience with several rather expensive fashion shoes (KENZO, Pollini, Lloyd, etc) but now I'm going to buy something from list Allen Edmonds, C&J, Alden,...
Recognize that I am on the aggressive side - but I keep 0.5% to 2% of my annual pre-tax income in the bank. I aggressively auto-debit the rest into various investments. I borrow from a personal credit line if I have a moderate crunch and liquidate in a bigger crunch. I would argue that this will force you to save more and spend less - but it is not a strategy for everyone. I have a good job and good job prospects (strong professional network including many that have...
New Posts  All Forums: