Swap Numbers Or Data Around

Jul 30, 2013

I have let say column A and I have the date and name John 1913 all the way down to John 1940.

But what I need is a way to turn it around so A1 starts with John 1940 down to 1913.? If I drag down it counts up but I want it to count down if that makes sense.?

View 6 Replies


ADVERTISEMENT

Swap The Data Between Two Columns At A Time

Apr 19, 2007

Swap the data between two columns at a time. Here are multiple columns to be swaped in one worksheet and I have many worksheets to work with.

View 9 Replies View Related

Swap Last Name And First Name?

Aug 10, 2007

I have a huge xls of names setup as Last Name, First Name in a single column.

Any formula or somehow to change the entire column to read First Name Last Name. No comma.

Example -

Smith, Joe
Brown, Barry

-------------------------

Output desired -

Joe Smith
Barry Brown

View 8 Replies View Related

Swap Cells Across Row

May 16, 2008

I am attaching a sample sheet as a reference.

in fact the sheet could contain hundreds if not thousands of rows.

Look at column Player 1, the last 3 characters are AoS.

I want to find any rows where Player 1 has those three characters ( AoS ) and swap them with the contents of the Player 2.

BUT if that swap happens then the following swaps must occur as well:

Contents of Column "Side 1" swaps with Contents of Colum "Side 2"
Contents of Column "Player 1 Pts" swaps with Contents of Column "Player 2 Pts"

Ultimately I want this extended so that is the letters AoS appear in any of the following columns ( Player 4, Player 6, Player 8, Player 10)
the following swaps happens:

Contents of Column "Player 3" swaps with Contents of Column "Player 4"
Contents of Column "Side 3" swaps with Contents of Column "Side 4"
Contents of Column "Player 3 Pts" swaps with Contents of Column "Player 4 Pts"

Contents of Column "Player 5" swaps with Contents of Column "Player 6"
Contents of Column "Side 5" swaps with Contents of Column "Side 6"
Contents of Column "Player 5 Pts" swaps with Contents of Column "Player 6 Pts"

View 4 Replies View Related

Swap Values Of Two Cells

Aug 1, 2006

I want to swap values of two cells. can anyone help me on that? Eg. Cell A1
contains the value 20 & cell A2 contains the value 100. I want 100 on A1 &
20 on A2.

View 9 Replies View Related

Swap Columns In Formulas Around

May 12, 2013

I have column AD where there are something like 2,500+ formulas. I would like to change the columns used in the formulas around. By that I mean the first formula is...

Code:
=SUM(AA6-X6)
...and I would like it to be...

Code:
=SUM(X6-AA6)

Now the thing is, the formulas are not continuous, there are breaks where there is a formula to sum say the previous dozen or so for example, then it skips a couple of rows and I have more formulas and then the sum say for the previous dozen for example and so on.

I just want those cells changed with the particular formulas as above.

View 1 Replies View Related

Asset Swap Function

May 21, 2008

Have 5 columns (A1-E1) with different bond data: (respectively)
Coupon, Maturity, Settlement, Price, Yield (asset swap is F1)

Depending on the type of swap I am performing i want the ASWAP (user-created) function to reference different values within the row.

For example: Swap 1 = settlement, maturity, coupon, price, curve
(curve is a user input single number 1-3)

Swap 2 = settlement, maturity, yield, price, curve (yield in place of coup)

Swap 3 = settlement, maturity, yield, 100, curve (100 for par redemption)

etc. I won't type out all the iterations, not necessary.

The way that I want the ASWAP to recognize which Swap# to use is by inputting a number into a cell beside the Aswap column that I can input 1, 2, 3, etc., and then recalculate to get the desired outcome. Want to keep this a static reference as well as the price at par (each owning their own single cell, not a fill down the columns because there are too many).

So assuming G1 is the Swap# input, and H1 is 100...

How do i write a formula that is capable of reading the input in G1 and outputting the proper swap calc.

My gut feeling was along the lines of nested IF's with the corresponding formula... but i won't mess around in futility on here.

Let me know if this is too confusing without me putting up an example.

View 9 Replies View Related

Code To Swap Rows

Jul 19, 2007

I would like to insert a form control (up and down arrows) into a specfied range of cells in a column - ideally the first column. When the form control up or down arrow of the assigned row is clicked it moves that row up or down essentially swapping positions with the row directly above or below. I've seen this functionality in custom excel applications but my searches for code on this topic have been fruitless.

View 5 Replies View Related

Swap Ranges On A Worksheet

