# Convert Column Number Into Another Column Cell?

Dec 27, 2013

A column:
18
42
55
11
65
72
80
48
..

I want to put/write to B column the some numbers (42,11,72,48..) in A column.

B column:
=A2
=A4
=A6
=A8
..

How can I achieve it?

## Convert Column Number To Column Letter

Nov 20, 2009

in a macro i have this: col=cell.column 'suppose col=16384. then i need to place in a cell this formula =(XFD2708*100/XFD2597)-100 so i'm looking for "something" that can convert 16384 in XFD.

## Convert Column B As Multiple Column Titles And Move Data In Column C Into New Columns?

Jun 30, 2014

I have a excelsheet that looks like this:

Column A | Column B | Column C
Los Angeles | Fire Dept | 3
Los Angeles | Health Services | 12
New York | Fire Dept | 8
New York | Health Services | 22
New York | Internal Services | 100
New York | Public Works | 7
Chicago | Health Services | 15
Chicago | Public Works | 56
Chicago | Social Services | 4

And I am trying to make it look like this:

Fire Dept
Health Services
Internal Services
Public Works
Social Services

Los Angeles
3
12

New York
8
22
100
7

Chicago

15

56
4

## Convert Column Letter To Number

Nov 22, 2005

I need to convert a column letter to a column number for the following line of code in my VBA application:

VB:
strAverageBaseFormula = "=AVERAGE(D" & Trim(Str(lngFirstRowOfIncrement + 1)) & ":K" & Trim(Str(lngFirstRowOfIncrement + 1)) & ")"

I am inserting a formula into a cell using VBA, but the problem is that I don't know the letter value of column "K" (used in the middle of the line); instead, I know it as column number 11. Is there a simple way to convert the column number 11 to the column letter "K"?

## Convert The Data In Column B To Number?

Jul 30, 2014

convert the data in column B to Number so that i can perform action in Column D. see attachment for the query.

## How To Convert Column Contents To Number

Jan 4, 2014

Im trying to convert the data in certain columns to number. I need to select the rows in those columns based on the rows counted in another column with a different heading, this is because there can be breaks in the data half way down the columns.

The Code I have so Far is:

Code:
Sub ConvertTonumber()
'Convert Certain Columns to numbers
'Use the "x"column to Calculate how many rows are required to fill the columns.
Dim ColX As Range

[Code]....

## Convert Column Letter To Number

Nov 13, 2006

Some bits of code I have learned use column numbers and some bits use column letters.

Can someone share a line or two that I could add to my macro that will convert the F representing column F into a 6, and vice versa, so that I can continue using my pre-existing bits?

## Convert Column Number To Letter

Jan 17, 2004

I can obtain the columns numbers but I cannot get the letters. Is there anyway to convert from a number to a letter?

eg. somefunction(1) gives me column(A) as an answer?

## Method To Convert Column Number To Letter

Sep 15, 2014

I wanted to know if there was a way to either make a variable hold a column letter or else automatically convert a column number to a letter. This would be for use in the Range property.

All I could find is some complicated technique requiring division by 26 that I will never remember let alone code quickly.

Or if you have a variable holding a column number, is the only way to use it with Cells?

## Convert Integer Number To Column Alphabet?

May 8, 2014

I have M106 = 4

I need a simple formula to convert that into column Alphabet + 1

So 4 will be Column E (A,B,C,D and 4th will be D+1= E)

## Convert Column Number To Letter From A Range Objec

Jul 7, 2009

Is there an easy way (without writing my own conversion function) to get the column letter from a range object, as opposed to the column number?

## Compare Column Number Of Cell With Last Cell Column Number In Loop

Jan 11, 2014

I am trying to save an excel sheet to .csv format with the following macro:

[Code] ......

The following part of the code needs to be modified so that the commas appear correctly in .csv file even for null values for any given column.

[Code] .....

I have attached the Sample Sheets. Source sheet and the Result sheet. The Result sheet doesn't provide the required result. Some data are missing and unwanted commas have been added. How to correct the logic in the above piece of code.

Attached File :

Result Sheet.csv‎
Source.xlsm‎

## Every N-th Cell Value From A Column And Create Another Column Consisting Of Every 4th Number

Nov 5, 2008

I was wondering, is there a function that would take, lets say, every 4th cell value from a column and create another column consisting of every 4th number ?

## Column Number Of Last Column In A Row Where Cell Contents Greater Than 0

Jun 24, 2014

I have a spreadsheet with rows of data. I need a formula that will return the column number of the last column in a row where there is a value >0.

Let's say that cells A1:F1 contain values. Some have values of 0 while others have values >0. I need a formula in cell G1 that will tell me the column number of the last value >0.

A B C D E F
0 2 5 0 6 0

