Santosh080
Board Regular
- Joined
- Jul 15, 2016
- Messages
- 77
- Office Version
- 2021
- Platform
- Windows
hello friends
Need help with count function. I have a excel file data like this,
i need data like this,
In "Number of item" i want number of items that must match "Name", "Place Pin" and " Name of Item".
Like i want to count where Place =AAA, Place Pin=125, Name Item =Pen and Key. Here the result will be 3.
please help.
Need help with count function. I have a excel file data like this,
Place | Place Pin | Name of Items |
AAA | 125 | PEN |
CCC | 254 | KEY |
AAA | 146 | PEN |
TTT | 142 | PENCIL |
JJJ | 547 | ERASER |
AAA | 125 | PEN |
AAA | 125 | KEY |
DDD | 147 | GOLD |
DDD | 147 | KEY |
i need data like this,
Name | Place Pin | Number of items |
AAA | 125 | ??? |
In "Number of item" i want number of items that must match "Name", "Place Pin" and " Name of Item".
Like i want to count where Place =AAA, Place Pin=125, Name Item =Pen and Key. Here the result will be 3.
please help.