I need a macro created for the example HELP!!

Closed
Savio - Apr 2, 2010 at 02:01 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 2, 2010 at 09:51 PM
Hello,

I have a two columns A and B as listed below:
A B C
Location Phone
CHENNAI 4458720241
CHENNAI 9945671511
CHENNAI 445878998
CHENNAI 928244139
MOBILE 944545266T908 1
CHENNAI 442555990T908 1
----------
2
-----------

This is a huge data of numbers under the B column (PHONE). I only want the phone numbers having T908 list as 1 in column C and at the end of the data in column C it must give me a sub total of the number in column C.

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Apr 2, 2010 at 09:51 PM
row i is having column headings and data is from row 2 from a2 b2

in C2 copy this formuola

=IF(ISNUMBER(SEARCH("T908",B2,1)),B2,"")
copy C2 down till data is there

in an empty cell before the data copy this formul

=COUNTIF(C2:C7,">?")

row 2 to row 7 has data

the result will be 2
0