Excel table: refer to a particular row?

		Microsoft Office Forums > Microsoft Excel > Excel
Excel table: refer to a particular row?

FAQ

Thread Tools

Display Modes

08-04-2015, 07:37 AM

tinfanide

Windows 7 64bit Excel table: refer to a particular row?

Office 2010 32bit

Expert

Join Date: Aug 2011

Posts: 312

Quote:

Originally Posted by gebobs

OK...I was able to kludge together a formula that does it and is sortable. See attached.

Yes. While using MATCH to get the absolute row numbers, I was thinking of how to reference using those row numbers with Table. Your use of ADDRESS and INDIRECT is really insightful.

Many thanks for your help!

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Insert a Excel table in an existing PowerPoint table	Vallin	PowerPoint	1	03-09-2015 06:25 AM
If (C1 = refer to a cell in a range) then (show the description in C2) & (corresponding price in C3)	lily	Excel	9	10-23-2014 06:21 AM
How to change the path of a table copied by excel in word as linked table RTF?	Cristin7	Word VBA	3	03-10-2014 05:25 AM
update one embedded excel table based on another excel table	ajetrumpet	Word	0	07-05-2013 08:51 PM
How do I refer to page numbers, when the numbers change as I prepare the document?	StevenD	Word	5	11-29-2012 12:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:17 PM.