'EXCEL filter column A that has multiple B value
im not an expert in excel, but right now i have an excel with more than 80k data this data contains provinces cities districts and zipcode, i want to filter and copies all districts that has more than one zipcode, is this posible?
e.g:
District Zipcode
LOVE 10000
LOVE 10000
LOVE 10000
LOVE 10000
HATE 12000
HATE 12000
HATE 12000
HATE 12030
HATE 12031
from above example i wanna get HATE district, can someone help me ? what formula do i need? thanks a lot
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|