Numbers & Symbol ü (New Challenge)
Solved/Closed
mathewmunna
Posts
22
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
mathew - Nov 23, 2014 at 01:37 AM
Related:
- Numbers & Symbol ü (New Challenge)
- At symbol on keyboard - Guide
- Underscore symbol - Guide
- Pipe symbol mac - Guide
- Tick symbol in word - Guide
- Pi symbol on keyboard - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 19, 2014 at 12:52 AM
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
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
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 19, 2014 at 11:26 PM
Nov 19, 2014 at 11:26 PM
I gave an idea and I expect you to work on it.
Nov 19, 2014 at 02:06 AM
but i need it for 1,2,3 and so on
if 1,3,5 then a1, a3, a5 should (*)
Nov 19, 2014 at 06:58 AM
=IF($J$1=ROW(A1),"*",(IF($K$1=ROW(A1),"*",(IF($L$1=ROW(A1),"*","")))))
Thanks Venkat.