S
Steve
I have this formula in columns of cells in 'sheet A'! D column, and the
result is various numbers, e.g. 1 thru 10
=IF(COUNTIF(MasterTab!$BH$21:$BH$917,G13)>0,COUNTIF(MasterTab!$BH$21:$BH$917,G13),"")
On the master tab, I also have column B that has various codes in some of
the cells.
And also, on the master tab, in column E, have numbers that may match the
G13 in the above formula.
I need a formula in the A column of sheet A, that has to count the number of
times the letter u shows up in the 'master Tab'!B column when the 'master
tab'!E column matches G13.
If g13 in the above formula =158
So in the below, the result should be 3, which is the first um for 158, the
second um for 158, and the last uc for 158. 3 times the u matches the 158's.
B E
uc 144
um 158
um 158
um 144
uc 158
I hope this makes sense ?
Thanks,
Steve
result is various numbers, e.g. 1 thru 10
=IF(COUNTIF(MasterTab!$BH$21:$BH$917,G13)>0,COUNTIF(MasterTab!$BH$21:$BH$917,G13),"")
On the master tab, I also have column B that has various codes in some of
the cells.
And also, on the master tab, in column E, have numbers that may match the
G13 in the above formula.
I need a formula in the A column of sheet A, that has to count the number of
times the letter u shows up in the 'master Tab'!B column when the 'master
tab'!E column matches G13.
If g13 in the above formula =158
So in the below, the result should be 3, which is the first um for 158, the
second um for 158, and the last uc for 158. 3 times the u matches the 158's.
B E
uc 144
um 158
um 158
um 144
uc 158
I hope this makes sense ?
Thanks,
Steve