Need help ordering duplicated values in table
Hello! I have a table with thousands of duplicate IDs and I am trying to create an sequential order to show how many times the IDs are listed. The CountIF function gives me the total count listed on each row and that is not what I am looking for. Any help is much appreciated. Thank you!
MBR_CONTR_EXT_IDCountIfWhat I want800117684-0011800117800-0021800117800-0022800117805-0021800117818-0021800117921-0011800117979-0011800118080-0021800118080-0022800118207-0011800118291-0011800118294-0011800118308-0041800118308-0042800118528-0011800118627-0011800118730-0021800118746-0031800118747-0051800118747-0052800118747-0053800118797-0051800118797-0052800118797-0053800118797-0054800118797-0055
Hello! I have a table with thousands of duplicate IDs and I am trying to create an sequential order to show how many times the IDs are listed. The CountIF function gives me the total count listed on each row and that is not what I am looking for. Any help is much appreciated. Thank you! MBR_CONTR_EXT_IDCountIfWhat I want800117684-0011800117800-0021800117800-0022800117805-0021800117818-0021800117921-0011800117979-0011800118080-0021800118080-0022800118207-0011800118291-0011800118294-0011800118308-0041800118308-0042800118528-0011800118627-0011800118730-0021800118746-0031800118747-0051800118747-0052800118747-0053800118797-0051800118797-0052800118797-0053800118797-0054800118797-0055 Read More