The search for a formula to add a number to a list box number/letter combo.

Office

Question:I work with buildings of various sizes and create spreadsheets for rooms with. Instead of typing in hand is there a more easy way to get the same result?i.e.(101 A A1)(102 A A2)(103 A A3)Answer:A1 = "10" ROW() & "A".Drag/copy to the bottom as you want.GordRead More

Posted: 27 Apr 2012

Tags: The search for a formula to add a number to a list box numberletter combo The search for formula add number list box numberletter combo

disable the calculations of formulas in cells

Mac

Question:Is there a way to disable these calculations to cell in cells?For example: I would like to just have the text in a cell: = priorityIt provides a replacement with a sort of code, it thinks I want.Help!Answer:Yes. Type a single quote as the first character to indicate to Excel to process the input as text instead of a formula' = priorityRead More

Posted: 17 Apr 2012

Tags: disable the calculations of formulas in cells disable the calculations formulas cells

formulas

Office

Question:Anybody else difficulty with formulas - to function properly when copying in adjacent cells?The formula is copy correctly but not the function. I'm having to retype each formula in each cell individually.Even then, when a change, a number is a cell, the formula does not recalculate using the modified information.It is on a computer. It is the computer or is it the program?I tried to drag...Read More

Posted: 16 Apr 2012

Tags: formulas

If the formula for the average - which should I use?

Office

I am trying to show the average mark of the different scores written in 4-cell; I used the formula = average(c2:c5) the results I want C6. However, it must change the If formula, so that 0 is displayed in c6, if one of the 4 cells empty. I know not how to make it. Any help much appreciated:).... I realize that I perhaps should an average C6 result if any of the 4 cells have a score in them and that...Read More

Posted: 11 Apr 2012

Tags: If the formula for the average which should I use the formula for average which should use

match formula does not

Office

Question:I have a large spreadsheet (about 1 000 rows and columns A - T). It lists the various projects and related project information. The problem is that each project has multiple lines because the different classes of membership team (Chief, finance, mentor, etc) are each on a separate line. I am consolidating by a column for each Member of the team. Thus, il would be the project ID, Name, economies...Read More

Posted: 09 Apr 2012

Tags: match formula does not match formula does not