Registration date
July 28, 2004
Contributions
24
Gender
Male
Birthdate
May 15, 1980
Location
grenoble, FRANCE
Signature
On entend par une belle solution, la solution simple et facile d'un problème difficile et compliqué

formula or else ??? [Solved]

Hello, I have a range of cells B5:AC5 containing each a letter from a name, ex: DAVID THOMAS SMITH So B5=D, C5=A, D5=V, E5=I, F5=D..and so on up to the end of the name. In cell B22 I need it to check the range B5:AC5 if it has one "A" or more and if it does, write "A" in cell B22, if no "A" then leave B22 blank. In cell B23 I need it ... Read more

:)

Need to sum Coumn F only when B & C identical [Solved]

Hello, I am trying to set up a formula that will allow me to get the average of values in F, but only for the rows where both Coumn B & C are identical. I have Column A set to be a conditional "start of like data" and use an "x" in the first row of identical samples. So, I know I can do an =if(a5="x", ...,"") to leave the value blank... Read more

return data from one spreadsheet to another

Hello, I have a workbook with 3 spreadsheets. Spreadsheet 1 is for data entry. The spreadsheet has 3 columns, Description, Income, Expenses. On spread sheet 2, I need to bring in ONLY the income and description from Spreadsheet 1. In spreadsheet 1, income and expenses can be on any row. So row 1 and 2 may have income, row 3-... Read more

VB script for error text box

Hello, Can some one please help before my head explodes. I need a script to look at a range and if the cell contains a "0" then flash up a warning box. I can get it to work for one cell with the syntax below but cannot get it to work for a range of cells. I am a complete novice. Thanks Read more

countif with and function

Hello, I am trying to count cells in a column if they are greater than 60 and less than 29. How can this be done with a countif and function? Thanks! Julie

excell calculations

Hello, I am a programmer and not use to restrictions when calculating formulas. I would like to know if there is a way to calculate a number and place the result back in the same cell. EX (A1+B1=A1) the formula would be in A1.