PrakashGunabalan
New Member
- Joined
- Oct 26, 2024
- Messages
- 6
- Office Version
- Prefer Not To Say
- Platform
- Windows
i want pull the jan month data to sheet 2, xlookup & filter function is available in system
can someone help out with alternate excel formula
can someone help out with alternate excel formula
Sales Month | Product | Location |
Jan | Product1 | Location 1 |
Jan | Product1 | Location 1 |
Jan | Product2 | Location 2 |
Jan | Product2 | Location 2 |
Jan | Product1 | Location 3 |
Feb | Product1 | Location 1 |
Feb | Product1 | Location 1 |
Feb | Product2 | Location 2 |
Feb | Product2 | Location 2 |
Feb | Product1 | Location 3 |
Mar | Product2 | Location 2 |
Mar | Product2 | Location 2 |
Mar | Product1 | Location 3 |
Mar | Product1 | Location 1 |
Mar | Product1 | Location 1 |