2020年11月6日 · Good day Guys I am looking for a function or how to build a macro so that I can use the principles of The Pythagorean Theorem to give me the square not the length also lots of advice given the angle but I don't have the angle. Horizontal Distance (A) 12287mm I.E. How far I am standing from the building.

2024年12月11日 · Join Date 07-15-2010 Location The Great City of Manchester, NW England ;-) MS-Off Ver MSO 2007,2010,365 Posts 47,643

2024年12月18日 · Join Date 01-27-2010 Location Tysons Corner, VA, USA MS-Off Ver MS 365 Family 64-bit 2411 Posts 26,414

2024年10月30日 · The formula produces a list of unique 'items'. [Cat - Cat - Cat - Dog - Fish - Cat - Dog - Dog - Rat - Cat - Rat] becomes [Cat - Dog - Fish - Rat] But its very processor heavy. Takes a long time to calculate everything on the sheet. Is there a better way with formula to achieve that unique list?

2024年12月19日 · Join Date 09-10-2017 Location Chippenham, England MS-Off Ver 365 Posts 15,665

2005年9月30日 · I frequently run into the problem where I type a formula in one cell and it doesn't work (all I see is the text of the formula in the cell), yet I can type the exact same formula in a different cell on the same spreadsheet and get it to calculate. For example - I'm trying to use this formula (where XA:XZ represents any random range):

2012年11月4日 · Join Date 06-23-2007 Location London,England MS-Off Ver office 97 ,2007 Posts 19,320

2013年4月4日 · I need to add the multiple results to get an sum of all of them. Column C1 is the start date. Column C2 is the finish date. Column C3 is a separate start date. Column C4 is a separate finish date. I used the following formula to get the month/day count for each separate start/finish dates: =DATEDIF(C1,C2,"M")&"M"&DATEDIF(C1,C2,"MD")&"D"

2012年7月25日 · Join Date 12-10-2010 Location Va, USA MS-Off Ver Excel 2003, Excel 2010 Posts 606

2006年7月28日 · appearing anywhere within a formula and potentially more than once requires complext parsing algorithms. The tricky part is finding the balancing right parenthesis as well as the 2nd parameter, both of which must eliminated along with "round(". (But perhaps someone has one already written such a macro.)