So the formula in G1 would return a value of 5, which corresponds to column E.

## Convert Values / Content In One Particular Column To Individual Column Heading?

Jan 29, 2014

The yellow highlighted column F (each Reason) in the sheet2 to be placed as main header in the next column and so on as seen in the sheet 3

If they have two similar item number with 2 different reasons - delete the duplicate item number and place the number in each column according to its reason as seen on row 16 on the sheet3

If they have two number with similar reason - just sum up the number

sample excel 2.xlsx

## Macro To Convert Multi-column Table To 3 Column List

Aug 2, 2012

a macro to convert this;

a
b
c
d

[Code]...

Into this;

x
a
9
x
b

[Code]...

So far I have the following, but this is not quite right!

[QUOTE][Sub ConvertRange()
Dim targetRowNumber As Long
targetRowNumber = Selection.Rows(Selection.Rows.Count).Row + 2
Dim col1 As Variant

[Code]...

/QUOTE]#

## Convert Column Of Dates Into Column Of Date Values?

Dec 9, 2013

In a worksheet, how do I convert a column of dates into a column of each date's numeric value?

## Convert A Column's Cell Formats

Oct 10, 2008

I have a column of about 1000 records. In each field is a long integer, that has been obtained through a concatenation formula. I have copied the results to a new column and used "paste special, values" to do so. I now have the results in a new column, but the cell format is text and is giving me an error. Even if I pre-format the cells that I will paste into to be a number they do not stay as a number after being pasted into, they still have an error.

I need to run a vlookup on these results but because of the error in the cells the vlookup wont work until they have been changed to a number format. I am able to change the format of the cells to number, no deciaml places, one by one. I have about 1000 records and need to be able to change the cells to number format in one go, as it is too time consuming otherwise.

If I change the format of the cells all together in one go to a number, they do not change unless you double click in them and press enter one by one. Is there a way to change the cell format for all the cells in one go without this laborious process?

## Convert Cell Values To Column Headings

May 2, 2013

I have a table in the format

User Application 1 Application 2 Application 3 ... Application N

ABC aaa bbb ccc ddd
XYZ bbb yyy
LMN ccc ddd

I want to convert it into :

User Application

ABC aaa
ABC bbb
ABC ccc
ABC ddd
XYZ bbb
XYZ yyy
LMN ccc
LMN ddd

Mar 12, 2014

I have a very large spreadsheet that is a consolidation of approximately 105 separate of contacts lists. The new consolidated spreadsheet contains demographic data, and a column for the name of each of the 105 lists. Each contact in the consolidated list had an "X" placed in the column if they were a member of that particular list. Each contact can be in more than one list. This is not very useful for me.

Here's a visual representation of the current list along with what I need:

FName
LName
Phone
City
List1
List2
List3
List4
List5
List6

[Code] .....

I would like to add a column to the spreadsheet and call it "Source"

And then have a macro or VB script to do the following:

1. As shown above, put the column name (ie "List2") in the "Source" column whenever there is an "X" in that row for the corresponding Column.
2. Because each contact can be in more than one list, I need to append the column names so that "Source" column contains all of the column names (Lists) that had an "X"
3. Once all of the list names have been added to the "Source" column, I will delete the list columns.

## How To Convert A Text From One Column To Another Column In A Different Way

Apr 26, 2014

I need to convert a text from one column to another column in a different way.

is there any automated way or function to convert

this - >This Text format to url format

into

this - >this-text-format-to-url-format

## Convert Multiple Column Into 1 Column

Sep 16, 2009

to move data from multiple columns and one single column

into 1 single column like this.

Can we do this with a formula?

## Lookup/Match: Compare A1 For The Values In Column B, Then Return The Corresponding Cell (column C) In Column D

Jan 31, 2008

I've been searching the forums for this problem but I can't seem to find any answers. Anyway, this is the problem. See screenshot.

I want to compare A1 for the values in column B, then return the corresponding cell (column C) in column D.
e.g. D1 = 2, D2 = 1, D3 = 4, D4 = 5 and D5 = 3.

## If Statement Limit Workarounds: Convert Various Codes From One Column Of Spreadsheet Into Different Codes In Another Column

May 5, 2006

I'm trying to convert various codes from one column of an excel spreadsheet into different codes in another column. I was able to accomplish this with "If" statements, however I'm only able to string together seven of these statements in one command. Is there a better way to add formulas for more than seven conversions? Below is a copy of what I've done so far with the seven converts:

=IF(ISNUMBER(SEARCH("WARN",J2)),"Warning",IF(ISNUMBER(SEARCH("PSSNAP",N2)),"Sales",IF(ISNUMBER(SEARCH("WARN",L2)),"Warning",IF(ISNUMBER(SEARCH("2699",L2)),"Warning",IF(ISNUMBER(SEARCH("4004",L2)),"Warning",IF(ISNUMBER(SEARCH("2036",L2)),"Warning",""))))))

