+ Reply to Thread
Results 1 to 10 of 10

Create a sepearte column baesd on the data in other columns

  1. 08-13-2016, 04:07 AM #1
    jeevan34
    jeevan34 is offline
    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
    Reply With QuoteRegister To Reply
  2. 08-13-2016, 04:13 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,388

    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.
    Reply With QuoteRegister To Reply
  3. 08-13-2016, 06:11 AM #3
    jeevan34
    jeevan34 is offline
    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
    Reply With QuoteRegister To Reply
  4. 08-13-2016, 06:18 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,388

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

    You are going to need to explain what the codes mean.
    Reply With QuoteRegister To Reply
  5. 08-13-2016, 06:22 AM #5
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,388

    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.
    Reply With QuoteRegister To Reply
  6. 08-13-2016, 06:29 AM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,388

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

    Try this:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 08-13-2016, 10:43 AM #7
    jeevan34
    jeevan34 is offline
    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
    Reply With QuoteRegister To Reply
  8. 08-13-2016, 10:48 AM #8
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,388

    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.
    Reply With QuoteRegister To Reply
  9. 08-13-2016, 11:10 AM #9
    jeevan34
    jeevan34 is offline
    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!
    Reply With QuoteRegister To Reply
  10. 08-13-2016, 11:12 AM #10
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2405 (Windows 11 23H2 64-bit)
    Posts
    81,388

    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. Compare data in two columns and create a data on third column based on the comparison
    By shilpak in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-15-2013, 01:23 PM
  4. [SOLVED] an I create a PivotTable with two columns of data for the same Column header?
    By RogeratCCCC in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1