Counting Pre-existing Combination of certain combination of column exist and report if missing or extra .

querylal

New Member
Joined
Nov 13, 2017
Messages
14
I have one worksheet name measurementIdentity where I want to count preexisting combination (column D,H,I and J) for each Cell (unique value of column C) and band (Column K). from audit list result you will know which condition is preexisting and which is extra and which is missing. I have more list of combination which I will edit later after your solution.

Thanks once again for your time. Requires asap.




measurementIdentity.xlsx
A
B
C
D
E
F
G
H
I
J
K
Name1
Name2
Sector_Carrier
Measurement_Identity
Name3
Name4
Name5
measurement purpose
ReportConfig
MeasurementObject
Band
78001_1
0
Mobility-Intra-Freq
0
0
700
78001_1
1
Cell-Edge-Intra-Freq-UL-CoMP-JR
1
0
700
78001_1
11
Report-CGI
21
2
700
78001_1
15
Automatic-Neighbor-Relation
15
0
700
78001_1
19
Leaving-Coverage-Alarm
27
0
700
78001_1_2
1
Cell-Edge-Intra-Freq-UL-CoMP-JR
1
1
AWS
78001_1_2
2
Mobility-Intra-Freq
0
1
AWS
78001_1_2
4
Below-Serving-Floor
3
1
AWS
78001_1_2
11
Report-CGI
21
2
AWS
78001_1_2
16
Automatic-Neighbor-Relation
15
1
AWS
78001_1_4
1
Cell-Edge-Intra-Freq-UL-CoMP-JR
1
2
PCS
78001_1_4
2
Mobility-Intra-Freq
0
2
PCS
78001_1_4
4
Below-Serving-Floor
3
2
PCS

<tbody>
</tbody>



I want to create another sheet name Auditsheet.xlsx based on above audit and it will look like below

Auditsheet.xlsx
Sector Carrier
Audit
Error
78001_1
1.MeasuremetnIdentity 11-Measurement Purpose Report CGI-ReportConfig21-Measurement Object2 should not exist.

2. MeasurementIdentity 0-Measurement Purpose Mobility Intra Freq-ReportConfig 0-Measurement Object0 is extra combination

3. MeasurementIdentity 40- Measurement Purpose PcmdorTrace-ReportConfig 10-MeasurementObject 0 is missing
Yes
78001_1_2
Measurement Identity 22-Measureement Purpose Report CGI-RerportConfig21 -MeasurementObject 0 is missing
78001_1_4
No

<tbody>
</tbody>
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
I have one worksheet name measurementIdentity where I want to count preexisting combination (column D,H,I and J) for each Cell (unique value of column C) and band (Column K). from audit list result you will know which condition is preexisting and which is extra and which is missing. I have more list of combination which I will edit later after your solution.

Thanks once again for your time. Requires asap.




measurementIdentity.xlsx
ABCDEFGHIJK
Name1Name2Sector_CarrierMeasurement_IdentityName3Name4Name5measurement purposeReportConfigMeasurementObjectBand
78001_10Mobility-Intra-Freq00700
78001_11Cell-Edge-Intra-Freq-UL-CoMP-JR10700
78001_111Report-CGI212700
78001_115Automatic-Neighbor-Relation150700
78001_119Leaving-Coverage-Alarm270700
78001_1_21Cell-Edge-Intra-Freq-UL-CoMP-JR11AWS
78001_1_22Mobility-Intra-Freq01AWS
78001_1_24Below-Serving-Floor31AWS
78001_1_211Report-CGI212AWS
78001_1_216Automatic-Neighbor-Relation151AWS
78001_1_41Cell-Edge-Intra-Freq-UL-CoMP-JR12PCS
78001_1_42Mobility-Intra-Freq02PCS
78001_1_44Below-Serving-Floor32PCS

<tbody>
</tbody>



I want to create another sheet name Auditsheet.xlsx based on above audit and it will look like below

Auditsheet.xlsx
Sector CarrierAuditError
78001_11.MeasuremetnIdentity 11-Measurement Purpose Report CGI-ReportConfig21-Measurement Object2 should not exist.

2. MeasurementIdentity 0-Measurement Purpose Mobility Intra Freq-ReportConfig 0-Measurement Object0 is extra combination

3. MeasurementIdentity 40- Measurement Purpose PcmdorTrace-ReportConfig 10-MeasurementObject 0 is missing
Yes
78001_1_2Measurement Identity 22-Measureement Purpose Report CGI-RerportConfig21 -MeasurementObject 0 is missing
78001_1_4No

<tbody>
</tbody>
Can some one please help
 
Upvote 0

Forum statistics

Threads
1,213,496
Messages
6,113,995
Members
448,539
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top