Help me on this formula to shorten
Solved/Closed
mathewmunna
Posts
22
Registration date
Tuesday November 18, 2014
Status
Member
Last seen
May 21, 2015
-
Nov 19, 2014 at 06:49 AM
mathewmunna Posts 22 Registration date Tuesday November 18, 2014 Status Member Last seen May 21, 2015 - Dec 6, 2014 at 11:42 PM
mathewmunna Posts 22 Registration date Tuesday November 18, 2014 Status Member Last seen May 21, 2015 - Dec 6, 2014 at 11:42 PM
Related:
- Help me on this formula to shorten
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
- Credit summation formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Nov 24, 2014 at 11:44 AM
Nov 24, 2014 at 11:44 AM
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.
Nov 26, 2014 at 12:31 AM
Nov 26, 2014 at 01:37 AM
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),"*","")
Dec 4, 2014 at 10:16 AM
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
Dec 6, 2014 at 11:42 PM