Nov 29, 2007

Right now I have 2 ranges say A and B. Range A is in a worksheet on row 7 and range B is on the same worksheet row 8. What I want to do is make it so that range B gets pasted in for range A and vice versa so that range A in now in row 8 and range B is in row 7.

View 2 Replies View Related

Swap Contents Of 2 Rows - VBA Excel

Jan 31, 2013

Swapping the contents of 2 rows, my code does the operation but it is very slow. Here is my code

Sub swap()

Dim aTemp() As Variant
Dim swap As Boolean
swap = False
Dim row As Integer
row = 19

[Code] .......

View 2 Replies View Related

Swap/Rotate Chart Axis

Aug 8, 2008

I am trying to chart a range of dates, for example. I have some boats that are on contract between dates a and b. I would liketo plot several boats with their contract date range. I have tried using a bar chart, but all the lines start at 0. I got it working using an Excel 2007 Stock chart, however, it is in the wrong orientation. I would like to Rotate the Chart 90 degrees, swap the axis, or find a better method all together. I cannot post the spreadsheet as its confidential.

View 2 Replies View Related

Pivot Table Chart - How To Swap X And Y Axis

Dec 4, 2012

My pivot table shows Towns as the Row headings and Month as the column headings. When I do a Chart, I get Towns on the X axis and Months as Y. I want the chart to show all my May data in a stacked column, then all my June data in another stacked column, etc. If I pick "Select Source Data" the options are greyed out. What's a mother to do?

View 1 Replies View Related

Swap Series In Stacked Area Chart

Sep 11, 2007

I have an interactive chart displaying stacked area charts for 2006 and 2007
I currently have 2006 in front of 2007, but as the user chooses 1 of 20 units, it will look better to move 2007 in front of 2006

View 4 Replies View Related

Swap Selected Visible Cells To Values To Right Of Selection

Feb 12, 2014

I am using the code below to "swap" the selected cell values in a column with the ones to the right of the selection. It works fine on unfiltered sheet, but if I apply an Autofilter, it copies both visible and hidden cells, and I only want to swap visible cells. What to modify?

[Code] .....

View 6 Replies View Related

Extracting Numbers From Text And Turning The Numbers Into Rows Of Data

Feb 23, 2010

The format of the text in which I need to extract numbers is as follows:

23411268 - 23411270

Need to extract the following:

23411268
23411269
23411270

These numbers have to be listed in three seperate rows.

View 14 Replies View Related

Swap Out Text In Text Box Based On Radio Button Selection

Dec 12, 2012

If the user selects French (radio button selection), I want to swap out the existing English text for French and vice versa. One large text box with several paragraphs. Can Excel do this?

View 2 Replies View Related

Swap 2 Mouse Click Selections After Resizing Selections

Jul 7, 2013

I am trying to take two random Mouse click selections and swap a set of ranges associated with the cells that are selected. For example if the user clicks on A1 it will resize(3,22) and store the selection as a variable to be swapped with another selection. Here is what I have so far but I keep getting a object required error on rngEmp1.

VB:
Sub SwapGroup()
If Selection.Cells.Count < 8 Then
MsgBox "Please Select two Groups to swap. Press and hold 'Ctrl' in between your selections", , "Swap Groups"

[Code] .....

View 4 Replies View Related

Function To Swap Text From Side To Side

Mar 1, 2014

I need function that swaps text from side to side. Text at the left of "x" should be placed at the right side of the "x" and from right to left side:

6x15 -> 15x6 plaah plaah xsomething -> somethingxplaah plaah How to do this?

View 4 Replies View Related

Index Function - Data Identified Based On A List Of Account Numbers And Return This Data To A New Sheet

May 8, 2007

I have a multiple column spreadsheet (Call it- "Money") whereby I need the data identified based on a list of account numbers and return this data to a new sheet.

In "Money" I have:

IE; columns B, C respectively have cust #A100 & 20.00
columns E, F respectively have cust #B100 & 40.00
columns G,H respectively have cust #C100 & 60.00
Etc.

(above for illustration-there are 100 lines of data in these columns with varied account numbers and respective dollars)

So what I have now is a new sheet I have named "Control". I have listed all my account numbers like A100,B100 etc. in column A. These are the account numbers for ident purposes.

I need the data entered in "Money" identified by those columns B,E,G with respective amounts from C,F,H and based on the list I have in "Control" whereby in "Control" if A100 is listed in column A then the figure to be returned in column B is all the data bits found in all columns C,F,H from the entire sheet "Money". Tough to explain but ie below....

