#VALUE error with Text function

**Tony Valko** · 10-12-2015, 11:38 AM

Originally Posted by FrankNStein

now my problem is, that the plot reverses i.e. latest exchange price is now to the left of the plot not to the right.

Sorry, don't know what that means.

**FrankNStein** · 10-12-2015, 01:57 PM

Originally Posted by Tony Valko

Sorry, don't know what that means.

The sorting of the values is: Latest prices on top. oldest on the bottom (or end of the sheet in row 2000+). Plot datas are usually arranges as top numbers with x value 1, bottom number in this case with x value 2000+. I found the solution anyway, thx, so no worries there.

Essentially my problem ist soved with your proposal, thx for that.

**Tony Valko** · 10-12-2015, 03:16 PM

Originally Posted by FrankNStein

Essentially my problem ist soved with your proposal, thx for that.

Good deal. Thanks for the feedback!

#VALUE error with Text function

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: #VALUE error with Text function

Re: #VALUE error with Text function

Re: #VALUE error with Text function

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Function Error: Compile error: Expected: list separator or )

[SOLVED] Compile Error 'Sub or Function is not define' error on Private Sub Getdata()

Compile error: Sub or Function not defined Error

[SOLVED] Error in function Compile error: Can't find project or library

index function error using match function to get data from a cell in an array

Excel - User Defined Function Error: This function takes no argume

[SOLVED] Function displays as text, doesn't return result or error

Bookmarks

Bookmarks

Posting Permissions