Hi all
I want to find formula that will count same entries and mark them not how many entires exist but from top down fisrt A shold be 1 and swcond founded A should be 2
Column 1 - Column 2
A - 1
B - 1
C - 1
A - 2
A - 3
B - 2
C - 2
In regular table or excel i know to formula, so just lock fisr row and than in next row formual loocking first and second and so one. But i could not find the right or prober formula to do that in Power Query
Thank you for your help
Last edited by zeko90; 03-31-2019 at 02:44 PM.
Something like:
See https://excel.solutions/xlf_1270453/ for worked example file
Please Login or Register to view this content.
Last edited by Olly; 03-30-2019 at 05:20 PM.
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...
Dear Olly, thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks