let's try it one more time


I had posted this same question. I did not get a good answer. But now I
have simplified my own question. Hope this will help. I need a formula
that deletes entire row based on a criteria. For example
row 1 - contains what i need, so keep it
row 2 - contains a data that I would like to delete
row 3 - same as row 1, keep
row 4 - same as row 2, delete
What is common for the rows that I want to delete is they all start
with a number while the rows to keep start with letters. This is TRUE
up to row 151 and is reversed from row 152 up to row 347 i.e. I would
like to keep row 152 but delete row 153 etc
Please help




--
ab3d4u
.

Relevant Pages

  • Re: Index & Match
    ... We need to find a criteria that is common and unique to the specific columns ... This pattern of every 6th cell repeats to the end of your range. ... the column heading I have numerical data in rows 3 -15. ...
    (microsoft.public.excel.misc)
  • =?iso-8859-1?q?Re:_ETYMOL_es,ar_C=E1ceres?=
    ... By this criteria, the sounds of some Hebrew letters were similar to: ... Supporting evidence for these sounds is found in the shape of Rashi ... Greek gyneco- reverses to Cana3an ...
    (sci.lang)
  • Re: Christian name abbreviation
    ... superscript H indicates that there have been letters omitted. ... Josiah is not a particularly common name till the C19, nor, for that matter, is Joshua, and this type of abbreviation became less common. ...
    (soc.genealogy.britain)
  • Re: Alexis Nasedkin
    ... LaVirtuosa appears to have caused the following letters ... extra-musical associations in common which shows the versatility of ...
    (rec.music.classical.recordings)
  • Re: String containing algorithm
    ... >> which takes two Strings of any lengths and returns any letters which are ... > "longest common substring" search. ... > the set of common characters by intersecting the sets. ...
    (comp.lang.java.programmer)
Loading