V VDS Member Aug 11, 2015 #1 Dear All, As per the attached excel file, I want to count how many case nos are there against each LR Nos. Say For LR No.0001, result will be 4 and like that. VDS Attachments PANDIABIL-Shipment-390.xlsx PANDIABIL-Shipment-390.xlsx 44.6 KB · Views: 2
Dear All, As per the attached excel file, I want to count how many case nos are there against each LR Nos. Say For LR No.0001, result will be 4 and like that. VDS
eibi Active Member Aug 11, 2015 #2 In Cell D2: =IF(C2="","",COUNTIF(B:B,C2)) Drag to fill other cells. Conditional Formatting applied to make cells orange as in your sample file. See attached. All best. Attachments VDS1.xlsx VDS1.xlsx 45.7 KB · Views: 2
In Cell D2: =IF(C2="","",COUNTIF(B:B,C2)) Drag to fill other cells. Conditional Formatting applied to make cells orange as in your sample file. See attached. All best.
eibi Active Member Aug 11, 2015 #3 I'd propose that a pivot table is a much faster and concise way to provide the data you're requesting....AND....no formulas required! It just takes about 30 seconds to set up. Very simple. See attached. Attachments VDS2.xlsx VDS2.xlsx 47.6 KB · Views: 2
I'd propose that a pivot table is a much faster and concise way to provide the data you're requesting....AND....no formulas required! It just takes about 30 seconds to set up. Very simple. See attached.