View 17 Replies View Related

Find Whole Numbers In Row Of Data?

Apr 9, 2014

##UPDATED## Hello

understanding the IF forumlas to calculate rows with whole numbers in them for the last columns

CBOOK1.xlsxBOOK1.xlsx

View 5 Replies View Related

Sum Last Numbers In A String Of Data

Mar 31, 2014

I maintain a spreadsheet to track monthly sales of a few thousand items (see attached sample data). I'd like to have a formula that would sum only the last 12 months in the range of data. It would need to ignore all of the data before and the blank cells after the 12 months.

It's difficult to update the range each month for all of the products.

View 5 Replies View Related

Data Validation - Whole Numbers

Oct 2, 2007

how can I set a cell so that you can only type in 1 , 2 , 3, 4, 5

I know I can use the validation but people can just copy a cell and paste it over.

View 14 Replies View Related

Infinite Numbers Of Data

Feb 26, 2008

I have a problem with creating a spreadsheet.

I need a dialogue box, which asks the user the following:

* 1) Number of Plants
* 2) Number of Feeds
* 3) Total Daily Hazard (4*1)
* 4) Amount of Potentially Hazardous Food Daily
* 5) Excretion Rate Daily (% of Remaining)

I then need a table to show:

Along the top - The Number of Feeds (2)
Down the Side - The Number of Plants (1)

This is to show the amount of Potentially Hazardous material in each plant per day and also the amount of Potentially hazardous material in ALL the plants per day on the bottom line.

Simple? Well, my problem is that I need to create a loop which will work with the data potentially being infinite The Number of Plants (1), The Number of Feeds (2), could be anything from 1 to Infinity.

View 14 Replies View Related

Data Validation Allow Numbers Only

May 11, 2013

The numbers will be both negative and positive just need to catch characters.

So:

2500 is okay
-15 is okay
is not okay.

View 2 Replies View Related

Keep Data Entry Between 2 Numbers

Aug 24, 2006

I need to have a message box appear if a user tries to enter a value not between 992200000 and 992299999 in the range B11:B1182. I used the following code to test this out (only for B11).

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("B11").Value < 0 Then
If Range("B11").Value < 992200000 Or Range("B11").Value > 992299999 Then
MsgBox "Please enter the Associate ID"
End If
End If
End Sub

The problem is A: I need to apply this to every cell in the aforementioned range. And B: I need to only restrict this when there is a number in the cell (I tried to add the first If statement to do that, but it didn't work).

View 7 Replies View Related

Data Validation :: Letters Followed By Numbers

Sep 4, 2009

I currently have cell B3 in a worksheet - able to except 2 data entries.

The user should enter either OPQ or BOT followed by numbers. How do i ensure that they only enter OPQ (O - Letter Not Number) followed by numbers, or BOT (O - Letter Not Number) followed by numbers.

i.e. OPQ87654321 NOT 0PQ87654321 or BOT12345678 NOT B0T12345678. The information has to be entered manually and not via drop down list as each number is unique to the OPQ or BOT.

View 3 Replies View Related

Trying To Get Excel To Recognize Data As Numbers

Sep 25, 2013

I am trying to take a report that I can run and paste the data into excel. It is basically the same as if I went to a web page, and pasted some data into excel. Technically it pastes everything into 1 cell but I am able to break it up using Text to columns. The problem is that I have been unable to get excel to recognize the data as anything other than text (I.E, numbers and numbers and dates as dates). I've tried formatting cells and removing spaces.

View 2 Replies View Related

Trimming Data To Get Rid Of Spaces Between Numbers

Feb 6, 2013

I have a credit card number problem where I am trying to trim the data so that I get rid of the spaces between the numbers (number sequence look like this: 5999 9999 9999 9999. This is currently formatted as text, and I would like to maintain this as text and not convert it to a number. The trim function can't seem to get rid of the spaces.

View 4 Replies View Related

Data Validation Letters And Numbers

Apr 4, 2013

I want to create data validation so that the first 2 digits=PS and the next 4 digits will be numbers. I have tried a few things but I cant get anything to work?

View 8 Replies View Related

Data Validation: Allow Between 2 Numbers & Text

Nov 22, 2006

Is it possible to force a cell entry (using Data Validation) to either a whole number or a value? In other words, I would like the data in a cell to be either a whole number between 10,000 and 20,000 or "N/A". I can do it with VBA, but Data Validation (if it's possible) would be better.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved