+ Reply to Thread
Results 1 to 2 of 2

Find and Replace - if not found, add function?

  1. #1
    Registered User
    Join Date
    04-25-2017
    Location
    California
    MS-Off Ver
    Microsoft Office Profressional Plus 2016
    Posts
    1

    Find and Replace - if not found, add function?

    I use a barcode scanner connected via Bluetooth to scan asset tags (barcodes) into a spreadsheet. Afterwards I would to use the spreadsheet to conduct a physical inventory of various locations using a list of values.

    My goal: Scan a barcode and have the Find function Locate and Highlight the cell if the value is found in the list. If the barcode is scanned and the value is not located in the list, I would like the value to be added to the list (sheet).

    My question: Is there a function to find and highlight values in a list? If the value is not found in the list, is there a method to add the value to the list?

    Thanks,
    ZJ

  2. #2
    Forum Contributor
    Join Date
    01-05-2017
    Location
    New York
    MS-Off Ver
    Office 2016
    Posts
    206

    Re: Find and Replace - if not found, add function?

    I used cell C2 as the helper cell that the barcode will be scanned into.

    In my example, I put a conditional format in A2 using the formula =$A2=$C$2. Then I pressed ctrl+c and selected cells A3:A50 (just for demo purposes) and I selected paste special --> formats. This takes care of highlighting if the item is already found.

    Then I put in A3 =IF(COUNTIF($A$2:A2,$C$2)=0,$C$2,"") and pulled it down to A50. This inserts the item into column A if it is a new item. The only thing is that if the item is new then you need to copy out the formula and paste special --> values right away, or it will get messed up.

    Very amateur, but it works.
    Attached Files Attached Files
    Last edited by Raphaelp; 04-25-2017 at 05:29 PM.

+ 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] FIND Function; looking for an array of strings and returning found string value
    By loloduane in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-05-2014, 04:11 AM
  2. Replace & Find function
    By eaflynn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-22-2013, 08:04 PM
  3. [SOLVED] find and replace to not replace characters found as wildcards
    By sabutler4 in forum Excel General
    Replies: 4
    Last Post: 07-03-2013, 06:48 PM
  4. find and replace function
    By tkeeper in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-18-2013, 05:20 AM
  5. How to find and replace with function?
    By yannipr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-12-2008, 07:27 AM
  6. Find and Compare against a diff. wkbk list and replace as found in another Wkbk.
    By salkovsg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-04-2007, 07:46 PM
  7. find and replace function
    By araki in forum Excel General
    Replies: 0
    Last Post: 03-11-2005, 02:33 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