Hi All,
I am in need of a code that will automatically filter out Zeros from a Table,
When using table slicers to select different data periods the table should only show data if Column B is not a Zero.
Could someone help me with this please as current codes i have found are based on column ranges not a table and doesn't auto update after cell changes
thanks!
I am in need of a code that will automatically filter out Zeros from a Table,
When using table slicers to select different data periods the table should only show data if Column B is not a Zero.
Could someone help me with this please as current codes i have found are based on column ranges not a table and doesn't auto update after cell changes
thanks!