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 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 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 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.
