+ Reply to Thread
Results 1 to 2 of 2

Extrapolating wordvalues from table

  1. #1
    Registered User
    Join Date
    05-16-2020
    Location
    Leuven, Belgium
    MS-Off Ver
    16
    Posts
    1

    Extrapolating wordvalues from table

    Hey all!

    I'm new here, and I've got a question. I already searched for it online, yet I cannot find an answer. This is my problem:

    I've got a list of adjectives (250K+) in a column, and another table containing 4000 very frequent adjectives in column A, and a value between 1 and 7 in column B, which signifies the polarity of the adjective in column A. For instance, I've got a word 'nice' in column A, for which the value in column B is 6.1; I've got another word 'bad', for which the value in column B is 1.8.

    I want to use this table and these data to tag my first list of 250.000 adjectives with a + or - (or a yes/no, doesn't really matter) which signifies positive polarity or negative polarity. I want a formule to tag a row with + if the word in that row has a value higher than 3.5 in the other table, and I want that formule to tag the row with a - if the value of the adjective in that row is less than 3.5 . Is there a formule any of you know to tag these adectives in the first list using the data from the second list?

    Thanks!
    LM

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2504 Win 11
    Posts
    24,705

    Re: Extrapolating wordvalues from table

    please read the yellow banner at the top of this page on how to attach a file.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Extrapolating data
    By sherlock1241 in forum Excel General
    Replies: 3
    Last Post: 04-21-2015, 12:03 PM
  2. Extrapolating Information out of a Cell
    By bmerch in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-06-2012, 01:53 PM
  3. need help in extrapolating to create a chart.
    By hydroboss in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-02-2012, 04:51 PM
  4. Extrapolating data within a table
    By MacroIdiot in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-25-2011, 12:20 PM
  5. Extrapolating spreadsheet data
    By djohnalyn in forum Excel General
    Replies: 4
    Last Post: 07-06-2011, 05:58 PM
  6. Extrapolating a top ten
    By burnst83 in forum Excel General
    Replies: 3
    Last Post: 12-10-2009, 07:08 PM
  7. extrapolating a graph
    By Peter in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-29-2006, 06:25 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1