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