+ Reply to Thread
Results 1 to 8 of 8

Identify a text based on number bigger than zero.

  1. 09-23-2022, 12:44 AM #1
    Sultan1994
    Sultan1994 is offline
    Forum Contributor
    Join Date
    02-20-2022
    Location
    Indonesia
    MS-Off Ver
    Excel 2016
    Posts
    103

    Talking Identify a text based on number bigger than zero.

    Hello Friends,

    I have a problem to identify a text based on number bigger than zero.
    and make it in a one cell.

    Do you guys have any solution.
    Thanks before
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-23-2022, 02:53 AM #2
    HansDouwe
    HansDouwe is offline
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,408

    Re: Identify a text based on number bigger than zero.

    Please try:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 09-23-2022, 02:59 AM #3
    Crooza
    Crooza is offline
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Identify a text based on number bigger than zero.

    try this

    Please Login or Register  to view this content.
    in G2 and drag down
    Happy with my advice? Click on the * reputation button below
    Reply With QuoteRegister To Reply
  4. 09-23-2022, 03:17 AM #4
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Identify a text based on number bigger than zero.

    with Power Query

    is that way is ok for you?

    Unit List
    GA01 ECO 3 AD
    GA02 ECO 2 AD,ECO 3 AD,ECO 5 AD,ECO 7 AD
    GA03 ECO 3 AD,ECO 5 AD,ECO 7 AD
    GA04 ECO 3 AD,ECO 5 AD,ECO 7 AD,MICRO 100
    GA05 ECO 3 AD,ECO 5 AD,ECO 7 AD
    GA06 ECO 3 AD,ECO 5 AD
    GA07 ECO 2 AD,ECO 3 AD,ECO 5 AD,ECO 7 AD
    GA08 ECO 3 AD,ECO 5 AD,ECO 7 AD
    Reply With QuoteRegister To Reply
  5. 09-26-2022, 03:05 AM #5
    Sultan1994
    Sultan1994 is offline
    Forum Contributor
    Join Date
    02-20-2022
    Location
    Indonesia
    MS-Off Ver
    Excel 2016
    Posts
    103

    Re: Identify a text based on number bigger than zero.

    Yes, it's good
    Reply With QuoteRegister To Reply
  6. 09-26-2022, 07:07 AM #6
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Identify a text based on number bigger than zero.

    which one?
    Reply With QuoteRegister To Reply
  7. 09-26-2022, 09:09 PM #7
    Sultan1994
    Sultan1994 is offline
    Forum Contributor
    Join Date
    02-20-2022
    Location
    Indonesia
    MS-Off Ver
    Excel 2016
    Posts
    103

    Re: Identify a text based on number bigger than zero.

    Quote Originally Posted by sandy666 View Post
    with Power Query

    is that way is ok for you?

    Unit List
    GA01 ECO 3 AD
    GA02 ECO 2 AD,ECO 3 AD,ECO 5 AD,ECO 7 AD
    GA03 ECO 3 AD,ECO 5 AD,ECO 7 AD
    GA04 ECO 3 AD,ECO 5 AD,ECO 7 AD,MICRO 100
    GA05 ECO 3 AD,ECO 5 AD,ECO 7 AD
    GA06 ECO 3 AD,ECO 5 AD
    GA07 ECO 2 AD,ECO 3 AD,ECO 5 AD,ECO 7 AD
    GA08 ECO 3 AD,ECO 5 AD,ECO 7 AD
    I still confuse how to use power query to do things. Can you enlighten me
    Reply With QuoteRegister To Reply
  8. 09-26-2022, 10:35 PM #8
    sandy666
    sandy666 is offline
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Identify a text based on number bigger than zero.

    Quote Originally Posted by Sultan1994 View Post
    I still confuse how to use power query to do things. Can you enlighten me
    sure

    Please Login or Register  to view this content.

    Click the Add Reputation at the foot of any of the posts of members who helped you
    Attached Files Attached Files
    Last edited by sandy666; 09-26-2022 at 10:41 PM.
    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. Identify Number to text in VBA code
    By Sultan1994 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-24-2022, 09:25 PM
  2. Have date ranges. Given a bigger date range, I need to identify gaps.
    By James Keuning in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-11-2019, 05:22 PM
  3. [SOLVED] Identify tariff based on number of pieces
    By forfiett in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-05-2018, 05:41 AM
  4. identify last row containing text in column B and use row number in cell range
    By mattmanslim in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-16-2017, 06:02 AM
  5. Require formula to identify a number, not text
    By Fbs1960 in forum Excel General
    Replies: 3
    Last Post: 12-17-2011, 06:55 AM
  6. Identify Row Number based on Value in a cell and use that Row number in a Macro
    By johnnywinter in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-28-2009, 06:02 PM
  7. [SOLVED] Can I identify a number from text in a list?
    By Ron in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-26-2005, 12:20 PM

Tags for this Thread

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