Hi everyone! I'm trying to program a new excel function that I need for my job (I'm a biomedical scientist at UCL London), but I got stuck with...

Hi guys! An other question for you. I would like to create a new UDF with VBA which could allow me to determine the rank of a number within an array. I...

Thanks for all the suggestions! Now I have an other question... I have my usual option-based-1 array1 in VBA, which contains x numbers. Some of them are...

Bharnick, Try =A1&COUNTIF($A$1:A1,A1) in cell D1 and copy down. If you insert a row, you have (offcourse) to copy this formula to the cell in column D in...

Alby, In stead of another IF statement you can use the MAX() function. Max(a,b) returns the larger of the two arguments. So try...

Kiser, A "direct" calculation (without iteration) of the FINAL should be possible with the NPV function at 25% of all the payments, excluding the...

Just locate the file Personal.xls then (probably in a directory (startup or xlstart) under the Excel path) and delete the file. If you can't find it direct,...

=Sheetx!$A$5+Sheety!$B4+Sheetz!$B$7 You can type the formula in or just build it up by pointing enter (in the cell where the formula is to be buid up) = ;...

George, Sorry, I still don't understand you. In my calculations 6.75% / 9.75 * 0.15 = 10% tather then 27%. However I still think that you migth need the Min...

Mike, Change the formula's in the cells that depend on that one (still) empty data cell (lets assume that that cell is A1) from : Your Formula to ...

Peta, Assuming your date 21/01/2004 is in cell A1 in cell A2 just use =A1+1 In Excel a date is just a number (1-1-1900 =1 ; 2-1-1900 =2 etc.) so you can do...

Got column with thousands of cells containg different codes, e.g., cell P357 -- {X, A, B2, T83, M19}; cell P425 -- {T83, A, X, M19, B2}, etc ... Need a...

I have a column w/ a #, there are about 1,000 columns, the #s range from 1 - 15788. Lets say we are working in column A & we have the following data. A1 -...

Does anyone know of a way to verify that a row number being used within calculations of 2 separate cells is the same? Example: Cells B31 and C31 both...

Is it possible to conditionally format based on the selection from a drop down list. The drop down list has a choice of 18 different status, the user will...

I've just begun using =randbetween, bear with me! I am trying to come up with a random number from a set of about 100 cells. The only numbers available in...

I need to set up a function if possible to display what the date will be 24 days later. I need to spread out my reviews to be every 24 days - I would like to...

I need to calculate two columns of time. Most entries fall within the same day's 24 hour limit, so a simple forumla "=b1-a1" will do. But a few in the 2nd...

I have an excel ws with information divided into columns (Name, address, phone, e-mail, etc...)--how do I alphabetize the names (rows) while still keeping...

I'm trying to convert a text file with multiple rows (10) of repeated data. The "Text to Columns" function in Excel can only sort one row. Is there a way in...