Charting variable ranges

		Microsoft Office Forums > Microsoft Excel > Excel
Charting variable ranges

FAQ

Thread Tools

Display Modes

09-20-2017, 11:49 PM

mreynolds1775 mreynolds1775 is offline

Windows 10 Charting variable ranges

Office 2013

Novice

Join Date: Sep 2017

Posts: 12

mreynolds1775 is on a distinguished road

Peco, et al.,

Got it figured out. I only needed the first half of that formula as I am not looking for a range, but a specific cell in the index.

=INDEX($E3:$Z3,MATCH(9.99E+307,$E3:$Z3)-1)
=INDEX($E3:$Z3,MATCH(9.99E+307,$E3:$Z3)-2)
=INDEX($E3:$Z3,MATCH(9.99E+307,$E3:$Z3)-3)

etc...

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I want to create a bar chart of multiple variable. Then I need to draw trend lin of those variable	shimulsiddiquee	Excel	1	05-16-2017 07:39 AM
Take String of numbers, expand ranges, sort, then compress back into ranges	AustinBrister	Word VBA	19	08-22-2016 05:18 PM
Run Time Error '91': Object variable or With block variable not set using Catalogue Mailmerge	Berryblue	Mail Merge	1	11-13-2014 05:36 PM
Run-time error 91 object variable or with block variable not set	JUST ME	Word VBA	4	03-25-2014 06:56 AM
Run-time error '91': Object variable or With block variable not set	tinfanide	Excel Programming	2	06-10-2012 10:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:06 AM.