Registration date
July 28, 2004
May 15, 1980
grenoble, FRANCE
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.