route217
asked on
Formula returning #N/A
Hi Experts using excel 2010
I have the following formula in my workbook which works fine for all rows expect 6 row....where it returns #N/A
=INDEX(AC63:AH63,MATCH(REP T("C",255) ,AC63:AH63 ))
in columns AC to AH i have G G G C
it should return back C but returns back #n/a for this row only...
I have the following formula in my workbook which works fine for all rows expect 6 row....where it returns #N/A
=INDEX(AC63:AH63,MATCH(REP
in columns AC to AH i have G G G C
it should return back C but returns back #n/a for this row only...
ASKER
Hi SHUMS
I what the formula to return back C...
So if I have G G G G C C .. the c indicates that the job is complete..if no c the blank
I what the formula to return back C...
So if I have G G G G C C .. the c indicates that the job is complete..if no c the blank
Tell me the full range, because your formula has just one row 63.
ASKER
Full rnge is 1 row.
Full formula is
=IFERROR (IF (INDEX(AC63:AH63,MATCH(REP T("C",255) ,AC63:AH63 ))="C",MAX (CG63:CL63),"")
Full formula is
=IFERROR (IF (INDEX(AC63:AH63,MATCH(REP
What is in CG63:CL63?
Try this:
Try this:
=IFERROR(IF(INDEX(AC63:AH63,MATCH(REPT("C",255),AC63:AH63))="C",MAX (CG63:CL63),""),"C")
ASKER
Find the max date once we have c..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent. ..thanks
You're Welcome! Pleased to help
Try below formula for whole column AC to AH
Open in new window