I need to define cusips in excel in an if/nested if statement Example Cell A1=005482J86 Cell A2=0162483G9 How do i use and if/or logic statement to make a...

How do I do this? Do I use IF and AND together??? thanks

Is this what you are looking for? =INDIRECT("K3") or =INDIRECT("R"&COLUMN()&"C3"), Ola...

I want to convert a row of financial data for individuals into a column. For example, convert: Name Jan 2/05 Jan 9/05 ...

I would like to create a formula in a cell that uses the value from another cell to compleat the formula. Formula in A1 =daily[value from A2)!c5 Where A2 is...

I have several columns of data. The most important being a client name and their last date of service. Can I pivot and pull the patient name and only grab...

I am a student. My original office 2003 professional edition did instal " data analysis "; I had installed " data analysis plus " from Keller's statistics...

Is there a way of adding up hours and minutes in excel?

In Conditional fromatting, is there any way for using the OR operator to check multiple conditions. -- Anisa

you guys are the most technical people i know, so i thought i would bring this to you. his is my problem: i have data in an excel sheet. its in a matrix and...

I am trying to use the drop down list one Excel2003 but doesn’t seam to work. My date is in another workbook and when I am trying to validate This...

I calculating "uptimes" of machines. If I have a 100 machines that can work 24 hours it means I have 2400 machine hours of productivity. I am not able to...

Need help with the following 2 situations involving data contained in 2 fields to create a “Yes� or “No� field according to the following: Situation...

I'm using Excell. I have a row of numbers, some of which repeat. I want to count how many unique numbers I have, thus eliminating duplicates. What formula and...

Today = Mar 20, 79th day in the year 2005. need simple function to calculate that for any given date in any given year.

i have two rows of numbers....i want to find the minimum value in the second row only of the columns that contain the maximum value in the top row???

you guys are the most technical people i know, so i thought i would bring this to you. his is my problem: i have data in an excel sheet. its in a matrix and...

Help! I need help with a formula. Driver schedules are assigned in a spreadsheet with dates on the vertical axis, and each driver's name in a column on the...

I help a school install new equipment when they get it. Yesterday I went in and installed a new computer that has MS Office 2003 installed on it. The old PC...

Dear All, I would like to know the back order status of item purchased. Sheet1 : about the purchase file contains fields such as PO#, PN, Qty Bought,...