Hi I'm trying to make a formula to copy a list of names from a excel pivot table sheet to another sheet however at the end of the list is unwanted text "(blank)" and I have no control over how long the list of names could be because the number if names can change. The list of names are all original in other word there are no names the same.
E.g. in my second list I don't want the word (blank) to appear. I just want a blank cell.
Scott
Steve
John
Ken
Simon
Denis
(blank)
=A1
=A2
=A3
etc.
My other problem is that it is also returning a Zero result for the cells below the pivot table.
So the current result I'm getting is:
Scott
Steve
John
Ken
Simon
Denis
(blank)
0
0
0
0
0
0
0
0
Please can you help
E.g. in my second list I don't want the word (blank) to appear. I just want a blank cell.
Scott
Steve
John
Ken
Simon
Denis
(blank)
=A1
=A2
=A3
etc.
My other problem is that it is also returning a Zero result for the cells below the pivot table.
So the current result I'm getting is:
Scott
Steve
John
Ken
Simon
Denis
(blank)
0
0
0
0
0
0
0
0
Please can you help
