Reference Formula and cell reference

		Microsoft Office Forums > Microsoft Excel > Excel
Reference Formula and cell reference

FAQ

Mark Forums Read

Thread Tools

Display Modes

10-15-2024, 08:34 AM

ImAhNoBoDy ImAhNoBoDy is offline

Windows 7 64bit Reference Formula and cell reference

Office 2007

Novice

Join Date: Jan 2012

Posts: 17

I needed up using something similar to this:

https://www.extendoffice.com/documen...al-values.html

=TEXTJOIN(", ", TRUE, IF(COUNTIF(A2, "*"&$D$2:$D$7&"*"), $D$2:$D$7, ""))

The above is just a copy and paste from the site and not what I put in my spreadsheet. I'm putting it here in case I need reference it again.

I got the cell address, I just haven't put everything together. But I think I got what I needed. Thanks.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Determining if an in-text table reference was created with Word's native cross reference feature	scienceguy	Excel Programming	2	10-25-2021 04:44 AM
Entering a column value in a cell, to be used as part of a reference in a formula in another cell	paulkaye	Excel	4	02-26-2017 04:18 AM
Formula for reference last non empty cell in row	npn321	Excel	10	02-22-2017 11:42 PM
Issue with a dynamic cell linking/reference formula	raravind82	Excel	2	10-26-2016 04:16 AM
Reference number and cross reference for equation numbers to match the thesis format	wmac	Word	1	05-14-2013 08:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:27 PM.