Numbers & Symbol ü (New Challenge)

Solved/Closed
mathewmunna
Posts
27
Registration date
Tuesday November 18, 2014
Status
Member
Last seen
May 21, 2015
- Nov 19, 2014 at 12:09 AM
 mathew - Nov 23, 2014 at 01:37 AM
i need a formula to automatically check mark i.e(ü) mark a cell(eg:A1) if another cell (eg:H1)contains number:1
Condition is H1 may contain any numbers like 1,2,5,6,8 to 20
A1 should check mark only if there is 1
( if i drag formul A2 should check mark only if there is 2...and process upto A20 i.e number 20)

Formula should come like this:
(A1:A20) should Check H1 if perticular number contains in that cell i.e
check H1 if it contains 1 then tickmark A1
check H1 if it contains 2 then tickmark A2
check H1 if it contains 3 then tickmark A3
upto 20numbers

Similarly,
Formula should come like this:
(B1:B20) should Check H2 if perticular number contains in that cell i.e
check H2 if it contains 1 then tickmark B1
check H2 if it contains 2 then tickmark B2
check H2 if it contains 3 then tickmark B3
Upto 20 numbers

2 replies

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Nov 19, 2014 at 12:52 AM
using tick mark is little complicated. instead you can use star (*)

now in A1 type this formula and enter

=IF($H$1=ROW(A1),"*","")

now copy A1 to A2 aand A3

now go to H1 type 1 what happens
type 2 in H1 what happens
type 3 in H1 what haplpens.

does this do what you want
1
mathewmunna
Posts
27
Registration date
Tuesday November 18, 2014
Status
Member
Last seen
May 21, 2015

Nov 19, 2014 at 02:06 AM
it works only if the single nuber exists.. ie 1 or 2 or 3
but i need it for 1,2,3 and so on
if 1,3,5 then a1, a3, a5 should (*)
0
mathewmunna
Posts
27
Registration date
Tuesday November 18, 2014
Status
Member
Last seen
May 21, 2015

Nov 19, 2014 at 06:58 AM
This formula worked when i took numbers on defferent cells..
=IF($J$1=ROW(A1),"*",(IF($K$1=ROW(A1),"*",(IF($L$1=ROW(A1),"*","")))))
Thanks Venkat.
0
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Nov 19, 2014 at 11:26 PM
I gave an idea and I expect you to work on it.
1
thanks..i am dummy in excel.. small things also seems big challange for me..thanks for ur support.
0