Xls formula hepl again

Reply #9

frenchie — Tue, 20 Apr 2010 22:47:08 GMT

Thanks phileight.

Reply #8

phileight — Mon, 19 Apr 2010 23:47:38 GMT

Sorry Frenchie. I seem to be at a dead end. the user defined function will only modify the cell it is in. you need to do more than that.

my only option would be to put the line and col of your data in cells on line1 col 1 and 2 then line and col of where you want the output displayed in cells 3,and 4.

I don't believe you can write a formula for what you want.

Reply #7

phileight — Fri, 16 Apr 2010 10:38:09 GMT

sounds like what you need then is a user defined function. once it is set up you use it like any other function in excel. you still write the function using vba. may be able to get to that tonight

Reply #6

frenchie — Fri, 16 Apr 2010 01:55:33 GMT

HI phileight,

Thanks, It worked but the reason why I was asking for a formula is so I could change the formula around for different rows or columns to meet my needs.

I have data on more rows which I would copy down the formula and get my results for multiple reguests.

so if you can help on that or someone else, please do.

Thank you.

Reply #5

phileight — Wed, 14 Apr 2010 22:32:40 GMT

Frenchie

as written this will only deal with data on line 2. It is easily(for someone familiar with it)adaptable to other data.

if you learn some basic commands (program steps) its much easier than excels nested if/ and structure.

good luck

Reply #4

frenchie — Wed, 14 Apr 2010 03:51:37 GMT

Hi phileight ,

Thank you phileight for your answer, I'm gone try it and hope it's gone work with the rest of my datas, and yes I don't know nothing about macro that why I like to work with formulas for me it's easier,Thanks again.

Reply #3

phileight — Tue, 13 Apr 2010 10:56:33 GMT

Frenchie

i can't write that formula in excel. using a macro (program) its fairly easy. I assume you are not used to using macros.

open a new worksheet in excel. if you don't like this just don't save the file and its gone.

with worksheet open press alt f8 name the file duplicates and click on create then paste the following file on the line after sub duplicates() and before end sub

should look like this

Sub duplicates()

Dim dn(10)

For x = 1 To 10

a = Cells(2, x)

d... [ More ]

Reply #2

frenchie — Mon, 12 Apr 2010 04:41:50 GMT

Hi phileight,

Thank you to answer my post I really need help for this one.

I will explain better, I hope !!! ( sorry I'm French and my English is not as great as yours !!!).

Here is a little bit modified chart to see better.

A B C D E F G H I J

1 1 2 3 4 5 6 7 8 9 10

2 0 2 4 4 6 5 6 1 3 0

3

4

5 0 1 2 3 4 5 6

6

7 1 8 2 9 3 6 5

8 10... [ More ]

Reply #1

phileight — Sun, 11 Apr 2010 12:35:44 GMT

Frenchie

for this and you other question I don't understand what you are trying to do. your reference don't match the display. row 1 and 2 is fixed data. what is row 3, row 4 ,row 5. if you can explain what each of these represent then maybe we can help.

from your previous post conditional formatting is limited. if you want to learn to work with (program) macros fewer limits exist

Xls formula hepl again

frenchie — Sun, 11 Apr 2010 04:16:33 GMT

Hi everyone I need help also for this one wich is almost like my previous post but slitly different, I need to arrange the numbers a different way :

Here are the datas :

In Row 1 : A1: 1 ; B1: 2 ; C1: 3 ; D1: 4 ; E1: 5 ; F1: 6 ; G1: 7 ; H1: 8 ; I1: 9 ; J1: 10 ; ETC

In Row 2 : A2: 0 ; B2: 2 ; C2: 4 ; D2: 4 ; E2: 6 ; F2: 5 ; G2: 6 ; H2: 1 ; I2: 3 ; J2: 0 ; ETC

My question is can a formula make the duplicate of Row 2 become one, so it would look like this :

A2: 0 B2: 1 C2: 2... [ More ]