Numbers & Symbol ü (New Challenge)

Solved/Closed
mathewmunna Posts 22 Registration date Tuesday 18 November 2014 Status Member Last seen 21 May 2015 - 19 Nov 2014 à 00:09
 mathew - 23 Nov 2014 à 01:37
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
Related:

2 responses

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
19 Nov 2014 à 00:52
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
mathewmunna Posts 22 Registration date Tuesday 18 November 2014 Status Member Last seen 21 May 2015
19 Nov 2014 à 02:06
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 (*)
mathewmunna Posts 22 Registration date Tuesday 18 November 2014 Status Member Last seen 21 May 2015
19 Nov 2014 à 06:58
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.
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
19 Nov 2014 à 23:26
I gave an idea and I expect you to work on it.
thanks..i am dummy in excel.. small things also seems big challange for me..thanks for ur support.