Last seen: Jul 7, 2026
John, I'm confused. In your very first post you mentioned that you wanted to count unique company names. The example in your last post suggests tha...
One way to achieve this would be to connect to the workbook containing the lists with Power Query and load them to a hidden worksheet in every file wh...
In the Added Custom step, allow for the decimal point to be included. Text.Select([Values],{"0".."9", "."}) Then change the data type fo...
Glad I could help!
I assumed you are wanting a formula for column I in the Staff List. See if the attached file works for you.
See if the example in the attached file does what you need. It's the data table with a Power Pivot that displays a distinct count of Companies by cont...
No Excel sheet was attached. Please try again. This time, press 'Start upload' before you submit your reply.
Hi John, Impressive pictures and a very detailed Word doc, but it's too much detail to comprehend. Can't we focus on your initial table? From it yo...
Not sure what you mean by "unique count of companies, and the count of each continents appearance after a slice is done". Good idea to upload a screen...
If you goal is to create a measure to take periods with no data into account, perhaps someone else can look into that. If, on the other hand you need ...
Perhaps the attached workbook contains an acceptable solution for you. I added a helper column with a lookup function to determine which bin each row ...
My formula sits in A39 and works as intended. It counts the number of unique company names in the table as displayed. Thus, without filter it counts 1...
Please share a file again. Difficult to diagnose otherwise.
If you can use UNIQUE it's not a version issue. The error message "not trying to type a formula ....." makes me believe that you need to use as semi-c...
Let's say the US style number is in A1 as a text "____12,350.05____" where the underscores indicate leading and trailing spaces. Would the formula bel...