+ Reply to Thread
Results 1 to 10 of 10

Create a sepearte column baesd on the data in other columns

  1. #1
    Registered User
    Join Date
    08-13-2016
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    4

    Create a sepearte column baesd on the data in other columns

    Hello all,

    I have a table about countries and their cities information , which i exported from Access. now, I Need to create a new column(Shortcut) specifying C/S for each Country first row and only S for other rows. (I.e based on the data in Countries and Cities column). Pleaase see the attachments
    Attached Images Attached Images

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2312 (Windows 11 22H2 64-bit)
    Posts
    75,345

    Re: Create a sepearte column baesd on the data in other columns

    Try this:

    =IF(COUNTIF($B$1:B1,B1)=1,"C/S","S")
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    08-13-2016
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    4

    Re: Create a sepearte column baesd on the data in other columns

    Thank you so much It worked!!

    What if i have one more column?? Help me wih tis too..pic2.JPG

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2312 (Windows 11 22H2 64-bit)
    Posts
    75,345

    Re: Create a sepearte column baesd on the data in other columns

    You are going to need to explain what the codes mean.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2312 (Windows 11 22H2 64-bit)
    Posts
    75,345

    Re: Create a sepearte column baesd on the data in other columns

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2312 (Windows 11 22H2 64-bit)
    Posts
    75,345

    Re: Create a sepearte column baesd on the data in other columns

    Try this:

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    08-13-2016
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    4

    Re: Create a sepearte column baesd on the data in other columns

    Hi Ali,

    I tried that but its not working. Attached , you can find the result I got after executing above the formula. I tried making some changes but still no use.pic.JPG. I also, attached a sample workbook with before sheet and after sheet. Please look at that.
    Attached Files Attached Files

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2312 (Windows 11 22H2 64-bit)
    Posts
    75,345

    Re: Create a sepearte column baesd on the data in other columns

    Explain to me why row 13 is C/S/R and not just S/R, please.

    With the exception of row 13, this works:
    Please Login or Register  to view this content.
    Why did you not change the arrays to match your data???
    Last edited by AliGW; 08-13-2016 at 10:54 AM.

  9. #9
    Registered User
    Join Date
    08-13-2016
    Location
    Germany
    MS-Off Ver
    2013
    Posts
    4

    Re: Create a sepearte column baesd on the data in other columns

    Awesome..It worked Thanks a ton

    Row 13 is S/R. Its my mistake. sorry!

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2312 (Windows 11 22H2 64-bit)
    Posts
    75,345

    Re: Create a sepearte column baesd on the data in other columns

    I'm glad we got there in the end!!!

    Mach's gut!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Move data over baesd on text in specific column to dashboard
    By Thanks4helping in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-29-2015, 07:18 PM
  2. Merge two columns to create 1 column with all the data
    By Simon.xlsx in forum Excel General
    Replies: 4
    Last Post: 03-12-2014, 09:04 AM
  3. Replies: 1
    Last Post: 01-15-2013, 01:23 PM
  4. Replies: 2
    Last Post: 12-24-2012, 12:46 PM
  5. Create one new column of unique data from two columns
    By Lenshaw in forum Excel General
    Replies: 6
    Last Post: 10-01-2012, 09:12 AM
  6. How to create report on sepearte sheet
    By mchavoya_perez in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-25-2011, 02:38 AM
  7. Text to Columns with EACH character in sepearte column?
    By flipmode in forum Excel General
    Replies: 2
    Last Post: 10-05-2007, 12:58 PM

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