Tag Info

Hot answers tagged

5

You are correct, Excel 2013 has the FORMULATEXT function which shows the formula as text. Since Excel 2010 does not have this feature, there are a couple ways you can show formulas without VBA; By pressing Ctrl + ` (that's the tilde key above the Tab). This one shows all formulas in the sheet. You can place a space it the cell before the =. This causes ...


2

The full path to the root User folder of the currently logged-in user can be retrieved with: Environ("USERPROFILE") To save the file to the user's desktop, like you've done, you would use: Environ("USERPROFILE") & "\Desktop\" & ... For your specific code as provided ActiveSheet.ExportAsFixedFormat _ Type:=xlTypePDF, _ ...


1

This is the connection string (SQLServer 2012 / Excel 2013): Server=(LocalDB)\MSSQLLocalDB; Integrated Security=true ;AttachDbFileName={mdf file full path} Oh on my PC, I had to use ;Trusted_Connection=Yes, it might not make any sense, since both my laptop and PC are running the EXACT same versions of SQLServer and Excel. Edit I can't reproduce the error ...


1

Since you only need values found in both columns, you only need to search one column for each value found in the other column. To do this, you could use the following formula in cell C1: =IF(ISERROR(MATCH(B1, A:A, 0)), "", B1) Then copy-paste C1 down until the end of column B. This would display the value of the cell in column B if the same value is ...


1

For dates in cells A1:A25 and profit values in cells B1:B25 you can use the following formula: =SUM(B2:B25)/SUMPRODUCT(--(FREQUENCY(A2:A25,A2:A25)>0)) Result as shown: When you have more than 25 rows of data you'll need to adjust the formula ranges appropriately. The formula calculates as follows: (Total profit)/ (number of different dates) EDIT ...



Only top voted, non community-wiki answers of a minimum length are eligible