working with pivot table

Occasional Visitor

I am creating a checking account register pivot table which contains many (blank) cells, found information for using ;;; as a wild card but not on Mac version 16.38. Please advise

@salguodj 

 

1 Reply

@salguodj 

 

On my Mac (also Excel 16.38) the wild card has been the question mark (?) in place of single characters.

 

Is it possible for you to post the worksheet and ask the question a bit more completely?