modified

I have a file on our One Drive, is there a way I can receive an automatic email when that spreadsheet is modified? Thank you,

I am trying to make a formula in cell D22 that will add D23 + D32 + D41 + D50 + ect. I found a thread that explained how to do this I though but when I modified to formula I couldn't get it to work properly. Original Thread...

In Sheet 1 I have columns: Roll Num Name Marks In Sheet 2, I need the same details to appear, but with the records in descending order of Marks. In future, when more records are added in Sheet 1 or any records are modified or deleted, I want the table in Sheet 2 to be automatically updated...

Hi All, Is there away to auto fill a last modified date and user on a sheet/workbook, I was hoping there would be something equivalent to Word's Quick Parts? Relying on users to enter the date when they make changes isn't proving very reliable nor can I rely on users to check the file/info to...

Currently I am working on a document in google sheets with several tabs. "SS", "Math", "Sci", ... and I have a formula I am working on in a separate tab.... =iferror(if(A2="","",index(SS!D:D,match(A2&$B$1,SS!E:E&SS!G:G,0)))) ^ I am wondering if the "SS!D:D" piece...

I have been using the following to sum the number of valuesin a list without counting the same value twice and ignoring any cells wherethere is no data. =SUMPRODUCT(($V$17:$V$40<>"")/COUNTIF($V$17:$V$40,$V$17:$V$40&"")) This works fine, but in some cells I could have errors ie#VALUE! and...

Hi All I have an ODBC datasource which I need to use with MS Query There is a field called 'modified date' which contains 1000's of records. I need to make the query return only records that are 15 days or greater since last modified The 'modified date' field cannot be changed as it is on an...

Hi Friends, I wanted to know how can we get last modified time for a cell besides that cell using excel formula. For eg: If you have some data in cell A1 ... You make changes to this cell A1 and I want to get the time at which this change was made in cell B1 using excel formulas.

I need to have my formula below modified. =COUNTIF(Portal_Loans[Date Assigned],"<"&TODAY()-60) This will give me to total amount of dates in the Portal_Loans[Date Assigned] column, but I ONLY want to count the dates in this column if in Portal_Loans[Date Finalized] is blank. Basically, I want...

I don't like the look of the default action when selecting a cell or cells which is to draw a heavy border around it/them. Can this default behavior be changed for the entire application? (as opposed to a single workbook) For example, I would like cell borders to NOT be modified from their...

In Col A, I have time.. 6/14/2017 6:22:23 AM In Col B, I use Hour formula to get Hour.. =HOUR(A2) I got the answer.."6" ................................... Then I need AM & PM in Value..So modified formula like below.. Col C new formula =IF(MOD(A2,1)>0.5,"PM","AM") Col B then modified...

Dear All, I have a huge problem with how to refresh only modified files or new files in folder? The situation is as follows: I have a folder where different peopel store the files (more than 1500, all files have the same structure) and when I import data using PQ it takes ages because it...

I am using Microsoft Excel 2010; 32 bit I have a workbook query set up through Power Query that returns a table (24 columns, 12,000+ rows). It is a web connection to a DB2 (authentication required). I have it set up so that the first column is the modified date (date and time stamp). The table...

I have an archive directory which is used to store files for each case that i work on. Each case has a Folder with Name and ref attached and several files inside word and xls. I have a created a tool which generates the letters / Forms and saves them in the requisite folder for each case. I...

Hello. I'm brand new to the forum and have been "lurking" for a solution to my problem for a while. This subject has been discussed to a certain degree on other threads and I'm sorry if I'm reopening old wounds. I have a worksheet that my company uses as a form. On that form, there are...

I'm not sure how to do this, but I have an imported file from text, and I need to make sure that the last modified date isn't older then 5days and if it is I need some text box that says "file too old" or something like that.

We have a Excel spreadsheet to control and manage our company archive, only certain people have permission to edit and add to the spreadsheet across the company and I'm currently in the process of upgrading this to give us more visibility. I'm after a way to show in cell A2 the date the...

Hey guys, I've been trying to compute the mduration and duration function in excel. However, we are not allowed to use MDURATION or DURATION according to the lecturer. We have input variables: face value, coupon %, maturity(years), current price, yield.When any of those variables change, our...

ActiveSheet.Charts(InputBox("Chart name?")).ChartTitle.Text = "chart title" hello everybody in this case i try to but the name of chart i already have it in excel and change the title of chart but the :eeek: don't work any idea

I'm trying to find a way to get a "modified date" or "saved date" automatically entered into a cell in a worksheet, but I can't figure this out. I've seen numerous websites give VB code to do this, but I must be doing something wrong because a date never appears in the cell I select. I'm using...