Help Displaying Values and Linking

		Microsoft Office Forums > Microsoft Excel > Excel
Help Displaying Values and Linking

FAQ

Thread Tools

Display Modes

01-03-2019, 01:19 AM

xor

Windows 10 Help Displaying Values and Linking

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

A formula solution:

A: =ADDRESS(MATCH(MAX($F$320:$F$465),$F$320:$F$465,0) +CELL("row",$F$320:$F$465)-1,6)

B: =ADDRESS(MATCH(MAX($F$320:$F$465),$F$320:$F$465,0) +CELL("row",$F$320:$F$465)-1,1)

Tags

formatting, help a novice

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Table with values from several locations and years - need to find comp values	Ricardo Sousa	Excel	9	07-27-2018 02:06 AM
Table with values from several locations and years - need to find comp values	Ricardo Sousa	Excel	6	06-09-2018 10:51 PM
Multiple found values from five sheets, multiple returned values in sheet six?	irisha	Excel Programming	26	09-30-2016 01:20 AM
Linking fields to pull values from one field to another	KWH	Word Tables	3	01-27-2016 02:25 PM
Display multiple values as new values based on selection from template.	MvdB	Excel	2	09-29-2015 08:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:10 PM.