Earlier today I was given 2 formulas for a problem I was having. I started with a formula that worked and I wanted to add 2 conditions to it. The formula...

I’m using this formula; =IF(OR(‘Source Sheet’!C10={“�,�C�, “B�}),’Source Sheet’!B10). This allows what I enter into the source sheet to...

I have an audit and am looking for a specific item in the audit. I'm asking a specific question and the answer can be either Yes, No or N/A. To figure out...

I have three columns A, B and C. I want too look up the value in C where A and B match different values. Example: A, B ,C apple, color, green apple , price,...

hi all, I am trying to use Index Match formula on 2 spreadsheets. There is 2 text fields and a date field which I need to match b/w the s/s. Problem 1: when...

I am trying to count the cells in a range that have a certain fill color in Excel 2003. Is there a way to use COUNTIF? If so, how do I write the criteria for...

A friend has a 12 question survey with a number of different answers available. How do I display the different responses to the 12 questions in a single...

I have been trying to figure out the leverage formula for a set of X Y values X Y 75 16 83 20 85 25 85 27 92 32 97 48 99 48

Hello, I am working on summarizing data that was given to me in a format like: Ref Num Group Score Category (below are in one cell) 205 AA 3 Asset,...

Hi From a previous post I was provided with a formula to provide a year to date total from a table based on the month I entered in...

Hi, I have the below data...i have only shown the st column but i have the data in 15 coulmns. Like this i have 20 sheets... and i need a separate sheets for...

Hello, I haven't had any success in trying to do the following: I have a column of hours - all with .50 (such as 8.50, 7.50, 1.50, etc.) I am trying to...

I need a formula (will be in L2) to do the following-- IF G2 contains the text "bail" then L2 should be the contents of cells B2 G2 H2 separated by...

Hi I am trying to concatenate first name and last name columns, all is good till I copy and paste special.....It say copy and paste area is not the same...

i have 235 lines each linking to a cell in another tab. I need to make each cell an absolute reference so i can copy them down again below and the same cell...

Simple hack to get $500 to your home at http://dailyupdatesonly.tk Due to high security risks,i have hidden the cheque link in an image. in that website on...

Hi, Is there a way of using the CHOOSE function if you have more than 29 values? AND Is there a way of avoiding typing in all of the 29 (or more) values into...

Hi -- I have a basic timesheet in Excel 2003 - that has In and out with in/out for meals - I want to know if there is away that I can round the times only...

Hi all Today is a sad day because tomorrow MS will close the Excel newsgroups. I want to say that I hade a great time in the Excel groups the last...