excel-formula
Excel VBA - 1004 run-time error, Application or object-defined error
I\'m trying to go through a range of cells in a worksheet and write a formula in each one. But I keep getting the error:[详细]
2023-03-19 06:51 分类:问答Transforming a sheet of unique strings to a new sheet with the values
Basically he has a system that generates a report as one excel file containing only one column and several rows for each register. He wants to use the data of that report for new reports and here is m[详细]
2023-03-19 02:43 分类:问答How to use CELL function inside OFFSET function?
I am trying below formula: OFFSET(CELL(\"address\"), 0, -2, 1, 1) Instead this works: OFFSET($P$20开发者_如何学JAVA, 0, -2, 1, 1)[详细]
2023-03-17 04:39 分类:问答Excel Index vs Offset/Indirect - I don't understand why Offset/Indirect is faster in this case
I have a workbook set up where the first tab contains a list of parameters. Each column is a set of parameters for a different instance.[详细]
2023-03-16 04:23 分类:问答Convert (heavily formula-loaded) Excel spreadsheet to user-friendly web calculator
I need to create a webtool that takes several input values and generates a number of outputs based on complex sequences of arithmetic calculations in an Excel workbook. I am thinking of hard-coding th[详细]
2023-03-13 06:25 分类:问答Macro to split weight into columns Request
Let\'s say I have a column of numbers in A2 going down, to a random number, such as: 0.50 1.00 1.00 1.10 1.10[详细]
2023-03-12 00:32 分类:问答Calling an Excel formula from server-side Ruby web application
My customer has a coded a function that takes 20 boolean values and comes up with an integer result. They did it with Excel, as a complex formula.[详细]
2023-03-10 18:21 分类:问答Nesting IF statements in Excel 2010
How do I nest IF statements in Excel 2010? I found my inspiration trying to organize data from Evolus Pencil Support Tickets.[详细]
2023-03-10 00:12 分类:问答Extract the last substring from a cell
I have names in a column.I need to split just the last names from that column into another column. The last name is delimited by a space from the right side.[详细]
2023-03-08 05:56 分类:问答VLookup if Lookup Value Located in Column to the Right of Table Array
I have a spreadsheet 开发者_如何学Goset up, and it already contains a lot of data. The A column holds date objects and column B holds numerical values. I want to use Vlookup to find the numerical valu[详细]
2023-03-01 02:16 分类:问答