LinkBack URL
About LinkBacks
HI,
Please help me find a way to solve this:
1,01 1,01 1,01 1,05 1,07
In the example above I want excel to return the column number of the first time that the value changed from reference to the first value. The result should be 4.
Can anyone help?
HI,
Please help me find a way to solve this:
1,01 1,01 1,01 1,05 1,07
In the example above I want excel to return the column number of the first time that the value changed from reference to the first value. The result should be 4.
Can anyone help?
Last edited by xico; 07-19-2012 at 11:40 AM. Reason: Problem Solved
try array formula like this (confirmed CTRL + SHIFT + ENTER)
Formula:
Please Login or Register to view this content.
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
Try this:
Formula:Please Login or Register to view this content.
Confirmed with Ctrl+Shift+Enter.
It works irregardless of the values in the array.
Sincerely
S?ren Larsen
"Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
Thank you both! Excellent answers!
Saved my day!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks