Apr 20 2020 06:48 AM
I want to count how many rows in my book that have values between the below values. How can I do this?
Apr 21 2020 03:50 AM
I managed to get the below result, but some values are in duplicate rows, for example, the value of 31 is in row 2 and 3. How do I have unique values on each row as my above image?
Thanks
Apr 21 2020 04:23 AM
SolutionThat concerns only the labels. You can check your source data. If it contains 218 values/rows then the result is valid.
Mike Girvin talked about this bug in a video a long time ago. Maybe you can find it.
Apr 21 2020 08:00 AM
Nov 03 2020 09:36 AM
@Detlef Lewin I am looking to format Pivot Table grouping. Sales grouping is in USD. However when trying to use accounting format (or a currency) it does not show up. Any way around this please?
Nov 03 2020 02:03 PM
Apr 21 2020 04:23 AM
SolutionThat concerns only the labels. You can check your source data. If it contains 218 values/rows then the result is valid.
Mike Girvin talked about this bug in a video a long time ago. Maybe you can find it.