paramnayak
Member
How can I get location of a number in an array.
finding location of a number in an array
- Thread starter paramnayak
- Start date
nazmul_muneer
Member
paramnayak,
Type in the columnA from A1
a
b
c
d
e
f
g
h
i
j
Think you are looking for the location/cell reference of "e" in the column A. Type
=ADDRESS(MATCH("e",A:A,0),1)
Is this your requirement? I am not sure.
Regards,
Muneer
Type in the columnA from A1
a
b
c
d
e
f
g
h
i
j
Think you are looking for the location/cell reference of "e" in the column A. Type
=ADDRESS(MATCH("e",A:A,0),1)
Is this your requirement? I am not sure.
Regards,
Muneer
paramnayak
Member
dear muneer,
say, we have the following numbers in the array
3 14 17
2 13 61
4 15 20
5 12 18
how can i search for a particular number in the array for example i want to get the location of 12 in this array
say, we have the following numbers in the array
3 14 17
2 13 61
4 15 20
5 12 18
how can i search for a particular number in the array for example i want to get the location of 12 in this array
sgmpatnaik
Active Member
Hi paramnayak
if your data will place from A1:C4 and you want to search
then you can use the below formula in conditional format
using with the formula =AND($E$1<>"",ISERROR(FIND(LOWER($E$1),LOWER(A1)))=FALSE)
Have a look in the sample file please download
https://dl.dropbox.com/u/75654703/Search_Method.xlsx
if any doubts please refer us
With Regards
SP
if your data will place from A1:C4 and you want to search
then you can use the below formula in conditional format
using with the formula =AND($E$1<>"",ISERROR(FIND(LOWER($E$1),LOWER(A1)))=FALSE)
Have a look in the sample file please download
https://dl.dropbox.com/u/75654703/Search_Method.xlsx
if any doubts please refer us
With Regards
SP
paramnayak
Member
thanx sp,
this is of great help. Can u just explain me how is it working
this is of great help. Can u just explain me how is it working
sgmpatnaik
Active Member
Hi Paramnayak
Glad i could help you
here is the explain
1. Select your data from A1:C10 or your data range
2. in the Home ribbon you will find the Conditional Formatting
3. Select the New Rule
4. you will c a dialog box as EDIT FORMATING RULE
5. In that box you can find some Option select the Last option of "USE A FORMULA TO DETERMINE WHICH CELLS TO FORMAT"
6. NOW YOU PLACE THE FORMULA WHICH I EXPLAIN IN MY BEFORE POST, THE FORMULA IS (=AND($E$1<>"",ISERROR(FIND(LOWER($E$1),LOWER(A1)))=FALSE)
With Regards
SP
Glad i could help you
here is the explain
1. Select your data from A1:C10 or your data range
2. in the Home ribbon you will find the Conditional Formatting
3. Select the New Rule
4. you will c a dialog box as EDIT FORMATING RULE
5. In that box you can find some Option select the Last option of "USE A FORMULA TO DETERMINE WHICH CELLS TO FORMAT"
6. NOW YOU PLACE THE FORMULA WHICH I EXPLAIN IN MY BEFORE POST, THE FORMULA IS (=AND($E$1<>"",ISERROR(FIND(LOWER($E$1),LOWER(A1)))=FALSE)
With Regards
SP