+ Reply to Thread
Results 1 to 8 of 8

Cross Match Information and Replace in Right Collumn

  1. #1
    Registered User
    Join Date
    02-20-2024
    Location
    Lisbon
    MS-Off Ver
    2401
    Posts
    4

    Cross Match Information and Replace in Right Collumn

    I've exported some data from Facebook and im trying to put in order some posts according to the amount of likes.

    I have managed to pull some thumbnail links that allow me to quickly see how the post looks( Using =IMAGE() ) which saves me time while im sorting through thousands of posts.

    However, Facebook constantly changes URL links for thumbnails and now its showing me errors in the Preview Image collumn: "URL Signature Expired". (Can check on Sheet B: Link 6 Hyperlink)

    I was able to get new links for the feed posts in a new worksheet, but this new worksheet is not as organized as the other was. I want to be able to crossmatch using Something like: If the description of the post is equal, replace the url link.

    Thank you!
    Last edited by mktdata; 02-28-2024 at 01:21 PM.

  2. #2
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,139

    Re: Cross Match Information and Replace in Right Collumn

    Hi mktdata,

    Here is a file into which you can build out a sample for us:

    https://docs.google.com/spreadsheets...gid=2100307022

    Let us know when it is done.
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]

  3. #3
    Registered User
    Join Date
    02-20-2024
    Location
    Lisbon
    MS-Off Ver
    2401
    Posts
    4

    Re: Cross Match Information and Replace in Right Collumn

    Hi, I have modified it with the same example I gave on the initial post. Thanks!

  4. #4
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,139

    Re: Cross Match Information and Replace in Right Collumn

    I dont see any "URL Signature Failure" errors, or any column called "preview image".

    I suggest you improve your description by giving the correct names of columns, and also provide the column letters and row numbers where you want help, so that there is no confusion about what you are talking about.

  5. #5
    Registered User
    Join Date
    02-20-2024
    Location
    Lisbon
    MS-Off Ver
    2401
    Posts
    4

    Re: Cross Match Information and Replace in Right Collumn

    I have changed the description so its less confusing. (check initial post and Google spreadsheets above)

    The idea is to go to Sheet A, check and validate if it has the same Post description, if yes switch the link on Sheet B's "Full Picture" cell. In this example we have Link 5 (Sheet A) should switch with Link 6 (Sheet B).

    If for some reason there's no description it should cross match with the number of likes or shares in order to find the right order.

    Thank you in advance, im really trying to figure this out

  6. #6
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,139

    Re: Cross Match Information and Replace in Right Collumn

    Sheet B cell B2 has linked text "Link 1".

    Since this is not created by formula, the only way to get linked text to change is to use Apps Scripts.

    See example here: Add links to a cell in Google Sheets using Apps Script

  7. #7
    Registered User
    Join Date
    02-20-2024
    Location
    Lisbon
    MS-Off Ver
    2401
    Posts
    4

    Re: Cross Match Information and Replace in Right Collumn

    Hi, for some reason that spreadsheet you sent wasnt updated. Can you check again? So on Sheet A Link 5 should be switching with Link 6 on Sheet B(given that the post description matched). It can be copy pasted as a text as well, not obligatory to come as an Hyperlink.
    Last edited by mktdata; 02-29-2024 at 01:20 PM.

  8. #8
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,139

    Re: Cross Match Information and Replace in Right Collumn

    Hi mkdata,

    Sheet A and Sheet B have many different descriptions, so you still have the same issue that you cannot do this with formulas.

    Your only option is to use apps scripts.

+ 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. [SOLVED] Match Month and Year and Return Collumn to Right
    By djc123 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-05-2021, 10:30 AM
  2. Replies: 2
    Last Post: 06-15-2018, 11:43 AM
  3. [SOLVED] Find a collumn in a dynamic sheet and select the entire collumn
    By Armand0 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-03-2014, 11:20 AM
  4. Replies: 3
    Last Post: 07-19-2012, 02:52 AM
  5. Find exact match in two collumn. Please help
    By 11ktran44 in forum Excel General
    Replies: 1
    Last Post: 02-23-2012, 04:00 AM
  6. Lookup nearest Value in one Column and Match the next Collumn
    By tomlancaster in forum Excel General
    Replies: 4
    Last Post: 10-27-2009, 07:38 AM
  7. [SOLVED] replace the letters (for collumn) & numbers(row no.) of cell reference only
    By al007 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-14-2005, 12:50 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