Hi everyone,
I have 2 tables shown in the attachment with all details.
I want to read count of rows from another table to its original table.
The 2 tables, unfortunately, comes from 2 different sources.
Thank you and best wishes.
Hi everyone,
I have 2 tables shown in the attachment with all details.
I want to read count of rows from another table to its original table.
The 2 tables, unfortunately, comes from 2 different sources.
Thank you and best wishes.
Put this formula in L4:
=COUNTIFS($F$4:$F$16,$K4,$I$4:$I$16,L$3)
then copy across and down as required.
Hope this helps.
Pete
Thanks Pete for your quick response, it worked.
Now, total unit =COUNTIF($F$4:$F$16,$K4)
I should haven't wasted the whole day trying to learn relationship and power query.
Glad to have helped. Thanks for the rep.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks