Excel Question

Reply #6

phileight — Fri, 15 Jul 2011 01:00:27 GMT

for a long time i hung onto win 98 and gwbasic because VBA intimidated me. Conditional formating was the straw that made me start using VBA. I credit Gasmeterguy's blog with the information on basic coding that let me get started. once I got started I realized that around 80% of the code was what I was already doing in GWbasic.

like most things the first few steps are the hardest

teamprofit your welcome

Reply #5

Teamprofit — Thu, 14 Jul 2011 04:04:22 GMT

The formula works... Thank you very much Phileight

Reply #4

omiller315 — Thu, 14 Jul 2011 00:20:04 GMT

Good code. I know what you mean about macros. I wanted to write VBA code for someone to do conditional formatting and they didnt want any part of it. I said that I didnt think it could be done without, but they didnt want macros. All they had to do was copy/paste amongst workbooks they wanted to use it in.

Reply #3

Teamprofit — Thu, 30 Jun 2011 13:24:47 GMT

Thanks, I will give it a try later on tonight.

Reply #2

phileight — Thu, 30 Jun 2011 00:52:09 GMT

this code will do what you asked

Sub compare()

' find matching # count seperation left to right

' always 6 #'s to check

For z = 1 To 6 ' start of loop to pick up reference #'s

a = Cells(1, z) ' the 1 picks row 1 z is which of the 6 #'s I'm looking for

For y = 1 To 6 ' start of 2nd loop

b = Cells(2, y) 'b has 1 of the 6 numbers from row 2. time to start checking

If b = a Then GoSub decide ' have found both #'s now what to do with them

Next y ' complete 2nd loop... [ More ]

Reply #1

phileight — Wed, 29 Jun 2011 23:05:58 GMT

there is too much decisiom making for a formula. A small macro(VBA program) could handle this problem. some folks here won't consider a macro, let me know if interested.

Excel Question

Teamprofit — Wed, 29 Jun 2011 05:14:23 GMT

Hey,

I wanted to know what formula can be used to count the difference of cells between two numbers repeated numbers in different rows?

For example...

10 14 19 2 5 32

2 5 19 14 32 10

I would like to know the how far apart each number from the top is from it's duplicate. If you count from left to right starting with the top number. The 10 is 5 columns to the right apart from the bottom 10 so my result is 5

Then basically do the same thing for every number, but... [ More ]