I want to add about 15 more codes to convert within this formula but it's maxed out in the format I'm using.

## Conditional Formatting (largest Number In Column B The Hotel In Column A Should Be In Bold)

Oct 18, 2008

when the largest number in column B the hotel in column A should be in bold.

So in excel language IF(Number in B Is Max display corresponding hotel in column A as BOLD. But I can't figure out how to do this.

You can see here on the image:

## Range Object/property: Calculates 2nd Column Based On 3rd Column's Number

Jun 1, 2009

I'm trying to write a code that calculates 2nd column based on 3rd column's number or vice versa based on the condition set on the 1st column. Below, there are two procedures. "SimpleCalc" and "SimpleCalc2". I first wrote SimpleCalc2, but it isn't working, so I worked around the error by writing SimpleCalc, which selects a cell and moves around by offset. I personally find it hard to read and error prone as I develop more logic around it.

I'm trying to develop more function based on this code, so I need to make it neat and flexible. what I'm doing wrong in SimpleCalc2? Or do you have any suggestion to improve the code "SimpleCalc"? I'm using Excel 2003.

Sub SimpleCalc()

Dim SimpleMethodRng, SimpleMethod As String, i As Integer

ActiveWorkbook.Worksheets("Dashboard").Range("P5").Select

SimpleMethodRng = ActiveWorkbook.Worksheets("Dashboard").Range("N5:P12")

For i = 1 To 8

SimpleMethod = SimpleMethodRng(i, 1).........

## Add Number 1 In Adjoining Column When Existing Column Has Amount Highlighted In Green Or Red

Dec 27, 2012

I have a spreadsheet with sales which I colour green when they are outstanding and red when they are despatched. I would like to automatically add a 1 in an adjoining column when the cell is green (eg outstanding) or zero when they are despatched so that it totals up the number of outstanding orders.

a b

172.95 (this column would be green)
024.00 (this cell would be red)
124.00 (this cell would be green)
132.25 (this cell would be green)

## Find Cell Value Row Number & Use For Column Number

Jun 2, 2008

to update these values via a form in this sheet. I can find the correct row to be edited by entering a value from column A and B. The problem is if I want display the values of that row first and then change it. If I want to change row 10 data how can I bring back the value in ROW 3 AND THE COLUMN VALUE? The next step would be to do the actual update if I want to change ROW 10 to "Ooi" and a sales value of 200?

This is what I have done so far:

Dim myRows As Integer

With Sheets("Mrt")

'Retrieve history information for row
For myRows = 4 To 49
If comboxDay.Text = Range("A" & myRows).Value And textboxdescription.Text = Range("B" & myRows).Value Then
textboxbedrag.Text = Range("C" & myRows).Value
chkBTW_Ja.Value = Range("D" & myRows).Value
txtNota.Text = Range("S" & myRows).Value
End If
Next
End With

Picture attached to show how sheet looks like.

## Automatically Applying Custom Value / Number In One Column Dependent On Another Column

Apr 8, 2014

I work in a factory where we create different types of units daily. Below is a list of planned production on a specific date, say today's date. This is a very crude example, with information missing, and it is important to know that there are conditions attached such as:

The types are added randomly. The amount of types is much greater meaning that each type is on it's own page with breaks between. Everything produced on this date will have a URN (unique reference number) with its first 6 digits equating to yy-mm-dd and the last two being the position of the unit in the production sequence (first=01, second=02 etc).

I have gotten it to the point where if you enter them in sequence (Type A first for example) it will lookup to see the last assigned URN and taking the quantity into account issue the correct URNs.

The issues I have are when the URNs are less than "10", there is a problem displaying the 0 before the digit which disrupts the sequence. I can provide more clear examples if required.

Type A
Date08/04/2014
QtyURN
101314040801-03
203514040804-08
462114040809

123914040810-19
Total18

Type B
Date08/04/2014
QtyURN
245114040820

290114040821
689114040822

Total3

Type C
Date08/04/2014
QtyURN
1111414040823-36

211214040821-22
675514040823-27

Total21

## Formula That Advances Column Number While Being Dragged Down Single Column?

Jan 14, 2014

I am creating a tool that is populating information off of another excel document and presenting the information in a different format then the data originally appears. Basically I am unsure how to create a formula, for example, in cell A1, that as I drag it down (A2, A3, etc) the column letter in the formula advances but the row number remains the same. In another words as the formula moves into cell A2, the "Sheet1!D3" changes to "Sheet1!E3", where as normally it would advance to "Sheet1!D4". I just started back up in excel, im sure this is way easier then I am making it seem but I have been unable to come up with a solution.