Column Difference

Help
1

How to get the column differences

Eg: I have 2 values like AA and AF

The difference between the column is 5

How to get the value like this?

Please help

2

@Sweety_Girl

dt.column.index("AF")-dt.column.index("AA")

1 Like
3

@Sweety_Girl Is “AA” and “AF” column Names or the Values in different Columns ?

1 Like
4

Its “AA” “AF”

5

No, It Doesn’t work

6

is AA is column name or cell reference?

1 Like
7

Cell Reference!!

8

Do you know the column names?
if yes then use
dt.column.index(“Column1”)-dt.column.index(“column2”)

1 Like
9

Its not working at my end,

Did that works for you??

10

@Sweety_Girl I think it should be :
dt.Columns.IndexOf(“ColumnName2”)-dt.Columns.IndexOf(“ColumnName1”)

But it Should be Column Names not Cell Reference

2 Likes
11

You need to write those column names there

1 Like
12

I am working in Cell referencing, Like using the loop up range and getting cell reference and processing…

So now I am getting two references like AA5 and AF5

I need the difference for AA and AF??

13

Hi
please refer this this will help you

and then use it for subtraction

14

@Sweety_Girl
How to you get the cell references ?

15

LookUp Range

16

@Sweety_Girl so you should be providing a lookup value as well in lookup range ?

1 Like
17

@Sweety_Girl

You can use this code.

LEtterToNumber.xaml (6.5 KB)

2 Likes
18

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.