New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Organizing columns of numbers

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Organizing columns of numbers

Postby Randyww » Thu Jul 07, 2016 7:34 pm

I have 20 to 30 account numbers sent to me each day. I have to match them up with a filled or not filled code which is attached to another column of 200 accounts. Is there a way to have the first set interrogate the second set and either change colour or generate a filled or not filled notification.
  • 0

Randyww
Rookie
 
Posts: 1
Joined: Jul 7, 2016
Reputation: 0
Excel Version: Excel 2016

Re: Organizing columns of numbers

Postby pecoflyer » Fri Jul 08, 2016 2:27 am

Hi
yes there are many techniques.

Please post a sample sheet ( no pics please). Thx
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010


Return to General Excel Questions

Who is online

Users browsing this forum: Google [Bot] and 59 guests

cron