Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to find out different vendors who have the same bank account. I need to show the exceptions only in a table or chart.
So out of the the following numbers, we should highlight only vendor abc, xyz with bank a/c 1 and yyy, sss with bank a/c 2 as exceptions because they have the same bank account.
Thanks
Bank Ac | Vendor |
1 | abc |
1 | xyz |
2 | yyy |
2 | sss |
3 | r |
4 | e |
5 | q |
6 | w |
See attached qvw. Is that what you're looking for?
Hi,
I'm not sure whether you want to show all records and highlight the double Vendors or just filter to show the relevant Bank Ac / Vendor combinations.
If the latter, then one solution could be:
hope this helps
regards
Marco
Thanks Marco, it works, appreciate it. If you don't mind and have some free time at hand, would you please explain what exactly you did? The formula is a little confusing for me
Nothing is attached
There really is a document attached. Try refreshing the page.
Hi,
the set expression restricts the bank accounts to those that belong to more than one vendor.
Try using the search string
=Count(Distinct Vendor)>1
manually to understand:
hope this helps
regards
Marco
Sunny Sahni wrote:
Nothing is attached
Please note that you don't see attachments from within the INBOX of the community forum. You need to click on the title to open the thread, then you should see all attachments, like Gysbert's one.