Hi,
I have the attached data, and to sort them automatically in different columns as per the attached
Hi,
I have the attached data, and to sort them automatically in different columns as per the attached
In I2, enter:
Formula:Please Login or Register to view this content.
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Copy across / down.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Thanks a million
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You can also add reputation to those who helped you. Thanks.
thanks alot, will do that, but a small question, if for the same data i need to ignore duplicates, can you tell how
This will list distinct values:
Formula:Please Login or Register to view this content.
...again, confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Thanks alot
Happy to help! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. You can also Add Reputation to those who helped you. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks