excel-formula
Column variables in Excel?
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[详细]
2023-01-02 01:51 分类：问答Excel: How do I take the first character of 3 different cells and last 4 numbers of 1 cell and combine them?
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?=[详细]
2023-01-01 22:16 分类：问答Excel: VLOOKUP that returns true or false?
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[详细]
2022-12-31 13:05 分类：问答Return values only if they are not present in current column
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[详细]
2022-12-30 13:26 分类：问答Simple Excel function that splits a numbered entered into one cell randomy and evenly over 3 others
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.[详细]
2022-12-29 11:18 分类：问答Excel Date to String conversion
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[详细]
2022-12-27 08:17 分类：问答excel formula to subtract number of days from a date
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[详细]
2022-12-26 01:29 分类：问答Populate a value in MS Excel
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[详细]
2022-12-26 01:28 分类：问答Excel MAXIF function or emulation?
开发者_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[详细]
2022-12-24 20:21 分类：问答
![Interactive visualization of a graph in python [closed]](https://www.devze.com/res/2023/04-10/09/92d32fe8c0d22fb96bd6f6e8b7d1f457.gif)
加载中,请稍侯......