Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Numbers & Symbol ü (New Challenge) [Solved/Closed]

Report
Posts
27
Registration date
Tuesday November 18, 2014
Status
Member
Last seen
May 21, 2015
 -
 mathew -
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
See more

2 replies

Answer 1 / 2
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 791
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
Thank you
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2891 users have said thank you to us this month

Report
Posts
27
Registration date
Tuesday November 18, 2014
Status
Member
Last seen
May 21, 2015
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 (*)
Report
Posts
27
Registration date
Tuesday November 18, 2014
Status
Member
Last seen
May 21, 2015
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.
Answer 2 / 2
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 791
I gave an idea and I expect you to work on it.
Thank you
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2891 users have said thank you to us this month

Report

thanks..i am dummy in excel.. small things also seems big challange for me..thanks for ur support.
Ask a question