Alcatel Unleashed

Transaction code colums on the General sheet is already in text format. So, what you need to do, is to change the format of the column A on the CODE sheet also to text

Dear Sadim,

I have changed the CODE sheet coloum A format to text and executed the report but the output is still #N/A.

FYI..In sheet1 both colum A & B , the cell formats are i kept as general.

Regards,
Rajan K.S

From what i understand, sheet 1 Column A should also be formated as text

Now i have changed the CODE & sheet1 colum as text format. But the generated excel report still i am getting as #N/A error. (

try to bring your code sheet into sheet1. maybe the formula has cannot see the code sheet at statistic generation process...

regards...


Gesendet von iPad mit Tapatalk

Hi Tgn,

I tried with same sheet, still i didn't success
I tried with different cell format, still after generate the report its failed to show the description and getting the error as #N/A

Regards,
Rajan