Recent DiscussionsMost RecentNewest TopicsMost LikesSolutionsTagged:TagFormula required Can anyone help me with a formula please? I need to find all blank cells within a column and delete all the rows containing the blank cells. Thankyou Re: FIND AND COPYJust tested your formula on the entire spreadsheet. AMAZING! It works a treat. Does exactly what I wanted. Thank you so much for your help.Re: FIND AND COPYI should add that if the record does not include pack of* then the quantity will be 1Re: FIND AND COPYTried your formula Sergei. works fine on records ending in pack of * but get #VALUE error for records that don't end in pack of *Re: FIND AND COPYIf I could get pack of * in an adjacent column I could then use find and replace to remove pack of.Re: FIND AND COPYSeems a bit complicated Been trying data tab followed by advanced but can't get the criteria right. Is this a possibility?Re: FIND AND COPYDescription field might read CUTTING DISC 115 x 1MM PACK OF 5 or SINGLE EDGE BLADES PACK OF 100FIND AND COPY I have a huge spreadsheet with lots of pack of qty entries in the description column. How do I set about copying the qty into a separate column on the spreadsheet? Solved
