Let\'s say I have column A and Column B. Cells in Column A contain either \"Y\" or \"N\". How can I set the value of the cell in the corresponding row in Column B with a formula that detects if the ce
if a1 is bob, b1 is james, c1 is ricky, and d1 is a ssn#(123-45-6789), how do i combine the first character开发者_StackOverflowsos a1, b1, and c1 and the last four of the ssn so that it says bjr6789?=
In Excel开发者_运维知识库 we have the VLOOKUP function that looks for a value in a column in a table and then returns a value from a given column in that table if it finds something. If it doesn\'t, i
I have a column to which I am adding data from another column I would like to check whether that column has the data that I wish to add. Can you help me with a formula that will tell me whether a cer
I am looking for a simple function that will take anumber entered into a single cell say 20 and divide it evenly and randomly over three other cells, none of the values canbe 0.
In a cell in Excel sheet I have a Date value like: 01/01/2010 14:30:00 I want to convert that Date to Text and also want the Text to look exactly like Date. So a Date value of 01/01/2010 14:30:00 s
is there a way in Excel to have a formula that does something like this: = 12/20/2010 - 180 which would take a certain date (12/20/2010 in this cas开发者_如何学JAVAe) and subtract 180 days . .Assumi
I have a Excel spreadsheet and I have 3 columns. column A, column B, C开发者_运维问答olumn C. In column B if there is a value 1 then in Column C it should populate as True and if in column B value is
开发者_JS百科I have a moderately sized dataset in excel from which I wish to extract the maximum value of the values in Column B, but those that correspond only to cells in Column A that satisfy certa
竹林抚琴 夏婉安 专辑：竹林抚琴 语种：国语 流派：Pop 唱片公司：北京亿格艾科技有限公司
加载中,请稍侯......