A
Ajay
I have 3 data sheets:
Sheet1, sheet2, sheet3
From Sheet1 a value V1 is taken and looked up in Sheet2 another value
corresponding to V1 ia taken say V2 (I tried doing this by Vlookup and am
able to do find V1 and take V2) and V2 is checked in Sheet3 in data which is
arranged horizontally and under this value I have a lot of values in the same
column.
I want to select this range of data and then count the number of cells for a
particular value.
How can i do it ?
Sheet1, sheet2, sheet3
From Sheet1 a value V1 is taken and looked up in Sheet2 another value
corresponding to V1 ia taken say V2 (I tried doing this by Vlookup and am
able to do find V1 and take V2) and V2 is checked in Sheet3 in data which is
arranged horizontally and under this value I have a lot of values in the same
column.
I want to select this range of data and then count the number of cells for a
particular value.
How can i do it ?