Numbers & Symbol ü (New Challenge)
Solved/Closed
mathewmunna
mathew - Nov 23, 2014 at 01:37 AM
- Posts
- 27
- Registration date
- Tuesday November 18, 2014
- Status
- Member
- Last seen
- May 21, 2015
mathew - Nov 23, 2014 at 01:37 AM
Related:
- Numbers & Symbol ü (New Challenge)
- This message was deleted text symbol - Forum - Android
- Pi symbol - Guide
- At symbol on keyboard - Guide
- Pipe symbol mac - Guide
- Logitech keyboard @ symbol ✓ - Forum - Hardware
2 replies
venkat1926
Nov 19, 2014 at 12:52 AM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
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
Nov 19, 2014 at 11:26 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
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.