Is there any way to find where the 1 is in the range A1:C3? (The answer is C2.) The actual application involves a larger range. Thanks in advance!
Columns
A B C
Row
1 5 6 8
2 4 3 1
3 2 7 9
Is there any way to find where the 1 is in the range A1:C3? (The answer is C2.) The actual application involves a larger range. Thanks in advance!
Columns
A B C
Row
1 5 6 8
2 4 3 1
3 2 7 9
Last edited by Larry.LeBlanc@O; 10-26-2011 at 04:46 PM.
Per your example using A1 through C3.
Please Login or Register to view this content.
Please acknowledge the response you receive, good or bad. If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Could there be more than one 1 in the range?
Audere est facere
Thank you, let me look at that.
Yes, there could be more than one 1 in the range
So if there was a 1 in B1 and another in A2 what result would you want?
Ideally, I would like to find all the locations of the 1 in the range.
Check out this link once.
http://www.excelforum.com/excel-prog...n-a-table.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks