I need a macro created for the example HELP!!
Closed
Savio
-
Apr 2, 2010 at 02:01 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 2, 2010 at 09:51 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 2, 2010 at 09:51 PM
Related:
- I need a macro created for the example HELP!!
- Create a yahoo email account for free - Guide
- Spell number in excel without macro - Guide
- Create a snapchat account - Guide
- Macro excel download - Download - Spreadsheets
- Automatically run a macro when opening a worksheet - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Apr 2, 2010 at 09:51 PM
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
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
