Feb 28 2023 07:44 AM
Hi all,
I was wondering if anyone could help with a sorting problem I currently have.
I’ve got a spreadsheet in excel with a Column which includes USD & CAD. (Both shown in this format as opposed to $ etc) Is there a way I can filter the column via these currencies? I’ve attempted numerous methods but haven’t been able to make any progress.
If anyone is able to help I’d greatly appreciate it !
Many Thanks
Feb 28 2023 01:53 PM
I fear you'll have to create a separate column that contains USD or CAD as text, and filter on that.