• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

getting location of a number in array

P

paramnayak

Member
dear all,

i want to get location of some numbers in array.

how can this be done. One way will be using conditional formatting but i would like to have the location of cells from which these numbers are coming.

given below is the link to the file


http://speedy.sh/zbTnp/getting-location-in-array.xlsx
 
Hi Nayak ,


Can you go through this file and adapt it to your workbook ?


http://speedy.sh/uGsPZ/Nayak-example.xlsx


The cell address , where the sought value is to be found , is in the named range Address_of_Find_Value. If you put the following formula in any unused cell , it will give the address of the cell.


=Address_of_Find_Value


Narayan
 
dear narayan,

its working but problem seems to be with the file. Any entry in this file and the office excel stops working

I tried this in a new sheet and again the same problem
 
Hi Nayak ,


Can you explain what you want from your file ? I could not understand your requirement , which is why I uploaded my own example file.


Let me ask you regarding data from your file ; suppose we want to find the location of a number such as 1998 ( the value in cell K10 ) ; do you want a result such as $K$10 ?


Narayan
 
dear narayan,

there is an array with numbers. (the set of numbers in array will come from numbers which are close to LCM of 2 numbers).

for example in the file which i have uploaded , the numbers are coming from the LCM of numbers close to 72 and 50 (in a1 and b1 respectively)


in that array,i want to get position of say the smallest or 2 nd smallest number (which will be generated from the formula (eg cell q3 is giving the smallest no. in array ,cell q4 is giving the second smallest no.)


Now I want to get position of the number in say cell q3 in array (which is the smallest no. in array).I want to know the numbers whose lcm gives this number


I can modify the file which you have uploaded to get the position of the numbers.


But the problem arises when some entry is done in the excel sheet. The excel stops working. Message displayed is "Microsoft office excel has stopped working. #check online for soln.#restart the program.


I hope i am not troubling you much
 
Hi Nayak ,


See if you have similar problems with this file ; I have made the required range name entries in your file itself.


http://speedy.sh/nJpmr/getting-location-in-array.xlsx


Narayan
 
You must log in or register to reply here.
Back
Top