Description:
Microsoft Office Excel newsgroup.
|
|
|
Help with colour formula
|
| |
In column W row 2 I have a formula eg: =IF(AND(L2<=5,V2<=7.1),V2,"") copied down to row 1001 not every row has a result , lots of rows are blank . The numbers in column W need to be in red font L V W 2 6.6 22.4 3 0.4 18.3 4 2.0 9.7 5 6.8 0.2... more »
|
|
|
Cross Referencing
|
| |
Apologies if this seems a simple question, but I am at a bit of a loss on how to do it. I have two lists of people with a many to many relationship Group A work with number of people from Group B and the people from Group B can work with multiple members of Group A. How can I create a document using one list for Group A and Group B and... more »
|
|
|
Inserting symbol
|
| |
I'm trying to insert a symbol next to a number in a cell that is totaled. When I attempt this the number is not then recognized for the correct total. Do I need to change my SUM fx in some way to correct this?
|
|
|
trouble copying a cell from one workbook to a new one
|
| |
I can not copy a cell from one workbook to a new one. when I right click the cell on the first workbook and then open a new workbook, the paste is not highlighted and I can not copy. I have been able to do this all the time. For some reason, It will not allow me to do. I can copy within the workbook,... more »
|
|
|
attach files
|
| |
Hi to all Elite Group members some time queries and their solution posted here are not in good format , its little bit confusing I want to request all of you that please attach excel sheets with your queries and solutions,so that it can be very helpful to others in learning new things. please give your feed back... more »
|
|
|
Refresh - F2
|
| |
You are probably tired of this type of question, but here goes. Is there any way to quickly go through a spreadsheet with the F2 Enter (to refresh a cell) I have tried a Macro, as well as the copy and paste special with the Multiply which works for format dates etc. I want to refresh the blank cells that once had a formula, so it will not be... more »
|
|
|
Need to create rows from columns
|
| |
I have a spreadsheet that looks like this: Name | item 1 | item 2 | item 3 (etc.) I need to format it into: Name | item 1 Name | item 2 Name | item 3 Does anyone know how I can do that? Thank you - Pat
|
|
|
How can I automatically color a row based on cell content
|
| |
I'd like to automatically color code an entire row of a spreadsheet I'm creating based on the entry of a single cell. The cells with the entries are all in the same column in no particular order. Example, type in 'SS' turns the row red, 'ST' turns it green. Thank You Ed
|
|
|
Excel - IF formula with range of cells
|
| |
I am trying to create a formula that if a range of cells contains a specific value AND a range of cells in the next column contains a specific value, then the corresponding cells in the third column will be summed. What I have is below. It recognizes the formula as long as all the cells in the range of the... more »
|
|
|
Lookup or an alternative
|
| |
I have several sheets and I am trying to pull data from the master to the others, I have been trying to use the Lookup and IF function. But I cant get the right mix any help would be appreciated. EX. Col. 1 Col. 2 Col. 3 Job#'s Item#'s Dates 2556,2554 331 12/09/09... more »
|
|
|
|
