Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.
I have a table in Excel that looks like this: Column AColumn B Header Desc 1Value1 开发者_如何学JAVADesc 2Value2
I am trying take an ID in ColumnX and verify find an occurrence of this ID in columnY using the MATCH() function. This function returns a row number of the match. I now need to take the row number and
I\'m trying to use a function to count the number of unique cells in a spreadsheet that, at the same time, meet multiple criteria.
How do I Make a range of Cells to Zero If a calculation gi开发者_Go百科ves A Negative Number? Example: =D12-D19
How can I convert 20110114 (YYYYMMDD) to开发者_JAVA百科 week, eg WK02-11, in excel ? Thanks.First convert the number in a date. Supposing your number is in A1 cell
Can someone explain to me the PMT formula开发者_如何学运维 in excel? =-PMT ( 1)rate 2)nper 3)pv 4)[FV]
The following percentage are the occurence probability. How do I represent these values in excel. 35% No one buys Coffee Zing
Folks, I have a string date which I can convert to numeric using: =DateValue(\"1/2/2011\") results in 39084
Is it possible to iterate (loop) a group of rows in Excel without VBA or macros installed? A web search didn\'t yield anything helpful.
加载中,请稍侯......