Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 534
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
Hi All, we have the following sheet, where we want to some result based on some condition, we required any formula or any other option except VBA
we need the result like below, it is just a sample result, but we want to add "from date" and "To Date" so that we can get filtered result bases on date and also want to add Number of Invoice,
help pls
Book2 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | Sl. No | Invoice No. | Invoice Dt. | Buyer | City | District | Region | State | Bill Amount | ||
2 | 1 | USA/AUS/571 | 06-10-2020 | Test 1 | HINDAUN CITY | KARAULI | BHARATPUR REGION | Rajasthan | 2500351 | ||
3 | 2 | USA/AUS/572 | 06-10-2020 | Test 2 | JAIPUR | JAIPUR | JAIPUR REGION | Rajasthan | 4500321 | ||
4 | 3 | USA/AUS/269 | 07-10-2020 | Test 3 | MORADABAD | MORADABAD | BAREILLY REGION | Uttar Pradesh | 6254872 | ||
5 | 4 | USA/AUS/270 | 08-10-2020 | Test 4 | GHAZIPUR | GHAZIPUR | VARANASI REGION | Uttar Pradesh | 7458651 | ||
6 | 5 | USA/AUS/41 | 08-10-2020 | Test 5 | PATNA | PATNA | BRANCH | Bihar | 4322750 | ||
7 | 6 | USA/AUS/573 | 06-11-2020 | Test 6 | WARORA | CHANDRAPUR | Maharashtra | 3565822 | |||
8 | 7 | USA/AUS/574 | 06-11-2020 | Test 7 | ERNAKULAM | ERNAKULAM | Kerala | 58874465 | |||
9 | 8 | USA/AUS/575 | 05-12-2020 | Test 1 | ERNAKULAM | ERNAKULAM | Kerala | 12465847 | |||
Sheet1 |
we need the result like below, it is just a sample result, but we want to add "from date" and "To Date" so that we can get filtered result bases on date and also want to add Number of Invoice,
New Microsoft Excel Worksheet.xlsx | ||||
---|---|---|---|---|
A | B | |||
6 | Uttar Pradesh | 13713523 | ||
7 | GHAZIPUR | 7458651 | ||
8 | GHAZIPUR | 7458651 | ||
9 | VARANASI REGION | 7458651 | ||
10 | MORADABAD | 6254872 | ||
11 | MORADABAD | 6254872 | ||
12 | BAREILLY REGION | 6254872 | ||
13 | Grand Total | 99943079 | ||
Sheet2 |
help pls