vice

I'm trying to make a custom sort based on a contact's management level. Basically sort by their title. So the list would sort something like this: Owner, CEO, President, Vice President, CFO,etc... The list works fine when the title is exactly as in the custom list. But if the title is a...

Age is a terrible thing!! Can't remember the command for = ("abc",1,"def",2,"ghi", 3) the number returns the corresponding string (or maybe vice versa). Can anyone help? Thanks.

I need an Excel formula that will calculate the following: If J6 is greater than 100, then it will calculate the amount in L6 but if it is equal to or less than 100, then it will calculate the amount in K6 and J6 will show a zero and vice versa.

Hi, I am looking for formula that match keyword in from 2 files. File1: <colgroup><col></colgroup><tbody> Keywords Exclude intern accountant accounting admin advertising advisor analyst architect assistant to vice president assistant to vp Attorney auditor Author...

Here is an old problem and I wonder if anyone has found a solution for it. I sometimes have to reconcile two columns of items, different lengths, and some of the items on column A might not be on column B and some of the items in column B might not be in column A. How do you find the ones that...

Hi I am trying to set up a simple system to track equipment availability I want to place a number of command buttons on a screen which will change colour (green to red and vice versa) and change caption (UP to DOWN and vice versa) every time the button is clicked I also need to timestamp every...