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: Hi, As I mentioned an alternative and more specific approach is to use a Macro. The following code can be attached to a command button on your summary...
Summary: Yes, Outlook via Office 2003 I utlize for email and all is working well. Plus I also am able to utilize word etc. The only tool it appears not to all...
Summary: Hi, If you post the details someone will likely give you some code to get you started. Information required. 1. How many source workbooks. 2. What are...
Summary: While this question might get better responses in the General Hardware forum or the forum for your OS, I will offer this: If you did not save a copy o...
Summary: Hi, If this sorting by date is not done very often then I suggest using Excel's Sort function manually. For sort to work, all the data for each indivi...
Summary: Good day! I've asked this elsewhere, but I hope I'll find help here too. I don't know how to backup my computers(37) and shared storage (30TB for now)...
Summary: I have an Adobe question...I have a user who inputted a PDF file online and turned it into a link. When she adds it into a email campaign software an...
Summary: Hi, You could try Excel's database functions such as DCOUNT() and DSUM() These allow you to setup various criteria (like filters) for a database and e...
Summary: Hi, You haven't said what values are in column B, but as you are using COUNT() which counts the number of cells containing a number (Excel help states...
Summary: Hi, Your original sample data indicated that there was a single selection, with alternate rows to be inserted. The code I provided will not work on m...
Summary: Hi, I have a macro that will change links in a Word document, so that you can get the 'same' data but from a different Excel workbook. But - due to th...
Summary: Hi, You didn't mention searching for a cell with an error value before! Excel has a function that returns TRUE if the cell contains an error: If cell ...
Summary: This is for my MacBook (laptop) OS X 10.4.11. Never a problem with my iPod for the last few years. It's be awesome. iTunes has been awesome. 1) But I...
Summary: I have an Adobe question...I have a user who inputted a PDF file online and turned it into a link. When she adds it into a email campaign software and...
Summary: Hi, The solution I offered in response #1 will do this for you, giving you =A5 in C1 and =A25 in C2 and A45 in C3 and so on. It's not a single step ...
Summary: Hi Humar, I think I have wrongly described what I need. Now I have extracted all the categories and companies in a excel file. There are total of 17 u...
Summary: Hi, Here is an example of a field code (a formula in this case) with a numeric format applied: {=9*1000000 \# #,000} which looks like this when you to...
Summary: God bless you guys for the help, I appreciate it. These are IRC chat logs are for D&D roleplaying sessions. Chat that is in parentheses, either doub...
Summary: Even if not made for Windows XP, it installs and works fine there. For printing, disable background printing: Launch Ami Pro, then type alt-L, alt-U, ...
Summary: Hi, I need to switch between 2 open excel worksheets and copy data from one to another. I cannot use the file names to say which one I want to switch ...
Summary: Hi, This option uses a User Defined Function, written in Visual Basic. The cells containing the time must be formatted as Text. Before entering any ti...
Summary: Hi Cayo, I followed up on DerbyDad03's comments and added code to catch USD on its own, as well as numbers with decimals such as 10.50 USD. I know tha...
Summary: Hi, You should be able to do this with standard formulas, with no need for macros. The VLOOKUP() function allows you to lookup a value (the lookup val...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
