=CELL('address',OFFSET(A1,MATCH(MIN(A1:A10),A1:A10,0)-1,0))I need to then 1. 
Have the value of the cell in another cell on the spreadsheet and 2. Have the value of the cell 3 columns to the left (Containing the date) in another cell.
Excel For Mac 2011 Training
Desktop versions of Office applications: Outlook, Word, Excel, PowerPoint, OneNote (plus Access and Publisher for PC only) Web versions of Word, Excel, and PowerPoint One license covers fully-installed Office apps on 5 phones, 5 tablets, and 5 PCs or Macs per user.
The function above returns an absolute cell address, but I seem unable to manipulate this further to accomplish 1 and 2. Moreover, I need both 1 and 2 to recalculate whenever I refresh the data, so no hardcoding is possible. I have googled extensively and don't even know how to phrase the question to get started.
Any assistance to point me in the right direction would be most appreciated! =CELL('address',OFFSET(A1,MATCH(MIN(A1:A10),A1:A10,0)-1,0))I need to then 1. Have the value of the cell in another cell on the spreadsheet and 2. Have the value of the cell 3 columns to the left (Containing the date) in another cell. The function above returns an absolute cell address, but I seem unable to manipulate this further to accomplish 1 and 2. Moreover, I need both 1 and 2 to recalculate whenever I refresh the data, so no hardcoding is possible.
I have googled extensively and don't even know how to phrase the question to get started. Any assistance to point me in the right direction would be most appreciated!VillageGirl, Welcome to the Boards. I am using a PC with Windows 7 and Excel 2007.but since you are looking for a formula solution, you might see if the following formulas will work for you. From what you described it appears that your data is formatted similarly to this: Excel 2007 A B C D E F 1 Date ID 2 150 3 140 4 130 5 120 6 110 7 100 8 90 9 80 10 70 11 6/14/2016 60 Test1 12 50 13 40 14 30 Sheet1 Your formula gives the address of the MIN value of the range in question. For demonstration I considered the range A1:F11. I adjusted your formula which became: =CELL('address',OFFSET(D2,MATCH(MIN(D2:D11),D2:D11,0)-1,0)) To get the value (MIN value) I used the following formula in cell S8: =MIN(IF(D2:D110,D2:D11,FALSE)) Then to 'Have the value of the cell in another cell on the spreadsheet.'
Tools for mindful living: Practicing the 4 Step MAC Guide and CD (Third Edition). Dubuque, IA: Kendall Hunt Publishing Company. Dubuque, IA: Kendall Hunt Publishing Company. 10 peer reviewed journal articles selected from professional journals for the fast fact presentation. Her most recent workbook, Tools for Mindful Living: Practicing the 4-Step MAC Guide, was designed to augment the learning of postgraduate social work students undertaking a quality of life elective. Social work practitioners are occupationally at risk for stress, burnout, depression and compassion fatigue. Napoli, m. (2016). tools for mindful living: practicing the 4 step mac guide pdf.
Excel 2011 For Mac Download
I used the following formula in cell S9: =+DGET(A1:F11,'ID',S1:S8) And finally, to 'Have the value of the cell 3 columns to the left (Containing the date).' I used the following formula in cell S10 and formatted the cell as a date, '6/14/2016': =+DGET(A1:F11,'Date',S1:S8) You can move your equations wherever you need to, but you must include the range from row 1 (if that is where your headers are) to the row where the MIN value is located in that column. So you could use H1:H2 in place of S1:S8 in the DGET formulas. You just have to include all the cells from the header row down to the cell with the MIN value in your range. Give these formulae a try. Hopefully they are supported in Mac 2011.