Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 11-11-2005, 12:51 PM
Novice
 
Join Date: Nov 2005
Posts: 1
bellest
Default Help w/ external data

Hi all,
I'm monitoring process variables in an injection molding plant.
I'm importing the data to Excel 2K by "querying" an external DataBase.
The software generating the database doesn't allow me to "name" or describe the data values I'm collecting.
Below is an example of the data. In the TagIndex column, I would like to automatically replace the numeric values with a text description.
Possible?

Thanks for your time,
T

DateAndTime TagIndex Val
11/11/05 2:00 PM 0 0.000
11/11/05 2:00 PM 1 0.000
11/11/05 2:00 PM 2 0.000
11/11/05 2:00 PM 3 0.000
11/11/05 2:00 PM 4 0.000
11/11/05 2:00 PM 5 0.000
11/11/05 2:06 PM 0 3.871
11/11/05 2:06 PM 1 8.056
11/11/05 2:06 PM 2 1853.250
11/11/05 2:06 PM 3 5.252
11/11/05 2:06 PM 4 8.392
11/11/05 2:06 PM 5 1787.438
11/11/05 2:12 PM 0 3.870
11/11/05 2:12 PM 1 8.062


11/11/05 2:12 PM 2 1849.125
11/11/05 2:12 PM 3 5.153
11/11/05 2:12 PM 4 8.294
11/11/05 2:12 PM 5 1772.625
11/11/05 2:16 PM 0 3.873
11/11/05 2:16 PM 1 8.056
11/11/05 2:16 PM 2 1862.813
11/11/05 2:16 PM 3 5.094
11/11/05 2:16 PM 4 8.226
11/11/05 2:16 PM 5 1789.688
11/11/05 2:21 PM 0 3.873
11/11/05 2:21 PM 1 8.056
11/11/05 2:21 PM 2 1856.813
11/11/05 2:21 PM 3 5.055
11/11/05 2:21 PM 4 8.201
11/11/05 2:21 PM 5 1771.500
11/11/05 2:27 PM 0 3.870
11/11/05 2:27 PM 1 8.139
11/11/05 2:27 PM 2 1848.563
11/11/05 2:27 PM 3 5.067
11/11/05 2:27 PM 4 8.255
11/11/05 2:27 PM 5 1793.813
11/11/05 2:32 PM 0 3.872
11/11/05 2:32 PM 1 8.191
11/11/05 2:32 PM 2 1854.750
11/11/05 2:32 PM 3 5.072
11/11/05 2:32 PM 4 8.210
11/11/05 2:32 PM 5 1824.375
Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -7. The time now is 06:44 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft