Summary: Hi, I have a solution for this issue. I have tested it on the sample data you provided, plus one extra to cover a transition from Low to High season...
Summary: Hi, Here is a way to break a rank tie, based on the values in a different (in this case the AA) column. The sample results below can be repeated with ...
Summary: I have a table in excel with some calculated figures. I use the function to round the figures to 2 decimal places. However, when I merge the figures...
Summary: Hi, I don't write a lot of Macros for Word, so I am not sure how robust this is. Give it a try, but make sure you always have a backup! (or two). Thi...
Summary: I am trying to figure out how to change the language of Office 2007. Here is the setup All desktops/laptops are XP They are running Office 2007 The de...
Summary: How can i display a number in Word 2000 automatically in comma separator format, example: 220,999.00. Suppose i merge my data into Word 2000, i want t...
Summary: I'm looking to batch process some text chat logs, essentially performing some repetitive functions and saving me some time and headache. The text I wa...
Summary: In this forum, we don't usually answer homework questions directly, since the object is for you to figure how to use Excel to complete the assignment....
Summary: Hey All I hear you guys are pretty good. I need help with an excell chart being imported into a word document. I inserted it as an object and ticked t...
Summary: I hope someone can help me as I am getting desperate. I have an Access database that builds data in a table and then call MS Word and opens a document...
Summary: I have an Excel 2007 document with values on one sheet that I need to insert into an existing Word 2007 document into different places. I would like t...
Summary: i want to convert excel sheet in word with the use of mail merge in envelope ,because i have come 28000 record daily so i convert in easy step or...
Summary: I have 2 files of several thousand CDs. The first has everything listed (about 5,000 lines), the second has several thousand titles less (about 3,500 ...
Summary: I can't open some files that have been saved in an odd format using Word 2007. Looks like:~$pt 2 2009. Usually save all to Word 2007 but obviously go...
Summary: I have an excel list. There are different categories of business types. total of 17 different category. Problem is that most of the categories have fe...
Summary: I want to display my numbers in Word 2000 formula result in a different way: Example: 10,00,00,000.00 that is the commas should come after every 2 di...
Summary: Hi Guys - Is it possible to utilise the indirect function or a means using VBA to populate the listfill range of a combobox - this is also referred to...
Summary: I cannot use Macro that i record before Before I was create new macro in Ms word. Then I close Ms word. When I open Ms word again i cannot use Macro. ...
Summary: I need to take time from a stopwatch (00:00:00 = min:sec:hundreths) and divide it into an hour. Cell F8 (load time - 04:56:10), Cell F10 (run time - ...
Summary: Is it possible to search appointments by category in Microsoft Outlook 2007? For example, if I wanted to find all appointments on a calendar that are ...
Summary: I have a user who was using Outlook 2003 on Windows XP SP3. She has some distribution lists (DL) in her Contacts folder with a lot of entries. Most ...
Summary: When Entering Certain Websites, Such As The Gimp Website, It Asks for The Microsoft Office 2000 Premium Install CD. I Have A HP Pavilion 512n, Office ...
Summary: Hi, I need to calculate how many times 2 specific characters appear in the same cell throughout an entire spreadsheet of about 98 columns and 98 rows,...
Summary: OK- thanks for the posting tip - first time user mistake. The version is Microsoft Office Professional Plus 2007 Here is the example: one workbook, ...