Help me on this formula to shorten
Solved/Closed
mathewmunna
Posts
22
Registration date
Tuesday 18 November 2014
Status
Member
Last seen
21 May 2015
-
19 Nov 2014 à 06:49
mathewmunna Posts 22 Registration date Tuesday 18 November 2014 Status Member Last seen 21 May 2015 - 6 Dec 2014 à 23:42
mathewmunna Posts 22 Registration date Tuesday 18 November 2014 Status Member Last seen 21 May 2015 - 6 Dec 2014 à 23:42
Related:
- $L$1 excel
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Spreadsheet formula - Guide
- Formula to calculate vat in excel - Guide
- Number to words in excel formula - Guide
- Grade formula in excel marksheet - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
24 Nov 2014 à 11:44
24 Nov 2014 à 11:44
Hi Mathew,
Try this array formula, which needs to be confirmed by hitting Ctrl+Shift+Enter:
=IF(OR($J$1:$L$1=ROW(A1)=TRUE),"*","")
If done correctly the formula will be enclosed by curly brackets.
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
Try this array formula, which needs to be confirmed by hitting Ctrl+Shift+Enter:
=IF(OR($J$1:$L$1=ROW(A1)=TRUE),"*","")
If done correctly the formula will be enclosed by curly brackets.
Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
26 Nov 2014 à 00:31
26 Nov 2014 à 01:37
when i drag the formula to other cell $J$2:$L$2.....
A1 =IF(OR($J$1:$L$1=ROW(A1)=TRUE),"*","")
B1 =IF(OR($J$2:$L$2=ROW(B1)=TRUE),"*","")
C1 =IF(OR($J$2:$L$2=ROW(C1)=TRUE),"*","")
4 Dec 2014 à 10:16
Sorry for my late response, have been ill the past week.
A dollar symbol will fix a column or row, so remove the dollar sign in front of the row number:
=IF(OR($J1:$L1=ROW(A1)=TRUE),"*","")
Best regards,
Trowa
6 Dec 2014 à 23:42