COLUMN COUNT EXCEL

Help Activities
, ,
1

I AM TRYING TO TAKE EXCEL COLUMN COUNT IN WHICH

THE SHIFT COLUMN IS A AND FROM STATUS COLUMN I NEED TO SELECT P, HLF,SRT,MIS

AND THE CONDITION WHICH I GAVE IS NOT WORKING

sheet1.Select(" [Shift] ='A ’ AND [Status] =‘P’ AND [Status] ='HLF 'AND [Status] ='SRT ’ AND [Status] ='MIS ’ ").Count

KINDLY GIVE ME THE CORRECT LOGIC FOR THIS

3

@poojaskyrathore

change to this

sheet1.Select(" [Shift] ='A ' AND ([Status] ='P' OR [Status] ='HLF ' OR [Status] ='SRT ' OR [Status] ='MIS ') ").Count

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.