S
Sudha
Please help me with the formula for the below tables
Shop 1 Shop2
NAME NUMBER OF ITEMS NAME NO OF ITEMS
Apples 40 Banana 15
Banana 25 Guava 20
Grapes 30 Pineapples 13
Orange 50 Orange 27
I need the result in the below format.
NAME NUMBER OF ITEMS
Shop 1 Shop2
Apples 40 #N/A
Banana 25 14
Grapes 30 #N/A
Guava #N/A 20
Orange 50 27
Pineapples #N/A 13
Instead of #N/A, I would like to get 0. Please help me in this regard.
Thanks in Advance
Shop 1 Shop2
NAME NUMBER OF ITEMS NAME NO OF ITEMS
Apples 40 Banana 15
Banana 25 Guava 20
Grapes 30 Pineapples 13
Orange 50 Orange 27
I need the result in the below format.
NAME NUMBER OF ITEMS
Shop 1 Shop2
Apples 40 #N/A
Banana 25 14
Grapes 30 #N/A
Guava #N/A 20
Orange 50 27
Pineapples #N/A 13
Instead of #N/A, I would like to get 0. Please help me in this regard.
Thanks in Advance