473,386 Members | 1,803 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Replacement Of Numbers

Hello, I have an yellow area of numbers.

2 5
4 49
7 50
12 51
13 52
23 53
2 90 94 25 54
4 13 95 90 55
7 23 96 94 56
12 25 97 95 57
100 99 98 96 58
97 59
98 60
99 61
100 62

I would like to replace with one move each number.
So for example the area of numbers is:
2,4,7,12,13,23,25,90,94,95,96,97,98,99,I00, want to replace according to those rules:
If number 2 replace with 5
If number 4 replace with 49
If number 7 replace with 50 e.t.c. like green area
How can I do this in Excel?
Nov 20 '08 #1
1 1080
Stang02GT
1,208 Expert 1GB
Moving to Misc forum for the time being.
Nov 20 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Vibha Tripathi | last post by:
Hi Folks, I put a Regular Expression question on this list a couple days ago. I would like to rephrase my question as below: In the Python re.sub(regex, replacement, subject)...
18
by: talin at acm dot org | last post by:
I've been reading about how "lambda" is going away in Python 3000 (or at least, that's the stated intent), and while I agree for the most part with the reasoning, at the same time I'd be sad to see...
2
by: brian | last post by:
Hi, before coming to .NET, I utilized regular expressions mostly in JScript / JavaScript and also in my favorite text editor: TextPad (www.textpad.com) I don't know about JScript/JavaScript, but...
2
by: vishnu mahendra | last post by:
hello to all, Any one please tell me how to compare two variables or constants without using relational operations. thank you in advance, vishnu.
20
by: Paul D. Boyle | last post by:
Hi all, There was a recent thread in this group which talked about the shortcomings of fgets(). I decided to try my hand at writing a replacement for fgets() using fgetc() and realloc() to read...
14
by: windandwaves | last post by:
Hi Folk I want a random list of numbers between 0 and 58 where each number can only occur once. I have written this ($f is an array): for($i = 0; $i < 13; $i++) { $rand =...
1
by: lawrence k | last post by:
Want to replace the limit clause in a query, but can't get it right. What's wrong with this: $pattern = "(.*)limit (.*)"; $replacement = '$1'; $replacement .= "LIMIT $limit"; $replacement .=...
3
by: 2USERNAME2 | last post by:
I have a problem to code a page replacement algorithm simulation in VB.net (.net 2), I have the random numbers that represent the pages that will be used, and I have been able to put the first pages...
1
by: Francogrex | last post by:
Hi, I'm trying to sample without replacement some numbers (xons:70 values out of 1 to 200 and xEPS1cover:150 values out of 1 to 200). Then I'm trying to intersect both samples to see how many are...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.