This short tutorial explains the basics of an external reference in Excel, and shows how to reference another sheet and workbook in your formulas.
When calculating data in Excel, you may often find yourself in a situation when you need to pull data from another worksheet or even from a different Excel file. Can you do that? Of course, you can. You just need to create a link between the worksheets (within the same workbook or in different workbooks) by using what is called an external cell reference or a link.
External reference in Excel is a reference to a cell or a range of cells outside the current worksheet. The main benefit of using an Excel external reference is that whenever the referenced cell(s) in another worksheet changes, the value returned by the external cell reference is automatically updated.
Although external references in Excel are very similar to cell references, there are a few important differences. In this tutorial, we'll start with the basics and show how to create various external reference types with detailed steps, screenshots and formula examples.
How to reference another sheet in Excel
To reference a cell or range of cells in another worksheet in the same workbook, put the worksheet name followed by an exclamation mark (!) before the cell address.
In other words, in an Excel reference to another worksheet, you use the following format:
Reference to an individual cell:
For example, to refer to cell A1 in Sheet2, you type Sheet2!A1.
Reference to a range of cells:
For example, to refer to cells A1:A10 in Sheet2, you type Sheet2!A1:A10.
Note. If the worksheet name includes spaces or non-alphabetical characters, you must enclose it in single quotation marks. For example, an external reference to cell A1 in a worksheet named Project Milestones should read as follows: 'Project Milestones'!A1.
In a real-life formula, which multiplies the value in cell A1 in 'Project Milestones' sheet by 10, an Excel sheet reference looks like this:
='Project Milestones'!A1*10
Creating a reference to another sheet in Excel
When writing a formula that refers to cells in another worksheet, you can of course type that other sheet name followed by an exclamation point and a cell reference manually, but this would be a slow and error-prone way.
A better way is point to the cell(s) in another sheet that you want the formula to refer to, and let Excel take care of the correct syntax of your sheet reference. To have Excel insert a reference to another sheet in your formula, do the following:
- Start typing a formula either in a destination cell or in the formula bar.
- When it comes to adding a reference to another worksheet, switch to that sheet and select a cell or a range of cells you want to refer to.
- Finish typing the formula and press the Enter key to complete it.
For example, if you have a list of sales figures in sheet Sales and you want to calculate the Value Added Tax (19%) for each product in another sheet named VAT, proceed in the following way:
- Start typing the formula =19%* in cell B2 on sheet VAT.
- Switch to sheet Sales, and click on cell B2 there. Excel will immediately insert an external reference to that cell, as shown in the following screenshot:
- Press Enter to complete the formula.
Note. When adding an Excel reference to another sheet using the above method, by default Microsoft Excel adds a relative reference (with no $ sign). So, in the above example, you can just copy the formula to other cells in column B on sheet VAT, the cell references will adjust for each row, and you will have VAT for each product correctly calculated.
In a similar manner, you can reference a range of cells in another sheet. The only difference is that you select multiple cells on the source worksheet. For example, to find out the total of sales in cells B2:B5 on sheet Sales, you would enter the following formula:
=SUM(Sales!B2:B5)
This is how you reference another sheet in Excel. And now, let's see how you can refer to cells from a different workbook.
How to reference another workbook in Excel
In Microsoft Excel formulas, external references to another workbook are displayed in two ways, depending on whether the source workbook is open or closed.
External reference to an open workbook
When the source workbook is open, an Excel external reference includes the workbook name in square brackets (including the file extension), followed by the sheet name, exclamation point (!), and the referenced cell or a range of cells. In other words, you use the following reference format for an open workbook reference:
For example, here's an external reference to cells B2:B5 on sheet Jan in the workbook named Sales.xlsx:
[Sales.xlsx]Jan!B2:B5
If you want, say, to calculate the sum of those cells, the formula with the workbook reference would look as follows:
=SUM([Sales.xlsx]Jan!B2:B5)
External reference to a closed workbook
When you reference another workbook in Excel, that other workbook does not necessarily need to be open. If the source workbook is closed, you must add the entire path to your external reference.
For example, to add up cells B2:B5 in the Jan sheet from Sales.xlsx workbook that resides within the Reports folder on drive D, you write the following formula:
=SUM(D:\Reports\[Sales.xlsx]Jan!B2:B5)
Here's a breakdown of the reference parts:
- File Path. It points to the drive and directory in which your Excel file is stored (D:\Reports\ in this example).
- Workbook Name. It includes the file extension (.xlsx, .xls, or .xslm) and is always enclosed in square brackets, like [Sales.xlsx] in the above formula.
- Sheet Name. This part of the Excel external reference includes the sheet name followed by an exclamation point where the referenced cell(s) is located (Jan! in this example).
- Cell Reference. It points to the actual cell or a range of cells referenced in your formula.
If you've created an reference to another workbook when that workbook was open, and after that you closed the source workbook, your external workbook reference will get updated automatically to include the entire path.
Note. If either the workbook name or sheet name, or both, include spaces or any non-alphabetical characters, you must enclose the path in single quotation marks. For example:
=SUM('[Year budget.xlsx]Jan'!B2:B5)
=SUM('[Sales.xlsx]Jan sales'!B2:B5)
=SUM('D:\Reports\[Sales.xlsx]Jan sales'!B2:B5)
Making a reference to another workbook in Excel
As is the case with creating an Excel formula that references another sheet, you don't have to type a reference to a different workbook manually. Just switch to the other workbook when entering your formula, and select a cell or a range of cells you want to refer to. Microsoft Excel will take care of the rest:
Notes:
- When creating a reference to another workbook by selecting the cell(s) in it, Excel always inserts absolute cell references. If you intend to copy the newly created formula to other cells, be sure to remove the dollar sign ($) from the cell references to turn them into relative or mixed references, depending on your purposes.
- If selecting a cell or range in the referenced workbook does not automatically create a reference in the formula, most likely the two files are open in different instances of Excel. To check this, open Task Manager and see how many Microsoft Excel instances are running. If more than one, expand each instance to view which files are nested there. To fix the issue, close one file (and instance), and then open it again from the other file.
Reference to a defined name in the same or another workbook
To make an Excel external reference more compact, you can create a defined name in the source sheet, and then refer to that name from another sheet that resides in the same workbook or in a different workbook.
Creating a name in Excel
To create a name in Excel, select all the cells you want to include, and then either go to the Formulas tab > Defined names group and click the Define name button, or press Ctrl + F3 and click New.
In the New Name dialog, type any name you want (remember that spaces are not allowed in Excel names), and check if the correct range is displayed in the Refers to field.
For example, this is how we create a name (Jan_sales) for cells B2:B5 in Jan sheet:
Once the name is created, you are free to use it in your external references in Excel. The format of such references is much simpler than the format of an Excel sheet reference and workbook reference discussed earlier, which makes the formulas with name references easier to comprehend.
Note. By default, Excel names are created for the workbook level, please notice the Scope field in the screenshot above. But you can also make a specific worksheet level name by choosing a corresponding sheet from the Scope drop-down list. For Excel references, the scope of a name is very important because it determines the location within which the name is recognized.
It's recommended that you always create workbook-level names (unless you have a specific reason not to), because they significantly simplify creating Excel external references, as illustrated in the following examples.
Referencing a name in another sheet in the same workbook
To reference a global workbook-level name in the same workbook, you simply type that name in a function's argument:
For example, to find the sum of all the cells within the Jan_sales name that we created a moment ago, use the following formula:
=SUM(Jan_sales)
To reference a local worksheet-level name in another sheet within the same workbook, you need to precede the name with the sheet name followed by an exclamation mark:
=Function(Sheet_name!name)
For example:
=SUM(Jan!Jan_sales)
If the sheet names includes spaces or mon-alphabetic chars, remember to enclose it in single quotes, e.g.:
=SUM('Jan report'!Jan_Sales)
Referencing a name in another workbook
A reference to a workbook-level name in a different workbook consists of the workbook name (including the extension) followed by an exclamation point, and the defined name (named range):
For example:
=SUM(Sales.xlsx!Jan_sales)
To reference a worksheet-level name in another workbook, the sheet name followed by the exclamation point should be included as well, and the workbook name should be enclosed in square brackets. For example:
=SUM([Sales.xlsx]Jan!Jan_sales)
When referencing a named range in a closed workbook, remember to include the full path to your Excel file, for example:
=SUM('C:\Documents\Sales.xlsx'!Jan_sales)
How to create an Excel name reference
If you have created a handful of different names in your Excel sheets, you don't need to remember all those names by heart. To insert an Excel name reference in a formula, perform the following steps:
- Select the destination cell, enter the equal sign (=) and start typing your formula or calculation.
- When it comes to the part where you need to insert an Excel name reference, do one of the following:
- If you are referring to a workbook-level name from another workbook, switch to that workbook. If the name resides in another sheet within the same workbook, skip this step.
- If you are making a reference to a worksheet-level name, navigate to that specific sheet either in the current or different workbook.
- Press F3 to open the Past Name dialog window, select the name you want to refer to, and click OK.
- Finish typing your formula or calculation and press the Enter key.
Now that you know how to create an external reference in Excel, you can take a benefit from this great ability and use data from other worksheets and workbooks in your calculations. I thank you for reading and look forward to seeing you on our blog next week!
358 comments
I have a drop down box with several items in it, and when I click on a specific item, I am wanting it to recognize a number in the cell below it . What is the best way to do that?
having troubles with cell reference's. Referencing a different sheet with ='Wine Data'!A6. no matter what
formatting I apply to either cell all I get is the formula displaying. Other cell references are working fine until I copy the formula and paste into another cell. Then the cell I copied will display the formula instead of the referenced cell.
Hi,
Perhaps the first character in this cell is not =, but a space or '
Hi,
How can I use the same range in different formulas withing selecting every time/copying it?
For Example:
=STDEV.P(D4535:D4562)
=MAX(D4535:D4562)
=MIN(D4535:D4562)
=AVERAGE(D4535:D4562)
I want to select the range for the first one only & want to see the rest of the formula's picked range automatically.
Hello,
I'm trying to reference another workbook cell within box
Is this possible?
Here is what I'm trying to do.
='[https://app.box.com/s/4fcfdd2b25lyps2p46khzydj6maoejvv]Sheet1'!A1
Is it not possible to reference other workbooks from within box? Does it have to be a local file for this work?
Much appreciated!
Hello!
To create a link to a file on the Internet, use the menu Insert - Link - Browsed Pages.
You can also use the HYPERLINK function, for example:
=HYPERLINK("[https://example.com/report/file.xls]Sheet1!A10", D1)
You can learn more about HYPERLINK in this articles: How to add a hyperlink to another sheet and How to use Excel HYPERLINK function to create different link types
I hope it’ll be helpful.
Thanks for the reply Alexander,
however this doesn't look like what i'm trying to do. Youre example & articles indicate me doing a Hyperlink to the other file on the internet.
I'm trying to only pull the value of a cell on another workbook on the internet. Not a hyperlink to the other file.
For example)
1. Workbook A - I have a main dashboard tracking multiple tasks/projects
2. Workbook B,C,D,E,F - Each project has its own separate file on the internet (in box.com)
3. Anyone can update Workbook B,C,D,E,F as they work on stuff and the % of completion will show up on the top in sheet1 cell A1
4. For Workbook A - I want to be able to pull the value in each of the other workbooks Sheet1 CellA1 value, so it gives me a dashboard % of all other workbooks at once instead of me having to go open all the other files one at a time.
Hopefully this example makes sense.
Any suggestions will be greatly appreciated!
Hi Alexander,
Would you happen to know if my question is possible to accomplish?
Hi,
The formula
=HYPERLINK("[https://example.com/report/file.xls]Sheet1!A10", D1)
retrieves the value from the cell A10 on Sheet1 from a file on the Internet. Hope this is what you need. Study carefully the articles I have recommended.
Hi Alexander,
So I went ahead and tried this formula you mentioned above. Just to test to see if it works, I set up the files as follows.
Spreadsheet File1 = I entered the formula you mentioned
Spreadsheet File2 = I entered a value -->50 in Sheet1 CellA10
Upon completing this, it still does not work.
The value I get per your formula = 0
Any idea what the issue might be?
Just to test to see if your
Just out of curiosity.
Have you tried this yourself in Box? or are you trying this on a different platform?
I'm wondering if this feature is not supported in Box.
Hi,
I hope you have studied the recommendations in the tutorial above.
Pay attention to the following paragraph of the article above — Excel reference to another workbook.
If you need to get a value from a file on the internet, here's an example:
='https://cdn.ablebits.com/excel-tutorials-examples/[count-unique-excel.xlsx]Unique values'!$A$3
Thanks for the example URL you provided. I confirmed it works!
So, here is the issue I have.
The file on the internet I'm trying to access is on Box. and the URL for files on Box look like the following:
https://app.box.com/s/4fcfdd2b25lyps2p46khzydj6maoejvv
I made it public so you should be able to view the spreadsheet as well.
Every time I try to use reference a cell from any worksheet on box, i get a reference error. I'm pretty sure its because of the URL of the file. Any further suggestions?
hmm. i typed my response but its not showing.
Let me try it again.
Thanks for the example link above. I confirmed I can see the value when referenced.
However, here is the issue I'm still having.
The files I'm referencing aren't on a CDN. Its on Box.
Therefore, the shared url of the file look like this - https://app.box.com/s/4fcfdd2b25lyps2p46khzydj6maoejvv
I made the link public so you should be able to view it as well.
Whenever I try your method using my URL from box, I get a reference error and I'm pretty sure its because of the URL.
Do you have any further suggestions in trying to get around this issue?
For some reason i still can't see my last response to you.
Trying response without URL.
Thanks for the example link above. I confirmed I can see the value when referenced.
However, here is the issue I'm still having.
The files I'm referencing aren't on a CDN. Its on Box.
Therefore, the shared url of the file look like this - [Blank]
I made the link public so you should be able to view it as well.
Whenever I try your method using my URL from box, I get a reference error and I'm pretty sure its because of the URL.
Do you have any further suggestions in trying to get around this issue?
Hi,
Unfortunately, I do not work with such files and with this CDN. So I can't help you.
I don't think this will work as it is not an Excel file.
Now that I know my comments wont show if I include a URL I copy pasted.
Here is a workaround.
h t t p s ://app.box.com/s/4fcfdd2b25lyps2p46khzydj6maoejvv
I have a MASTER spreadsheet that uses cell references to pull data from three data template workbooks. All four of these files reside in the same folder on Dropbox. Periodically, I save a copy of each data template onto my Mac laptop and I add the day's date to the name. Unexpectedly, the MASTER spreadsheet unilaterally changes the cell references to the name of one of my data backup files, replacing the original cell reference that I had created within the MASTER. So then, that group of data is no longer being pulled from the Dropbox file. Why is this happening, and how do I prevent it?
Hello!
I think you created a copy of the file using Excel - Save as ... At this time you had your MASTER file open. When you save a file under a new name, all links to it are automatically changed.
I have say 6 tabs in a excel workbook. the 6th tab shows the summary of the first 5 tabs total column, which is in a common cell say A10 in all 5 tabs. How do I now show the auto-generated summary of this total column cell A10 in 6th tab with having mentioned the name of all 5 tab names?
Hello!
I hope you have studied the recommendations in the tutorial above. It contains answers to your question.
Also pay attention to this article - 3-D reference in Excel: reference the same cell or range in multiple worksheets
I hope my advice will help you solve your task.
Thanks for this! I'm taking a college course whose tutorials don't explain everything, so this helps a lot.
Is there a way to keep the file path to always read from the current folder that it is in?
For example say I have the excel file in file path \\trial\test1 and its reading info from the same path. Is there a way of copy and pasting that excel sheet into path \\trial\test2 and then reading from within the new folder ( \\trial\test2 ) without having to redo all the links?
Thanks in advance
Hello!
Unfortunately, Excel cannot search for files. You can change all links at once using the Excel tool - Find & Select - Replace
Okay no problem, thankyou for your quick reply
How to break the links within the same workbook but different worksheet
hi my formula is
Here is the formula is my excel named: EXCEL-ONE
='[EXCEL-TWO.xlsm]Sheet1'!$B3
its looking up my second excel named: EXCEL-TWO,
in the Sheet1, and B3 cell
and it works flawlessly :D
my question:
i would like the Sheet1 word to come from a cell in EXCEL1
so i would have a blank cell in EXCEL1, that you could type in :
Sheet1, or Sheet2 or Sheet3 .... giving you knew the name of the tabs in SHEET2 obvisouly,
is that possible ?
Hello!
You can learn more about creating an Excel dynamic reference to another workbook with INDIRECT function in Excel in this article on our blog.
I hope this will help, otherwise please do not hesitate to contact me anytime.
I want a copy of my excel workbook at other location and if i change one book that can reflect automatically other workbook can this happen please help
Hi Priyanka,
For this, you need to link every cell of the copy to the corresponding cell in the original workbook. It can be done with a formula like this:
=[Book1]Sheet1!$A$1
Where Book1 is the original workbook.
The detailed steps to make such a reference are described in How to refer to another workbook.
thanks alot
We have an Excel Workbook with 10 to 15 worksheets and all these worksheets interacts with one another for calculations and for data. Some of these worksheets gets Data from other excel workbooks by a cell reference formula. The main workbook depends on worksheets and other excel files/workbooks to get data and do calculations this work is done once a year. So many references, formulas and calculation are involved. Each year we copy all the last year workbooks and update the source files to do the calculations for the present year. The master excel workbook mostly does the calculation by itself when the source data feeds into the workbook and there are some excel cells in the master workbook that needs data from user but this is rare.
Is there a way to track all the changes happened in the source files that got feed into master workbook, like old values in source values that got updated to new values and also capture old and new value in master book for comparison. Tracking should capture values not formulas.
Hello!
I recommend reading this guide about logging changes to Excel files. I hope this will help
Hello, thank you for quick response. I tried track changes within excel but this doesn't work in my situation. If i have an empty cell in master excel and if i have a formula that gets value from other excel file track change shows old value as 0 and new value as formula.But if i update source file with different value track change wont capture this because formula will be same. We have some where around 12 source excel files that we update value and this data will feed into master excel file
I am new to last changed cell concept but i want to track each and every cell that got updated in source file with old value and new value. This data will feed into master workbooks and again i want to capture old and new value so we can just manually check the two log sheets to make sure all the data is correct and feed properly into master excel file. I am hoping there will be way and thanks for future response.
i am trying to drag my excel pattern but it isn't working as i want it to. it consists of a cell reference in cell A1, information in cells B1,A2,B2,andA3, and another cell reference in B3. i wanted to extend the pattern through cells A8 and B8. but when i extended it to A4 then the cell reference became cell A4 from the sheet it was coming from. is there a way to make it be cell A2 instead (and have it continue in cell A7 with reference cell A3 on the reference sheet)?
Hello!
I’m sorry but your task is not entirely clear to me. For me to be able to help you better, please describe your task in more detail. Please specify what you were trying to find, what formula you used and what problem or error occurred. Give an example of the source data and the expected result.
It’ll help me understand it better and find a solution for you.
Good day! I've spent week trying to create a template where the prices are put in and calculated on one Excel file and are automatically synced with a Master Excel file (i.e. database), which records the calculated values on the prior worksheet, automatically updating itself when changes on the template occur.
I have a workbook with a consolidated sheet and a sheet for each person. The consolidated sheet is more like a summary of each month and the total amount spent etc. the consolidated sheet pulls the totals, the name and the amounts form the sheets, but I wanted the sheets to pull the FTE and budget amount from the Consolidated sheet, this way when having to update the amount from year to year it can be updated in one place and not have to click on every sheet to update. The problem I am running into is when I try to sort the Consolidated sheet. I have used the =sheetname!A5 formula to pull the information onto each individual sheet but when I sort the consolidated sheet the cell stays the same even when the name moves. How do I get it to move with the sort?
Hello Heather!
If Excel uses an external reference to another file, it tries to recalculate it to get accurate final data. If Excel can’t do this for some reason, it doesn’t consider the file version as final and doesn’t get anything from it.
Thus, if any additional actions are required from a user to recalculate the data in the source file, you won’t get the data from this file until the user opens it and allows to update the data or run macros. Most likely, the file from which you pull the data contains some external references as well. Unless the file is open, the references can’t be updated. Therefore, it is not possible to automatically recalculate the data. Besides, there may be macros in the source file that also require an additional permit to be run. While Excel is waiting for this action to take place, it doesn’t transfer the data from this file to other files.
It happens when the source file is not open in Excel. If you have opened the workbook which you refer to, there shouldn’t be any problems and the data from that file can be used in your table.
HI
I have a few issue's with my formula below retrieving information from another sheet.
{=INDEX('NSW RESULTS'!$B$6:$B$100000,MATCH(1,INDEX(('NSW RESULTS'!$A$6:$A$100000=$A$6)*('NSW RESULTS'!$B$6:$B$100000=MAX(IF('NSW RESULTS'!$A$6:$A$100000=A6,'NSW RESULTS'!$B$6:$B$100000))),0),0))}
1. This didn't return max (latest) date?
2. How to return second latest date?
3. How to place a second sheet? Both sheets are column matched so it's cheeking same information difference years. =INDEX('NSW RESULTS'!'NSW 19'!$B$6:$B$100000,MATCH(1,INDEX(( ????
Regards
Tony
Hello Tony!
Unfortunately, without seeing your data it is impossible to give you advice.
Could you please describe your task in more detail and send us a small sample workbook with the source data and expected result to support@ablebits.com? Please shorten your tables to 10-20 rows/columns and include the link to your blog comment.
We'll look into your task and try to help.
Hi Alexander
Have sent information through, hope you can help.
Regards
Tony
iF I WANT TO GET A DATA FROM ANOTHER SHEET IN ONE COLUMN AND I WILL USE IT IN 6 DIFFERENT COLUMNS.
iT WILL BE POSSIBLE TO FIXED THE DATA IN 1ST,2ND,3RD COLUMN WHEN I CHANGED THE DATA FROM REFERENCE COLUMN?
I HOPE MY QUESTION EXPLAINED UNDERSTANDABLE.
THANKS IN ADVANCE
FROM THE PHILIPPINES
Hello Ronnie,
You may always disable the auto-update for your external links. Just go to Excel Options -> Advanced -> When calculating this workbook and uncheck the necessary options there.
However, when you update your external links manually, they all get updated anyway. If you want to set a particular part of your external links, simply replace them with values using Copy - Paste Special - Values.
Dear Team,
I have some multiple excel files in folder. And i get data from this multiple files particular cell. Remember that i thought i can't open any close multiple files and receive data in one excel sheet.
At least particular cell value in data will get in close file to open file
Hello!
Please describe your problem in more detail. It’ll help me understand it better and find a solution for you. Thank you.
Help in retrieving information from another sheet.
Referencing sheet 1 QLD RESULTS FOR ALL INFORMATION
Formula sheet 3 QLD RESULTS
Sheet 1 column A Name / column B Dates / column C Distance / to column Z Time
Sheet 3 A6 Name reference with latest 4 dates
Formula's tried eg;
=VLOOKUP(A6,'QLD RESULTS'!A:A,1,FALSE)
=VLOOKUP(A6,'QLD RESULTS'!A:B,2,FALSE)
=VLOOKUP(A6,'QLD RESULTS'!A:C,3,FALSE)
=MAX(A6='QLD RESULTS'!$A$6:$A$20000,'QLD RESULTS'!$B$6:$B$20000,"")*FALSE
Regards
Tong
Hello Tony!
I’m sorry but your task is not entirely clear to me.
For me to be able to help you better, please describe your task in more detail. Please let me know in more detail what you were trying to find, what problem or error occurred. It’ll help me understand it better and find a solution for you. Thank you.
Hi Alexander
Sorry about the misunderstanding before I hope below covers all queries.
1 ; Find same source name on both sheets?
2 ; Match source name with max, 2nd, 3rd, 4th latest date (4 Rows)?
3 ; Match by name & date across all 10 columns?
4 ; Formula “QLD FIELDS”
5 ; Information from “QLD RESULTS”
Retrieving information from “QLD RESULTS” & placing Formula in another sheet name “QLD FIELDS”
Both sheets start in column A with name.
“QLD RESULTS” has about 12 column of all information by eg;
A=Name, B=Date, C=Distance, D=Track, E=Finish, & so on
“QLD FIELDS” column A6 has “Source Name” to retrieve all information with latest 4 max dates.
“QLD FIELDS” is formula area starting in Column N6 - N9 & across.(4 Rows latest 4 Dates)
Say you have Jumping Joe as your “Source Name” in QLD FIELDS column A6!
“ QLD RESULTS” in column A find “Jumping Joe”/ in column B find latest max date/ match both A & B max date to get column C/ match both A & B max date to get column D/ & so on across. (QLD FIELDS column N6)
Same as above to get 2nd max date information. (QLD FIELDS column N7, O7, P7, Q7 so on across)
Same as above to get 3rd max date information. (QLD FIELDS column N8, O8, P8, Q8 so on across)
Same as above to get 4th max date information. (QLD FIELDS column N9, O9, P9, Q9 so on across)
Regards
Tony