Results 1 to 7 of 7

String multiple text per conditions

Threaded View

MrStyx String multiple text per... 12-24-2008, 07:06 AM
daddylonglegs To get exacly those results... 12-24-2008, 07:11 AM
martindwilson =COUNTIF(A:A,"=cat") or... 12-24-2008, 07:13 AM
Andy Pope If D2 and copied across. ... 12-24-2008, 07:17 AM
oldchippy Or may be =REPT(D1&",... 12-24-2008, 07:18 AM
daddylonglegs I like that one... 12-24-2008, 07:34 AM
MrStyx WOW You lot truly are... 12-24-2008, 07:45 AM
  1. #1
    Registered User
    Join Date
    11-03-2008
    Location
    Swindon
    MS-Off Ver
    XP Office 2002
    Posts
    7

    String multiple text per conditions

    Hi all,

    Trying to concatenate cells if they meet specific criteria ie:

    A1 - dog
    A2 - dog
    A3 - dog
    A4 - cat
    A5 - cat
    A6 - cow
    A7 - cow
    A8 - cow

    Then in B1 if searching all of A:A and the result is "Dog" then put the amount of "dog" in the cell e.g "dog, dog, dog"

    B2 if searching all of A:A and the result is "Cat" then put the amount of "cat" in the cell e.g "cat, cat"

    I hope this makes sense. Thanks all inadvance. I have attached an example of how it should look once working.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1